3 ms·

Excel cannot guess the separators either! (How hard can it be?) What is the separator in this .csv file ;) 1,2;3,4;5,6 But on a more serious note, I complete

by dagw 3y ago

Excel cannot guess the separators either! (How hard can it be?) What is the separator in this .csv file ;) 1,2;3,4;5,6 But on a more serious note, I completely agree. There are so many small quality of life things that can and should be fixed in Excel, and it's baffling that they haven't.

M4v3R 3y ago
Sure, there are some edge cases where guessing the separator would be hard, but in 99% of cases you can correctly identify the separator pretty easily and in case you can't you just don't pre-fill that field in the import dialog.
- PTOB 3y ago
  Psst, the joke is that it's a "comma separated variable" file.
  - cxr 3y ago
    The V in CSV doesn't stand for "variable". And that wasn't the joke.
sroussey 3y ago
If the file ends in CSV then the comma is the separator (the C is CSV).
- dagw 3y ago
  Someone should tell the Excel developers, because they obviously didn't get that message. They use the .csv extension even when exporting files with ; separator.