4 ms·
Excel has some major problems with CSV ingestion though I don’t think that this proposal will address those problems. Here are a couple of cases that I run int
by Tagbert 5y ago
Excel has some major problems with CSV ingestion though I don’t think that this proposal will address those problems.
Here are a couple of cases that I run into frequently:
* Excel is very aggressive about forcing type conversion based on its own assumptions. It will convert strings to dates or numbers, even if data is lost in the process. It will ignore quotes to convert long numeric IDs into scientific notation which truncates the ID unrecoverable.
* Excel cannot deal with quoted strings containing line breaks. It treats them as separate records and you get truncated records and partial records on separate rows.
- mark-r 5y agoMy two favorite problems with Excel automatic type conversions: Zip codes that lose leading zeros. Gene names that get converted to dates. The names of some genes were recently changed because too many databases were being corrupted by researchers using Excel to read CSV files: https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates https://www.theverge.com/2020/8/6/21355674/human-genes-renam...