Microsoft KB Archive/183491

= XL98: How to Import Web Page Tables into Microsoft Excel =

Article ID: 183491

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q183491



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.
 * 1) Select the tags that create the table.

The  tag identifies the end of the table.
 * 1) Copy the tags you selected in step 3. (In SimpleText, click Copy on the Edit menu.)
 * 2) Start or switch to Microsoft Excel 98 and create a new workbook or open an existing workbook in which to paste the table.
 * 3) On the Edit menu, click Paste.

Additional query words: XL98

Keywords: kbhowto kbweb KB183491

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.