How to Download Data From the Web to Excel

By Matthew Burley

Microsoft Excel is a spreadsheet program that is part of the Microsoft Office productivity suite. While its primary use lies in storing and comparing data in a tabular format, it provides some other useful tools as well, such as the ability to import data from other locations. Fortunately, Excel is compatible with a variety of different file types that can easily be imported into the Excel file format structure.

Download Data from the Web to Excel 2003

Step 1

Open Microsoft Excel 2003.

Step 2

Select the "Data" option from the toolbar at the top of the screen, select "Import External Data," and then select "New Web Query."

Step 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.

Step 4

Click the yellow arrow(s) located next to the information that you wish to download into Excel.

Step 5

Select the "Import" button at the bottom of the window once all your required data has been downloaded.

Step 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

Step 1

Open Microsoft Excel 2007.

Step 2

Click the "Data" tab at the top of the screen, then select the "From Web" button in the "External Data" section.

Step 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.

Step 4

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.

Step 5

Select the location on your worksheet into which the data will be downloaded, then click the "OK" button.

×