This article originally appeared in TidBITS on 1996-04-29 at 12:00 p.m.
The permanent URL for this article is:
Include images: Off

Excel, HTML Tables, and You

by Geoffrey V. Bronner

One of the basic tools most HTML authors look for is a simple table editor to spare them the annoying task of constructing HTML tables by hand. Since I generally handle the data I use for HTML tables in Excel spreadsheets, I find an Excel add-in to be a great solution, and this article looks at two commonly available tools that work with any version of Microsoft Excel 5.0 (or Excel 7.0 for Windows 95). The first is the shareware eXcel Table Markup Language (XTML) 1.3 by Ken Sayward; the second is Internet Assistant for Microsoft Excel, a free add-in wizard from Microsoft.


Neither of these add-ins does everything, but both work with a minimum of fuss. You get what you pay for: Microsoft's free solution provides some interesting options, but the $7 shareware fee for XTML provides a fast-evolving product that's more compatible with non-Microsoft Web browsers. I looked at an older version of XTML some time ago and discarded it, but now that I have taken a second look I'll be registering my copy.

Both add-ins work the same way: you select a range of cells and then use the Tools menu to access the add-in. The add-in then uses the range to create an HTML table. I won't go into a blow-by-blow comparison of every feature, but here's an overview of some key differences:

I started this article as a review of Internet Assistant for Microsoft Excel and only later looked at the most recent release of XTML. Microsoft released Internet Assistant with almost no fanfare; I found out about it when I saw a brief mention of it in MacWEEK. It looked like (and is) a good way to generate HTML tables without buying an expensive special purpose application.

What I wanted was a simple way to keep table data in Excel, create HTML from that on demand, and then copy and paste it into existing HTML files in BBEdit. This means I don't care if I can define custom titles, headers and footers. Internet Assistant can combine the exported table with an existing HTML file by using a special HTML tag, which seems like a great feature, but I found it of no particular value in my work.

In my opinion, XTML does the job best because it exports cleaner HTML. Not only does it avoid proprietary HTML tags, but the preferences let me make the exported HTML look like the stuff I write myself. I spend little or no time altering its exported HTML.

If you use Excel and need to generate HTML tables once in a while, get Internet Assistant for free from Microsoft's Web site and you'll be all set. But if you need a tool you can use regularly, the $7 for XTML is money well spent. The products happily coexist, so don't hesitate to make your own comparison.