How to Query Webpages Using Excel

Printer Friendly
Text Size: A A A A

Excel users are usually required to import data from several sources. Web pages have become a common platform for corporate and non-corporate groups for presenting data. In this tutorial we will show you how to connect Excel to webpages that contains tables so you can get extract the tabular data from it.

To import data from Excel, click the Data menu > Import External Data > New Web Query:

Outlook

Enter the URL on the address bar then click go to display the page on the window. Click the arrow next to the table that you want to import then click the import button:

Outlook

Enter the worksheet where you want the data to appear then click OK:

Outlook

Presto! You?re done and should be able to see the tabular data appear on the sheet you specified above:

Outlook

If you need to re-synch the data with the page contents, just click Data > Refresh Data:

Outlook

This is way better than a simple copy-paste, isn?t it? Here are some benefits of using this method over copy-paste:

  1. the formatting is stripped out
  2. the importing is error free and you won?t worry about accidentally missing a row or a column
  3. you can refresh or synch the data by a click of a button.
LAST UPDATED 9/29/2009