4 ms·
It actually depends of the locale of the system. If you are on a French windows, it will use semi-colons as separators, encode in window cp1252 (close to latin
by byroot 11y ago
It actually depends of the locale of the system.
If you are on a French windows, it will use semi-colons as separators, encode in window cp1252 (close to latin1 but not exactly) and use CRLF (\r\n) as line returns.
But then if you use Excel for Mac 2008, Excel will generate CSVs in MacRoman (old OS9 encoding) and use CR (\r) as line returns.
Long story short Excel is not even interoperable with itself when you use CSVs. (Granted there is an advanced import tool, but it's a nightmare for the average user).
https://fr.wikipedia.org/wiki/MacRoman https://fr.wikipedia.org/wiki/MacRoman
- nness 11y agoWow, never realised it was that complicated. Although the locale dependant separators make a lot of sense.