HTML text to Office table

[msmemory_archive]

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.

Comments

well...

[capt-elias.livejournal.com]

I do this all the time...
I just click drag to sleect the table cells

and then paste it right into Word.

It works a treat for me.

Re: well...

[capt-elias.livejournal.com]

Whoops I did not read through... my apologies...

Its just text, right?
Spaces format the text?

I copy the text to a notpad.
then I perform the following replacements:
replace all (space)(space) with (tab)
replace all (tab)(tab) with (tab)
replace all (tab)(space) with (tab)
(ctrl-h brings up the edit-replace dialog in Note pad)

then copy paste it into EXCel

It works in most cases.
You could probably write a word macro that does this but why bother unless you have to do this all the time?

Re: well...

[capt-elias.livejournal.com]

Looked at the page you referred to...
All you have to do is copy it to Notepad, replace all double spaces with a tab, copy it and paste it right into an EXcel table.
I just did that, and it worked great.