1. 17
  1.  

  2. 4

    The idea is good but… It’s almost like the whole point of spreadsheets are to have a powerful way of manipulating data that doesn’t require much programming skills but still can do a whole lot of value adding.

    Of course you can do all the summations using a range of command line tools… But does it really but pressing ALT and =?

    I remain a bit doubtful for the approach :)

    1. 3

      For doing calculations my approach is to import the CSV/TSV into SQLite and query it there. It’s remarkably faster than importing into a spreadsheet program and doesn’t have arbitrary row count limitations.

      1. 3

        I didn’t know that was possible… Seems like a nice feature to know about. For future reference 1 is a link to the documentation about importing and exporting CSV files. For TSV files, see 2

        1. 2

          Years and years ago, I was cooking up a Django project that would read in downloadable CSV bank statements from my online bank.

          The purpose was this, but as the statement downloads can’t be automated and banks have been improving their reporting features, the project dwindled off.

          Being able to query by SQL or Django admin is a superpower, though.

          This Vim TSV business might be better suited for eg. how translators sometimes use CSV/TSV as an interchange format.

        1. 1

          Installed csv.vim and was a bit dismayed it didn’t adjust column widths automatically by the longest contents. Couldn’t figure out the wizard either, but it could potentially be the droid I’m looking for!

        2. 1

          I feel so seen, I’m doing some editing in excel this morning and I feel way out of my element unable to use vim.