Convert to CSV file

A

adelkoh

I am trying to convert Excel file format to pure CSV format. I saved it as .csv, but when I open it again, it still appears as in Excel form with the cells and so on. How do I convert it to get it in pure CSV form with the commas and so on? Does anyone know how it can be done or if this is possible?
 
A

AlfD

Hi!

You probably have converted it. Try reading the file with a tex
processor (e.g. Notepad) rather than letting Excel open it.

Al
 
P

Paul Falla

Hi there

If you open the csv file in a text editor such as Notepad
then you will see that Excel has saved it in pure csv
format. If you are not happy with the way that Excel does
things then save the file as a csv the change the file
extension to .txt and then open it in Excel. This will
invoke the import text wizard.

Hope this helps

Paul Falla
-----Original Message-----
I am trying to convert Excel file format to pure CSV
Click to expand...
format. I saved it as .csv, but when I open it again, it
still appears as in Excel form with the cells and so on.
How do I convert it to get it in pure CSV form with the
commas and so on? Does anyone know how it can be done or
if this is possible?
 
Top