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

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

1

Open Microsoft Excel 2007.

2

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

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, then select the "Import" button at the bottom of the window once all your required data has been downloaded.

5

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

Tip

  • check After you import your Web page data, an "External Data" toolbar will open. From this menu, it is possible to edit your Web query, change any of your data properties or refresh the information that you have downloaded.

About the Author

Matthew Burley has been a writer of online content since 2005. You can view many of his articles on associatedcontent.com. Burley holds a Bachelor of Science in political science from Arizona State and a Master of Science in computer information systems from the University of Phoenix.

More Articles