Re: converting .xls to delimited file - Mailing list pgsql-novice

From Jason Earl
Subject Re: converting .xls to delimited file
Date
Msg-id 20010110145542.91618.qmail@web10014.mail.yahoo.com
Whole thread Raw
In response to converting .xls to delimited file  (William Staniewicz <wstan@localhostnl.demon.nl>)
List 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@localhostnl.demon.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/

pgsql-novice by date:

Previous
From: David Merrill
Date:
Subject: Re: converting .xls to delimited file
Next
From: Alfonso Peniche
Date:
Subject: Re: converting .xls to delimited file