Best Excel to HTML converter?
January 12, 2006 1:13 PM Subscribe
Excel's built-in conversion to HTML results in a monstrosity of a web page. Can anyone recommend the best "scrubber" or converter utility that does the best job (Windows or Mac)?
Dean Allen's Word HTML Cleaner should do the job. I'm assuming all Office products add the same sorts of junk to their HTML. That may be a flawed assumption so if it doesn't work the easy way, try importing the Excel doc into Word, then saving it as a web page, then running the cleaner.
posted by Hildago at 2:10 PM on January 12, 2006
posted by Hildago at 2:10 PM on January 12, 2006
Though this is overkill for what you want, I thought I'd mention that Dreamweaver also has HTML cleaners (on its Commands menu).
posted by grumblebee at 3:30 PM on January 12, 2006
posted by grumblebee at 3:30 PM on January 12, 2006
voidcontent: I'm not the poster but I've experienced this before. Word and Excel both created bloated HUGE html pages full of extraneous markup and all kinds of other crap.
posted by RustyBrooks at 3:41 PM on January 12, 2006
posted by RustyBrooks at 3:41 PM on January 12, 2006
Oh... and this might not help you but I'm an emacs user and I just made some simple macros to clean up stuff like that. Whatever editor you have might have a similar ability to make macros or do scripting. If you have access to a programming language that you know, it's not too difficult of a task.
posted by RustyBrooks at 3:42 PM on January 12, 2006
posted by RustyBrooks at 3:42 PM on January 12, 2006
OK.... try HTMLtidy, like this standalone version.
posted by voidcontext at 4:59 PM on January 12, 2006
posted by voidcontext at 4:59 PM on January 12, 2006
No, do not use the
A copy and paste (or an import of a tag-separated value file) into BBEdit can be instantly converted into a table with valid HTML. (Select All; Markup → Tables → Convert to Table.) This gets complicated if you have merged cells, admittedly.
(The free text editor from Bare Bones Software may also do it.)
posted by joeclark at 3:48 PM on January 14, 2006
pre
“tag” for a table. You are smart enough to know that Excel’s native HTML stinks, so you are presumably smart enough to know that table
≠ pre
(in the way that blockquote
≠ indention).A copy and paste (or an import of a tag-separated value file) into BBEdit can be instantly converted into a table with valid HTML. (Select All; Markup → Tables → Convert to Table.) This gets complicated if you have merged cells, admittedly.
(The free text editor from Bare Bones Software may also do it.)
posted by joeclark at 3:48 PM on January 14, 2006
This thread is closed to new comments.
What do you need to converter to do? How complex is your spreadsheet? Is it just a simple table?
posted by voidcontext at 1:42 PM on January 12, 2006