Extracting Data from Internet in Excel 2007

Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc.

Go To Data tab -> From Web. Enter the url of the webpage where table is stored and follow directions. You will have data in your excel sheet.

Related Posts

Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email will not be published. Required fields are marked *

*
*