Hacker News Reader

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.

View on HN

It 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)

Well 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.

Reply on news.ycombinator.com