Re:A love letter to the CSV format
by jstanley on Wednesday March 26, 2025 @05:37PM
(#43487642)
You claimed that CSV is "easily the most widely supported data format in existence in terms of tools and language support", which is a claim that CSV is better supported than JSON, which is a claim that JSON support is lacking.
[ Parent
| on HN ]
Re:A love letter to the CSV format
by shawabawa3 on Wednesday March 26, 2025 @05:48PM
(#43487779)
Can you import .jsonl files into Google sheets or excel natively?
Importing csvs in excel can be a huge pain due to how excel handles localisation. It can basically alter your data if you are not mindful about that, and I have seen it happening too many times.
Excel dropping leading zeros (as in ZIP codes) was a crazy design decision that has certainly cost many lifetimes of person-hours.
Re:A love letter to the CSV format
by disgruntledphd2 on Thursday March 27, 2025 @03:24AM
(#43491177)
And forcing 16+ digits to be floats, destroying information.
Yeah have had similar struggles with social security numbers.
Re:A love letter to the CSV format
by codetrotter on Wednesday March 26, 2025 @07:01PM
(#43488467)
For example:
Scientists rename genes because Microsoft Excel reads them as dates (2020)
https://www.reddit.com/r/programming/comments/i57czq/scienti...
Re:A love letter to the CSV format
by TRiG_Ireland on Thursday March 27, 2025 @06:46PM
(#43499102)
I was so glad of that story. It gave me something to point to to get my boss off my back.
But it handles it better than Json.
Depends on what you mean by "better". I would rather software not handle a piece of data at all, than handle it erroneously and changing the data without me realising and thus causing all sorts of issues after.
In practice, web browsers accept the tag soup that is sometimes called html and strict xml-based formats failed.