how can I convert a XLS file into a CSV file
 

I have a program that uses CSV files. when I need to adapt the configuration,
i open it in excell and save it as a xls file, but xls files are not accepted
in my program.
When I save my XLS file as CSV I receive a message and I can't use this new
file in my program. Until now I have used a free trial program to convert
between CSV and XLs, but I think it is very expensif.

You save it in Excel as a CSV (Something.csv). You then close the file, go
into Explorer and rename it to .txt (Something.txt).

You have to be sure that you are using the correct character count, file
setup etc, especially if your other program is eg Pastel, which program's
help file is pathetic on this subject!

"Wikke" wrote:

I have a program that uses CSV files. when I need to adapt the configuration,
i open it in excell and save it as a xls file, but xls files are not accepted
in my program.
When I save my XLS file as CSV I receive a message and I can't use this new
file in my program. Until now I have used a free trial program to convert
between CSV and XLs, but I think it is very expensif.

Are you actually choosing comma separated value (CSV) as the file type by
going through FileSave As, or are you just changing the extension from XLS
to CSV?

Another question is whether the file is laid out properly for CSV - i.e., in
table format like a database


"Wikke" wrote:

I have a program that uses CSV files. when I need to adapt the configuration,
i open it in excell and save it as a xls file, but xls files are not accepted
in my program.
When I save my XLS file as CSV I receive a message and I can't use this new
file in my program. Until now I have used a free trial program to convert
between CSV and XLs, but I think it is very expensif.

Another question: have you tried opening both the problem files and the files
you converted with the trial program in Notepad, to see if there's an obvious
difference?


"Wikke" wrote:

I have a program that uses CSV files. when I need to adapt the configuration,
i open it in excell and save it as a xls file, but xls files are not accepted
in my program.
When I save my XLS file as CSV I receive a message and I can't use this new
file in my program. Until now I have used a free trial program to convert
between CSV and XLs, but I think it is very expensif.