4 ms·
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
by jstanley 2y ago
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.
- shawabawa3 2y agoCan you import .jsonl files into Google sheets or excel natively?
- freehorse 2y agoImporting 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.
- codetrotter 2y agoFor example: Scientists rename genes because Microsoft Excel reads them as dates (2020) https://www.reddit.com/r/programming/comments/i57czq/scientists_rename_genes_because_microsoft_excel/ https://www.reddit.com/r/programming/comments/i57czq/scienti...
- TRiG_Ireland 2y agoI was so glad of that story. It gave me something to point to to get my boss off my back.
- phkahler 2y agoBut it handles it better than Json.
- freehorse 2y agoDepends 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.
- xnx 2y agoExcel dropping leading zeros (as in ZIP codes) was a crazy design decision that has certainly cost many lifetimes of person-hours.
- disgruntledphd2 2y agoAnd forcing 16+ digits to be floats, destroying information.
- freehorse 2y agoYeah have had similar struggles with social security numbers.