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] dryfoo.livejournal.com 2008-02-29 10:50 pm (UTC)(link)
Actually, you know what, it's easier to just do it than to try to explain it if I can't show you in person. So if you go to my website dryfoo.com, there's a file jwaks-awards.xls which is all done for you. You'll have to find something else for your snowy Saturday, I guess, but it took me, like maybe five minutes, and you shouldn't have to muck around for a couple of hours on it.

-- G

[identity profile] msmemory.livejournal.com 2008-02-29 10:53 pm (UTC)(link)
Thank you to both you and [livejournal.com profile] metahacker, I now have two copies in Excel! I guess I'll just bake banana bread and curl up with hot coffee in the morning.