ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert to cvs(,) from excel (https://www.excelbanter.com/excel-discussion-misc-queries/141307-convert-cvs-excel.html)

John

convert to cvs(,) from excel
 
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[_2_]

convert to cvs(,) from excel
 
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?
--
David Biddulph

"John" wrote in message
...
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 !




John

convert to cvs(,) from excel
 
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

"David Biddulph" wrote:

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?
--
David Biddulph

"John" wrote in message
...
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 !





Dwight[_2_]

convert to cvs(,) from excel
 
Try saving as CSV(MS-DOS). This saves a file with the "," delimiter.

dwight


"John" wrote in message
...
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[_2_]

convert to cvs(,) from excel
 
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?
--
David Biddulph

"John" wrote in message
...
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

"David Biddulph" wrote:

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?
--
David Biddulph

"John" wrote in message
...
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 !








All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com