msmemory_archive: (Default)
msmemory_archive ([personal profile] msmemory_archive) wrote2008-02-29 03:40 pm

HTML text to Office table

O mighty intarweb: Is there a quick way to take data that are in html, laid out visually like a table but actually simple text, and import it into a Word or Excel table, with the data properly separated into table columns? I know several brute force ways, but am I missing a friendly little tool that'll do it quick?

ETA: I'm trying to take this data (http://op.eastkingdom.org/Awards/Pelican.html and Laurel.html and Chivalry.html) and put it into a single grand date-sortable table. I figure this is a nice little project for a snowy Saturday morning.

[identity profile] oakleaf-mirror.livejournal.com 2008-02-29 08:58 pm (UTC)(link)
Partly depends how the data come out of the HTML. Excel should be able to import both comma and tab separated lists. If cutting and pasting the HTML leaves distinct markers between the columns, it should be trivial to filter that into commas or tabs, if those aren't already there.