0

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma?

I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats parameters panel, I set the delimiter I wanted and then created the CSV file. That didn't work.

Specifically, I'm looking for a way to force the French version (Excel 2007) to export CSV with comma delimiter instead of semicolon.

Do you have any ideas?

yo_haha
  • 103

1 Answers1

2

List separator set in Language & Region settings will not work if you have Decimal Separator set to same character.

So if you have , set as decimal separator set there - you cannot have , as list separator and Excel will use default ;.

You have to use . as decimal separator or write some macro that will save your document in desired format.

Kamil
  • 2,686