3 ms·

> no standard column separator Commas are the standard column separator in CSV files, its in the name.

• Shank 11y ago
  I'll give the author the benefit of the doubt; Excel appears to export by default using tabs as delimiters, not commas: https://support.office.com/en-za/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba#bmchange_the_delimiter_that_is_used_in_ https://support.office.com/en-za/article/Import-or-export-te...
  • pieterr 11y ago
    From your link (top of page): TAB is used for .txt files, and a comma for .csv files by Excel.
  • 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 ago
      Wow, never realised it was that complicated. Although the locale dependant separators make a lot of sense.