Microsoft Office Tutorials and References
In Depth Information
Retrieving web data using Excel
Retrieving web data using Excel
The World Wide Web is a great source of information. From
stock quotes to product descriptions, many companies publish
useful information on their websites. The most common
structure used to present financial information is the table, which,
like a spreadsheet, organizes the data into rows and columns.
Excel 2013 makes creating a web query easy by letting you
copy data directly from a web page into Excel and then create a
query to retrieve data from the table that you copied.
Retrieve data from web pages
1 Click the Data tab.
2 Click Get External Data.
3 Click From Web.
4 Type the address of the web page you want.
5 Click Go.
(continued on next page)
Search JabSto ::

Custom Search