This handy trick for combining a bunch of spreadsheet files from @chambln saved me some time using @libreoffice.
https://cosine.blue/2020-03-28-libreoffice-concatenate.html
A brief anecdote in which I use a spreadsheet application to manipulate lots of spreadsheets without actually opening any spreadsheets.
Gregory Chamberlain
Cameron DeCoster