excel to 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?

 

[Guest]

Excel has .csv as one of the 'Save As' options under the File menu item.

Just type your information into Excel just as you want it to be laid out in
the .csv file and then use File | Save As and choose the
CSD (Comma Delimited) (*.csv)
choice in the Save as Type list in the file save dialog box.

The double quote marks will NOT be added except where they are required for
that type of file format. Normally the double quotes are only added to
surround text that contans a comma as part of the text itself. Example:

In Excel:
Smith, John mypassword
in the .csv file it would appear as
"Smith, John",mypassword

If the double quotes are must-haves, then simply make them part of the text
you've typed into the Excel cells.

You can examine the contents of a .csv file to see what it actually looks
like by opening it with any simple text editor such as Notepad or Wordpad.