Microsoft Office Tutorials and References
In Depth Information
You can use Excel to query Web data so you can
analyze the Web data in Excel. You can find structured
data in many forms on the Web, including online Excel
worksheets. Excel considers ordinary Web pages
structured if they contain tabular content — that is,
rows and columns of numbers or other data.
Excel gives you two options for opening and using
Web-based tabular data. You can click the Office
button and then click Open. The Open dialog box
appears. Type the Web address in the File Name field
and then click Open. Or, click the Data tab and, in
the Get External Data group, click the From Web
option to query a Web page.
Both techniques allow you to view and edit numbers,
but querying a Web site has advantages. Importing
data as a query enables you to filter the data,
viewing only records of interest. A query also lets
you refresh data if it is subject to updates. With the
data in Excel, you have complete access to data
analysis and presentation tools, including functions,
PivotTables, and charts.
Open a new Excel worksheet.
Click the Data tab.
Click From Web in the Get
External Data group.
The New Web Query dialog box
Type the Web address for the site
from which you want data.
This example uses www.fec.gov/