Microsoft Office Tutorials and References
In Depth Information
Import Data from a Web Page
Chapter 7: Importing Data into Excel
The Import Data dialog
0 Select the Existing
If you want the data to
appear in a new sheet,
you can select the New
! Click OK.
Excel imports the data to
Besides the steps you learned in this section, Excel gives you two other methods for
creating Web queries. Both of these alternative methods assume that you already have
the Web page open in Internet Explorer:
● Right-click the page and then click Export to Microsoft Excel.
● Copy the Web page text, switch to Excel, and then paste the text. When the Paste
Options smart tag appears, click the smart tag drop-down arrow and then click
Refreshable Web Query.
Each of these methods opens the New Web Query dialog box and automatically loads
the Web page.
If you want to save the Web query for future use in other workbooks, click the Save
Query button in the New Web Query dialog box and then use the Save Workspace
dialog box to save the query file.