XL97: How to Import Web Page Tables into Microsoft Excel

This article was previously published under Q165499
This article has been archived. It is offered "as is" and will no longer be updated.
You can import tables from Web pages into Microsoft Excel 97. This articlediscusses two methods you can use to accomplish this task.
Microsoft Excel 97 can interpret tables from Web Pages because it candetect and recognize HTML tags. However, some HTML tags will be ignored byMicrosoft Excel 97. The tags that will be ignored by Microsoft Excel 97 arethe tags that involve graphics, animation, forms/controls, and so on.

Use one of the following methods to import a table from a Web page intoMicrosoft Excel 97.

Method 1

You can copy and paste tables from Web Pages to Microsoft Excel 97.Microsoft Excel 97 will correctly interpret HTML code from the Clipboardand create the table in your worksheet. To do this, use the followingprocedure:
  1. Locate the Web Page containing the table that you want to copy.
  2. View the source (the HTML code) for the Web Page in a text editor.

    NOTE: the procedure to view the source will be different for each Browser.

    For example, to view the source using Microsoft Internet Explorer version 3.0 (IE3), click Source on the View menu. This will open Notepad, displaying the HTML code.
  3. Select the code that creates the table. The <TABLE> tag identifies the beginning of the table and the </TABLE> tag identifies the end of the table.
  4. Copy the selection you made in Step 3. (In Notepad, click Copy on the Edit menu.)
  5. Start Microsoft Excel 97 and open a new workbook (or an existing workbook) to paste the table into.
  6. On the Edit menu, click Paste.

Method 2

You can open a Web page that contains tables in Microsoft Excel 97.Microsoft Excel 97 will recognize the Web page and correctly display thetable(s). To do this, use the following procedure:
  1. On the File menu, click Open.
  2. In the File Name edit box, type the complete HTTP address of the Web Page containing the table(s) you want to import.

    For example, you might type something like the following:
    NOTE: This is a fictitious Web site. It is provided for illustration only.
  3. Click OK.
For more information about returning data from HTML tables, click the Indextab in Microsoft Excel 97 Help, type the following text
and then double-click the selected text to go to the "Return only the datain an HTML table or all of the information on a Web page" topic.

Article ID: 165499 - Last Review: 12/04/2015 16:36:48 - Revision: 1.0

Microsoft Excel 97 Standard Edition

  • kbnosurvey kbarchive kbhowto KB165499