Re: converting .xls to delimited file

From: Jason Earl <jdearl(at)yahoo(dot)com>
To: William Staniewicz <wstan(at)localhostnl(dot)demon(dot)nl>, pgsql-novice(at)postgresql(dot)org
Subject: Re: converting .xls to delimited file
Date: 2001-01-10 14:55:42
Message-ID: 20010110145542.91618.qmail@web10014.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


The easiest way to convert an Excel file to a
delimited file would be to open the file in Excel and
save it as "Formatted Text (Tab Delimited)" or "CSV
(Comma Delimited)" file. If you need to make the
conversion on a *NIX box take a look at Gnumeric. It
does a very good job (in my experience) of reading
Excel files, and it can then save those files in a
variety of text-based formats.

Once the file is in some sort of text based format you
can use a wide variety of tools to further process it
(including sed).

I hope this is helpful,
Jason Earl

--- William Staniewicz <wstan(at)localhostnl(dot)demon(dot)nl>
wrote:
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
> Bill
>

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Browse pgsql-novice by date

  From Date Subject
Next Message Alfonso Peniche 2001-01-10 15:32:18 Re: converting .xls to delimited file
Previous Message David Merrill 2001-01-10 13:37:02 Re: converting .xls to delimited file