When I was working in academia, early on I decided I would finally buckle down and learn proper devops and scripting (e.g. how to do things at the command-line)

When I was working in academia, early on I decided I would finally buckle down and learn proper devops and scripting (e.g. how to do things at the command-line) and had the luxury of having all the time I wanted to bikeshed on automating the collation process (never did master Make syntax though!). The csvkit toolset – particularly `in2csv` [0] and `csvsql`, which, respectively, can be used to extract CSV from Excel sheets and import/insert directly into sqlite – make frequent appearances in my daily work these days. Though admittedly, I don't know what options there are to distangle spreadsheets that aren't just data (e.g. intertwined formulas). [0] https://csvkit.readthedocs.io/en/1.0.3/scripts/in2csv.html https://csvkit.readthedocs.io/en/1.0.3/scripts/in2csv.html [1] https://csvkit.readthedocs.io/en/1.0.3/scripts/csvsql.html https://csvkit.readthedocs.io/en/1.0.3/scripts/csvsql.html