export as csv

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ashok - 29 May 2006 08:25 GMT

I have excel sheet with text in it.
I have to export or save it as csv file so that all the columns are
separated by comma and values in columns are enclosed in quotes.
The csv file should be like:
Name,"Password"
John Doe,"home"
Jane,"butterfly"
Johnson,"12jhn15"
Richard,"hamlet"
Laura,"34LB12JM"

How can this be achieved?

Reply to this Message

Pete_UK - 29 May 2006 12:00 GMT

With your file loaded in Excel, use File | Save As and scroll through
the File Type options until you find .csv.

You should be able to verify the format by loading the .csv file into
Notepad afterwards.

Hope this helps.

Pete

Reply to this Message

Ashok - 29 May 2006 12:08 GMT

Thanks, I was verifying it in excel itself, which showed the same structure
again.

> With your file loaded in Excel, use File | Save As and scroll through
> the File Type options until you find .csv.
[quoted text clipped - 5 lines]
>
> Pete

Reply to this Message

Rate this thread: