Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel to csv
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel to csv
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. "Ashok" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |