4 ms·
I have long suspected that Excel's treatment of CSV files was intentionally antagonistic. For example, opening a CSV file will start an importer function where
by ndespres 6y ago
I have long suspected that Excel's treatment of CSV files was intentionally antagonistic. For example, opening a CSV file will start an importer function where you must specify how fields are delimited within the file, and "comma" is not automatically selected, ever, despite "comma-separated" being literally named in the file extension.
Surely the folks programming it are not that short-sighted. It's just a punishment for not using their default format.
- rightbyte 6y agoWell I would give Excel some cred for acctually following local number conventions. It the beginning there was no internet and interoperability issue. Usually it is the us-en way or the highway.
- kalleboo 6y agoIt also has really broken handling of text encodings. I've taken to importing CSV files using Apple Numbers, and saving as Excel (i use Numbers primarily, Excel is just when I need to be interoperable with someone else)