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.
That works when you have access to a SQL database instead of a bunch of massive CSV files.
cracks knuckles
import pandas as pdNow you’re speaking my language!
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.
Importing CSV into SQL is trivial and gives you far more control than Excel can.