How to convert an Excel file to CSV File

D

Damu

IS there anyway to convert an excel file into comma delimited file - I
used the Save as and CSV file format, but that didnt help much.

Any other options/ways we can do this.

Thanks,
Damu
 
D

David McRitchie

"Damu"...
IS there anyway to convert an excel file into comma delimited file - I
used the Save as and CSV file format, but that didnt help much.

hi Damu,
Worksforme, what did it do instead for you.
If you view it in Excel it is going to look like nothing changed.

View the created .csv file with Notepad such as right click
on the file from Explorer (File Manager) and View with Notepad
my sample test below with some of it generated as random data.

A1-2,B1-1,C1-1,D1-1,E1-1,F1-1,G1-1,H1-1,I1-1
A2-2,F,A,G,A,D,B,H,G
A3-2,A,11,75,58,8,7,F,F
A4-2,H,29,4,74,17,96,H,D

When creating a CSV it will only convert a single worksheet,
so you probably want to make sure that you save your workbook
first and once you've created the CSV file that you immediately
exit out of Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top