msmemory_archive: (Default)
[personal profile] 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.

Date: 2008-02-29 08:58 pm (UTC)
From: [identity profile] oakleaf-mirror.livejournal.com
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.

Profile

msmemory_archive: (Default)
msmemory_archive

April 2011

S M T W T F S
     12
3456789
10111213141516
17181920212223
24252627282930

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 2nd, 2025 01:57 pm
Powered by Dreamwidth Studios