Helpdesk Baruch College

Replicate Website Tables right into Excel 2007 Spreadsheets

If you discover intriguing or important information in a table on a site it may be valuable to import it into Excel. Today we will check out just how to import information from a table on a site into Excel which will certainly allow you to arrange and also contribute to records.

Open up Excel 2007 as well as under the Data tab pick Get External Data as well as From Web.

This will certainly open the New Query window where you enter in the URL of the website you wish to obtain data from. There will be yellow arrowhead icons next to the table data that can be imported, click the areas of the information you want to import which turns package to a green checkmark. After you have what you want selected click the Import button.

Following pick the cell where you want the information to show up in the spread sheet as well as click OK.

The data will certainly begin to be retrieved from the site, the quantity of time it takes will depend on the amount of information you selected. Currently you can arrange the data how you like for discussion.

This tip can be found in extremely helpful when doing research or for quickly including internet site table data to records.

Exit mobile version
Skip to toolbar