Retrieving Web Data from Excel
The World Wide Web is a great source of information. From stock quotes to product descriptions, many companies publish useful information on their Web sites. The most common structure used to present financial information is the table, which, like a spreadsheet, organizes the data into rows and columns. Excel 2007 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 you copied.
Retrieve Data from Web Pages
Click the Data tab.Click From Web.
Type the address of the Web page you want.
Click Go.
Click the yellow boxes with ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
