To create a web query, choose Data->Import External Data->New Web Query from the menu bar. This action will display the New Web Query window.
At the top of this window, you will see an address bar, back and forward buttons, stop and refresh buttons, and a save button. The New Web Query window is very much like a web browser. If you type a URL (web page address) in the Address field, the web page will be loaded into the web query window so you can view it. If you click on a hyperlink, the target of the link will be loaded in the window just like a web browser. You can navigate through visited pages by using the backward and forward buttons. You can even load your favourite search engine and perform web searches from within the New Web Query window.
After you load a web page, you will notice yellow highlighted arrows pointing to different areas of the page. These arrows indicate the data that Excel can import.
You can click these yellow highlighted arrows to select the given data to be included in your web query. Excel is quite good at importing tables of data, and normally there will be an arrow pointing to every table on the web page that can be imported. You can import a single table, multiple tables, or plain text with a web query. When you click an arrow, it will turn into a green highlighted checkmark. Only the data indicated by checkmarks will be imported to your Excel worksheet.
When the data you need has been selected with checkmarks, click the Import button to enter the data into your Excel worksheet. You will be then be asked to specify a location in the worksheet for the imported data.
|
