Article ID: 165499 - View products that this article applies to.
This article was previously published under Q165499
You can import tables from Web pages into Microsoft Excel 97. This article discusses two methods you can use to accomplish this task.
Microsoft Excel 97 can interpret tables from Web Pages because it can detect and recognize HTML tags. However, some HTML tags will be ignored by Microsoft Excel 97. The tags that will be ignored by Microsoft Excel 97 are the tags that involve graphics, animation, forms/controls, and so on.
Use one of the following methods to import a table from a Web page into Microsoft Excel 97.
Method 1You can copy and paste tables from Web Pages to Microsoft Excel 97. Microsoft Excel 97 will correctly interpret HTML code from the Clipboard and create the table in your worksheet. To do this, use the following procedure:
Method 2You can open a Web page that contains tables in Microsoft Excel 97. Microsoft Excel 97 will recognize the Web page and correctly display the table(s). To do this, use the following procedure:
For more information about returning data from HTML tables, click the Index tab in Microsoft Excel 97 Help, type the following text
htmland then double-click the selected text to go to the "Return only the data in an HTML table or all of the information on a Web page" topic.
Article ID: 165499 - Last Review: May 8, 2002 - Revision: 1.0
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.