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
[–] 3 points 2 months ago (3 children)

That is interesting. It’s been a llng time since I’ve used Excel or CSV, but I could’ve awore that you just needed to set some option to quote everything and that would allow commas in the data; i.e. “One, two, and three”,”something else”,”1.320,42”

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 3 child comments
    •
  • [–] 3 points 2 months ago* (2 children)

    I’m a web developer that lets people export to CSV and quoting things is usually the answer. Though for a number with a comma in it I’d rather not quote it and leave it as a bare integer/decimal so that the data type is correctly inferred.

    Speaking of, I have a handful of hacks I do specifically for Excel so that it infers types correctly — it needs more prodding than other applications importing CSV.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 3 points 2 months ago (1 child)

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

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 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