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 10:19 pm (UTC)
From: [identity profile] mayica.livejournal.com
Here's how I do it:
Save the file. Open it in Word (you need to look at "All Documents," not jus "ALl readable docs") and Save as.. a text file. CLose the file, and open it in Excel. Tell the importer that it's a fixed width file, and it'll work.

This worked 'cause the first field, date, was always the same width. It's a lot more of a pain if that's not true.

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. 1st, 2025 07:56 pm
Powered by Dreamwidth Studios