Get and Analyze Data from the Web in Excel 2000



Get and Analyze Data from the Web in Excel 2000

From

Create Your Own Web Query

First, it's a good idea to have in mind the Web site from which you want to get data, and to have the address of that Web site. Then, open the workbook with the worksheet where you want to display the data. When you're ready, follow these steps:

1. On the Data menu in Excel, point to Get External Data, and then click New Web Query.

2. In the first section of the New Web Query dialog box, type or paste an address for the Web page. Or, if you don't have the address, click the Browse button to start your browser, locate the page you want, and switch back to Excel using ALT+TAB. The address will be automatically filled in for you.

3. In the second section of the New Web Query dialog box, choose the data you want returned:

The entire page returns text, tables and other data on a page (does not include graphic images). Choose this option when the page contains just the data you want and does not include advertisements, banners, navigation buttons, or other elements that may clutter the worksheet or that Excel may not be able to interpret properly.

Only the tables returns all tables or preformatted () sections on the page. Use this option when you do not want to import advertisements, banners, navigation, or other elements on a page.

One or more specific tables on a page returns only the table(s) that you specify. Use this option when you want data out of a specific table or tables only. To specify which tables to return, enter table numbers separated by commas (such as 2, 3, 4 to return the second, third, and fourth tables on the page) or enter table names in quotation marks, separated by commas (such as "Table 1","Table 2"). You can specify the tables - and preformatted sections (), which are recognized as tables - by counting them or by entering their names if they are defined on the Web page. You may need to view the HTML source code to determine the table name or number. The table name is defined on the Web page by the ID tag in the TABLE attribute (for example, ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download