XL98: How to Import Web Page Tables into Microsoft Excel

This article was previously published under Q183491
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
You can import tables from Web pages into Microsoft Excel 98 MacintoshEdition. This article contains information about how to do this.
MORE INFORMATION
Microsoft Excel 98 can interpret tables from Web pages because it candetect and recognize Hypertext Markup Language (HTML) tags. However, someHTML tags are ignored by Microsoft Excel 98. The tags that are ignored byMicrosoft 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 Clipboardand 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.
XL98
Properties

Article ID: 183491 - Last Review: 10/07/2013 21:18:47 - Revision: 1.0

  • Microsoft Excel 98 for Macintosh
  • kbnosurvey kbarchive kbhowto kbweb KB183491
Feedback