Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new Web query, follow these steps:

Click the From Web command button in the Get External Data group on the Data tab.

Excel opens the New Web Query dialog box containing the Home page for your computer’s default Web browser.

To select the Web page containing the data you want to import into Excel, you can do either of the following:

Either type the URL in the Address text box at the top of the New Web Query dialog box and click the Go button, or use the Search feature to find the Web page containing the data you wish to import. Excel indicates which tables of information you can import from the displayed Web page into the worksheet by using a yellow box with an arrowhead pointing right.

Click the yellow box next to each of the tables you want to import.

Click the yellow box next to each of the tables you want to import.

When you click a yellow box, it changes to a green box with a checkmark.

Click the Import button.

Excel closes the New Web Query dialog box and then opens the Import Data dialog box.

Select to place the data in the Existing Worksheet or in a New Worksheet, and then click OK.

Select to place the data in the Existing Worksheet or in a New Worksheet, and then click OK.

Excel closes the dialog box and then imports all the tables of data you selected on the Web page in the New Web Query dialog box.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: