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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 23, 2024

If not to change regional settings. In File->Options->Advances uncheck Use system separators and set your own. I guess in your case decimal separator shall be point and thousand separator is comma.

My default list separator is comma, thus I'm in opposite situation. To save csv with semicolons as separator I change on

Important

  • don't forget to return settings back after csv is saved (check Use system separators)
  • If your default number format is like 1.000,56 with above settings it'll be save in csv as 1,000.56. On the other hand in most cases such number shall be recognised correctly on machines with default comma as list separator.

If you import csv file in additional option to regional setting change exist. You may add first line to csv file as sep=,  (or sep=;) depends on what shall be recognised as separator

Resources