Excel – How to put data from a web table into Excel

microsoft excelmicrosoft-office-2007

I'm trying to build a spreadsheet from a few different webpages that have data in a table format.

How do you put data from a web table into Excel?

Best Answer

What you want is a web query. It can be set up to be live (automatically refreshed) or manually refreshed.

In 2003, it's under the Data menu, then Import External Data, New Web Query.

Enter the web address, then find and click on the table to import.

Alternatively, you can copy the static table data. In IE, right-click and Export Table to Excel. In Firefox, you will need an extension like Table2Clipboard.