How to Download Data From the Web to Excel

Download Data from the Web to Excel 2003
1. Open Microsoft Excel 2003.
2. Select the 'Data' option from the toolbar at the top of the screen, select 'Import External Data,' and then select 'New Web Query.'
3. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.
4. Click the yellow arrow(s) located next to the information that you wish to download into Excel.
5. Select the 'Import' button at the bottom of the window once all your required data has been downloaded.
6. Select the location on your worksheet into which the data will be downloaded, then click the 'OK' button.
Download Data from the Web to Excel 2007
7. Open Microsoft Excel 2007.
8. Click the 'Data' tab at the top of the screen, then select the 'From Web' button in the 'External Data' section.
9. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.
10. Click the yellow arrow(s) located next to the information that you wish to download into Excel, then select the 'Import' button at the bottom of the window once all your required data has been downloaded.
11. Select the location on your worksheet into which the data will be downloaded, then click the 'OK' button.