Question: how to extract data from excel online?
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.