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.
mikekn: (Just me)

[personal profile] mikekn 2008-02-29 09:18 pm (UTC)(link)
I do this with Excel a lot. Select the table in your browser, copy, go to Excel and select paste special... HTML.

[identity profile] capt-elias.livejournal.com 2008-02-29 09:39 pm (UTC)(link)
You guys missed that it is not an HTML Table... (so did I in my first post...)