Re: converting .xls to delimited file

From: "Brian E(dot) Pangburn" <bepangburn(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: converting .xls to delimited file
Date: 2001-01-10 12:49:11
Message-ID: 93hlo8$2bc7$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Excel 2000 has two options:
1. Select "Save-As" and then select "Save at type" = "Text (Tab delimited)"
2. Select "Save-As" and then select "Save at type" = "CSV (Comma delimited)"

If I remember correctly, earlier versions of Excel have similar options.

Hope this helps.

Brian E. Pangburn

"William Staniewicz" <wstan(at)localhostnl(dot)demon(dot)nl> wrote in message
news:200101101026(dot)f0AAQfB16474(at)mail(dot)postgresql(dot)org(dot)(dot)(dot)
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
> Bill
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Francis Duggan 2001-01-10 13:32:03 Creating a database
Previous Message Ryan Mahoney 2001-01-10 12:17:23 Re: Re: starting PGSQL automatically on Redhat 6.2

Browse pgsql-novice by date

  From Date Subject
Next Message David Merrill 2001-01-10 13:37:02 Re: converting .xls to delimited file
Previous Message Tom Lane 2001-01-10 05:14:04 Re: pattern matching