Page 645 - Excel 2013 All-in-One For Dummies

home page for your computer’s default web browser (Internet Explorer 10 in most cases).
To select the web page containing the data you want to import into Excel, you select or type the URL web address of the website containing the data you want to import in the Address text box at the top of the home page in the New Web Query dialog box, as in
http://money.msn.com
If you’ve visited the website before, you can select its URL address by click- ing the drop-down button attached to the Address text box and then clicking it in the drop-down list.
When you have the main page of the website displayed in the New Web Query dialog box, you can use the site’s links to find the page that actually contains the data tables you want to import. Excel indicates which tables of information you can import from the web page into the worksheet by adding a check box with an arrowhead pointing right. To import these tables, you simply select this check box to add a check mark to it. (See Figure 2-11.)
External Data Query 627
Figure 2-11:
Selecting stock data tables to import from the MSN Money web page into Excel.
After you finish checking all the tables you want to import on the page, click the Import button to close the New Web Query dialog box. Excel then opens a version of the Import Data dialog box, where you indicate where the table data is to be imported by selecting one of the following two option buttons:
Book VI Chapter 2
Filtering and Querying a Data List