this post was submitted on 29 Aug 2024
307 points (93.5% liked)

Memes

45192 readers
2005 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
307
I hate excel so much (lemmy.dbzer0.com)
submitted 3 weeks ago* (last edited 3 weeks ago) by [email protected] to c/[email protected]
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 6 points 3 weeks ago

Not saying there's any reason to switch, but I believe you can load CSV's into sqlite.

Datasette would be something that I would try for CSV's as well, that seems like an interesting piece of technology I haven't had reason to use yet.

Finally there's always Jupiter Notebook and any respectable DataFrame-solution.

Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I'd probably reach for a tool I could combine with some form of VCS like Git at least.