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

"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.

Excel 2002 Getting data from the Web in Excel
Excel 2003 About getting data from a Web page
Excel 2007 Get external data from a Web page

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."

Found a video that explains it for Excel 2000, but Excel 2007 is basically the same.

You can take any html file with table, rename it with a "*.xls" extension, and Excel will happily open it up as if it were a native document.
You can take any html file with table, rename it with a "*.xls" extension, and Excel will happily open it up as if it were a native document.

"This will sometimes work:

Select the web page text in your browser
In a blank Excel worksheet, hit Control + A to highlight all columns and rows
From the menu, choose Edit > Paste Special and choose unformatted text
If it says the areas aren't the same size and shape, tell it to paste anway

If you're lucky, the data will end up in proper columns and rows. You can then re-copy and paste it wherever you want it."