Forum Discussion

Copper Contributor

Nov 22, 2024

Solved

Save as CSV file

When saving a sheet in text format (.csv) several options are proposed : coma delimited (CSV-UTF-8) semi-colon delimited Problem is that either one you use they are always saved as semi-colon del...

excel

Lorenzo
Nov 23, 2024
On Windows there isn't any option to choose the Delimiter when saving as CSV UTF-8
The Delimiter is auto. set based on Windows Regional Settings. My installation Regional Settings is English (United Kingdom), with this the CSV Delimiter is the comma. If my Regional Setting was French (France) the CSV Delimiter would be the semi-colon

Lorenzo

Silver Contributor

Nov 23, 2024

On Windows there isn't any option to choose the Delimiter when saving as CSV UTF-8

The Delimiter is auto. set based on Windows Regional Settings. My installation Regional Settings is English (United Kingdom), with this the CSV Delimiter is the comma. If my Regional Setting was French (France) the CSV Delimiter would be the semi-colon

Mau

Copper Contributor

Nov 23, 2024

This is in fact the only option that works

The advanced setting option proposed in Excel does not

The additional line sep=, does not either

Thank you all !

SergeiBaklan
Diamond Contributor
Nov 24, 2024
Mau , that is quite strange. To be sure

With EXPORT excel to csv

For semicolons separated csv file

Decimal separator is point

Thousand separator is comma

For commas separated csv file

Decimal separator is comma

Thousand separator is point

With IMPORT by opening csv by Excel

first line sep= says Excel what to consider as separator.

All above is known for years, if something doesn't work in your case that's quite interesting why.