Microsoft Office Tutorials and References
In Depth Information
Getting Data from a Web Page
Getting Data from a Web Page
This tip describes three ways to capture data contained on a Web page:
h Paste a static copy of the information.
h Create a refreshable link to the site.
h Open the page directly in Excel.
Pasting static information
One way to get data from a Web page into a worksheet is to simply highlight the text in your
browser, press Ctrl+C to copy it to the Clipboard, and then paste it into a worksheet. The results
will vary, depending on what browser you use. If you use Microsoft Internet Explorer, the pasted
results will probably look very similar to the original — complete with formatting, hyperlinks, and
If you use a browser other than Internet Explorer, choosing Home
Paste might put
everything you copied from the Web page into a single cell — probably not what you want. The
solution is to choose Home
Paste Special and then try various paste options.
Pasting refreshable information
If you need to regularly access updated data from a Web page, create a Web query. Figure 176-1
shows a Web site that contains currency exchange rates, in a three-column table.
These steps create a Web query that allows this information to be retrieved and then refreshed
at any time with a single mouse click:
1. Choose Data
Get External Data
From Web to display the New Web Query dialog box.
2. In the Address field, enter the URL of the Web site and click Go.
For this example, the URL for the Web page shown in Figure 176-1 is
Notice that the New Web Query dialog box contains a minibrowser (Internet Explorer). You
can click links and navigate the Web site until you locate the data you’re interested in.
When a Web page is displayed in the New Web Query dialog box, you see one or more
yellow arrows, which correspond to various elements in the Web page.
3. Click a yellow arrow, and it turns into a green check box, which indicates that the data in
that element will be imported.
Search JabSto ::

Custom Search