Forum Discussion

Mau's avatar
Mau
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's avatar
    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

Mau's avatar
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's avatar
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.

Resources