Forum Discussion
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 delimited.
How can we save a sheet as coma delimited ??
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
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
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
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 !
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.
