Wednesday, October 22, 2008

Copy table data from a web page to Excel

If you see a data table on a Web page and you want to import it into Microsoft Office Excel:

1. Copy the URL (address) of the page.
2. In Excel, on the Data tab, in the Get External Data section, click From Web.
3. In the New Web Query dialog box, paste the URL into the Address box.
4. Select the table that contains the data you want to work with, and then click Import.
5. In the Import Data dialog box, indicate where you want the data to appear, and then click OK.

From Microsoft Tips & Tricks

No comments: