Jump to content

Convert an Excel Table To Simple HTML


Recommended Posts

Convert an Excel Table To Simple HTML

In Excel 2000, is there any easy way to save a block of rows and columns as a simple HTML table? I regularly get Excel spreadsheets that I need to publish to the Web, but I don't want all the extra formatting junk that Microsoft embeds to make the file specific to Internet Explorer. I just want the basic HTML, which I'll adjust in my Web editor.

When you save a workbook as HTML, Excel does indeed dump in a load of extra formatting. I don't see any way to avoid that, but you can create your unformatted table in a few simple steps.

Save the Excel file as tab-delimited text, and load the resulting file into Word. Search for tab (^t) and replace each occurrence with </TD><TD>. Search for end-of-line (^p) and replace each instance with </TD></TR>^p<TR><TD>. You now have an extra <TR><TD> on a blank line at the bottom, and the same text missing at the start of the very first line. Move the extra text to the beginning of the first line. Add the <TABLE> tag at the top and </TABLE> at the end and you're ready to copy the document into your HTML page.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...