3 ms·
A little off-topic, but maybe someone can answer this. I sometimes use Excel when I want to see a CSV file formatted nicely, but apparently Excel has bad suppor
by fredsted 6y ago
A little off-topic, but maybe someone can answer this. I sometimes use Excel when I want to see a CSV file formatted nicely, but apparently Excel has bad support for CSV files, opening them unparsed (e.g. each line of the CSV taking up a single cell.) Apparently you have to use the "Import CSV" wizard. When building apps that export CSVs, many times customers have had issues with special characters appearing weirdly, so I've needed to format the files using some sort of DOS character set.
Apple Numbers and Quick Look opens CSV files without any issues whatsoever.
Why is CSV support in Excel so poor?
- Someone1234 6y ago> Why is CSV support in Excel so poor? CSV isn't a proprietary Microsoft format. In fact worse: It competes with Microsoft's proprietary formats. Microsoft would like everyone to be sending data to one another using xlsx, but not so much that they'll make generation/processing libraries and tooling free cross-platform, just enough to sabotage everything that isn't that. Microsoft made these decisions during their "evil" years, and never back-tracked. So regardless that CSV is used in multiple industries for data exchange (e.g. financial, order/invoicing, scientific, etc) they'll just keep on corrupting them until you use what they want you to use.
- taxcoder 6y agoMy assumption is that it is a low priority format for MS. Perhaps because it does not further .xls / .xlsx lockin, perhaps because most ordinary users rarely need to open a .csv file.