SEARCH

How-To Geek

Copy Website Tables into Excel 2007 Spreadsheets

If you find interesting or important data in a table on a website it might be helpful to import it into Excel.  Today we will look at how to import data from a table on a website into Excel which will allow you to organize and add to reports.

Open Excel 2007 and under the Data tab select Get External Data and From Web.

 Data From Web

This will open up the New Query window where you enter in the URL of the site you want to get data from.  There will be yellow arrow icons next to the table data that can be imported, click the areas of the data you want to import which turns the box to a green checkmark.  After you have what you want selected click on the Import button.

Select Table 

Next choose the cell where you want the data to appear in the spreadsheet and click OK.

select Cell

The data will begin to be retrieved from the site, the amount of time it takes will depend on the amount of data you selected.  Now you can organize the data how you like for presentation. 

data

This tip comes in very handy when doing research or for easily adding website table data to reports.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 05/21/09

Comments (1)

  1. Bo

    Thank you. Now that I have the information in my spreadsheet, I want to add some cells together. Unfortunately, the “add” formula does not recognize the numbers in the two cells. The “sum” appears as “#NAME?”. It’s as if Excel doesn’t see the contents of the cell as a number but as something that cannot be added. Please help.

Enter Your Email Here to Get Access for Free:

Go check your email!