Comment on "POSSIBLE DATA LOSS" (Excel reports, when you save a CSV)
dohpaz42@lemmy.world 3 days ago Yeah, CSV is an archaic data format that lacks a lot of important nuances; like understanding that not everything is done the same way everywhere around the world.
I guess one viable alternative would be to use tabs for delimiting the data, since (afaik) tabs are not commonly found in normal spreadsheet data (I admit that I could be wrong).
undefined@lemmy.hogru.ch 3 days ago
I’ve messed with both. But yeah, keeping an international mind is best. Separators are really unnecessary for data transfer so I usually just exclude them.
But yeah, one quirk is for Excel to recognize a date it has to be
YYYY-MM-DD 12:00 PMbecause it doesn’t understand ISO-8601. 😓