4 ms·

Can you import .jsonl files into Google sheets or excel natively?

• freehorse 2y ago
  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.
  • codetrotter 2y ago
    For 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 ago
      I was so glad of that story. It gave me something to point to to get my boss off my back.
  • phkahler 2y ago
    But it handles it better than Json.
    • freehorse 2y ago
      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.
      • d0mine 2y ago
        In practice, web browsers accept the tag soup that is sometimes called html and strict xml-based formats failed.
        • afiori 2y ago
          The browser are not a database (unlike excel). Modifying data before showing it is reversible, modifying it before storing it is not.
  • xnx 2y ago
    Excel dropping leading zeros (as in ZIP codes) was a crazy design decision that has certainly cost many lifetimes of person-hours.
    • disgruntledphd2 2y ago
      And forcing 16+ digits to be floats, destroying information.
    • freehorse 2y ago
      Yeah have had similar struggles with social security numbers.