Question: how to extract data from a url in excel?
Answer: Open a worksheet in Excel.
From the Data menu select either Import External Data or Get External Data.
Select New Web Query.
In Excel XP: Enter the URL of the web page from which you want to import the data and click Go. ... 
In Excel 2000: ... 
Choose how often you want to refresh the data.