On the Data menu, point to Import External Data, and then click New Web Query.

In the New Web Query dialog box, enter the URL address of the web page from which you want to get data. You can type a URL address, copy and paste it, or click the arrow next to the address list to select a recently used address.

Click "Start".

Start in the browser

In the browser, browse the web page where you want to query data.

Click the arrow ... button next to Edit Method, which may appear as one of the icons of the application depending on how the webpage is created, and then click Edit with Microsoft Office Excel.

Click Select Table next to the table you want to import, or click Select Table in the upper left corner of the page to import the entire page.

If the table next to a table on the page is not selected, click the show icon show/hide icon at the top of the dialog box to make it appear.

The Web query is automatically saved with the worksheet. If you want to save the query to run in another worksheet, click Save Query to save the query. The query will be saved with. Iqy extension.

To set the format and import options for how to return data, click Options and select the options you want in the Web Query Options dialog box.

Click "Import".

In the Import Data dialog box, do one of the following:

To return the data on the Web page to the selected worksheet, click Existing Worksheet. In the worksheet, click the cell in the upper left corner where you want to put the external data range, and then click OK.

To return the data to a new worksheet, click New Worksheet, and then click OK. Excel will add a new worksheet to the workbook and automatically use the upper left corner of the new worksheet as the beginning of the external data range.

After clicking OK, a rotating refresh icon refresh indicator will be displayed on the status bar, indicating that the query is running. To check the status of the query, double-click the refresh icon.