XL98: How to Import Web Page Tables into Microsoft Excel

Article translations Article translations
Article ID: 183491 - View products that this article applies to.
This article was previously published under Q183491
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SUMMARY

You can import tables from Web pages into Microsoft Excel 98 Macintosh Edition. This article contains information about how to do this.

MORE INFORMATION

Microsoft Excel 98 can interpret tables from Web pages because it can detect and recognize Hypertext Markup Language (HTML) tags. However, some HTML tags are ignored by Microsoft Excel 98. The tags that are ignored by Microsoft Excel 98 are the tags that identify graphics, animation, forms, or controls, and so on.

You can copy and paste tables from Web pages to Microsoft Excel 98. Microsoft Excel 98 correctly interprets HTML code from the Clipboard and creates the table in your worksheet. To do this, follow these steps

  1. Locate the Web page that contains 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 is different for different Web browsers.

    For example, to view the source in Microsoft Internet Explorer version 4.0, click Source on the View menu. This displays the HTML code.
  3. Select the tags that create the table.

    The <TABLE> tag identifies the beginning of the table, and the </TABLE> tag identifies the end of the table.
  4. Copy the tags you selected in step 3. (In SimpleText, click Copy on the Edit menu.)
  5. Start or switch to Microsoft Excel 98 and create a new workbook or open an existing workbook in which to paste the table.
  6. On the Edit menu, click Paste.

Properties

Article ID: 183491 - Last Review: October 7, 2013 - Revision: 1.0
APPLIES TO
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbnosurvey kbarchive kbhowto kbweb KB183491

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com