7
"POSSIBLE DATA LOSS" (Excel reports, when you save a CSV) (lemmy.ca)
submitted 2 months ago by to c/rant@lemmy.sdf.org
7 comments fedilink hide all child comments
 

Yeah, I get it... the formatting goes away... why so alarmist? And is the formatting really "data" anyway?

you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 2 months 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.

One quirk I remember for Excel to recognize a date it has to be YYYY-MM-DD 12:00 PM because it doesn’t understand ISO-8601. 😓

  • permalink
  • fedilink
  • source
  • parent