convert to cvs(,) from excel

[John]

I want to convert from excel to text file (CVS(,)). I use save as change to
CVS but I could not able to, Pls advise me !

 

[David Biddulph]

Perhaps you don't mean CVS, but CSV (Comma Separated Variables)?

Yours is another of those posts which expects a certain clairvoyant ability
from readers of this group. You say "I could not able to", but if you want
us to help, you will have to give us a better idea of what the failure
symptoms are. What error message are you receiving? Did it produce a CSV
file? If so, did you look at the CSV text tile with a text editor (such as
Notepad) to see what was in it? If so, how did the contents differ from
what you were expecting?

 

[John]

Hi David

Thanks for your reply.

My question is

My Excel data file to convert Text CSV(,), I did following step: -
Save as - change file type to CSV (Comma delimited) and save. I
could not able to save as text file with comma. Only can save as Excel file
with column. I tried to copy & paste on notepad. I could able to copy with
space instead of comma. Pls help me to advise.

Thanks
JOHN

 

[Dwight]

Try saving as CSV(MS-DOS). This saves a file with the "," delimiter.

dwight

 

[David Biddulph]

Let me ask again the questions you didn't answer:

You saved as CSV. Did you get an error message?
Did the save produce a CSV file?
Did you look in the CSV file *with Notepad* (*not* with Excel) to see what
was in the file?
If so, what was the difference between what was in the file and what you
expected?