export as csv

[Ashok]

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?

 

[Pete_UK]

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

 

[Ashok]

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