A few weeks ago, a coworker had the task of splitting a long spreadsheet table of people into several smaller files, one for each country. Doing it manually is tedious work: sort the rows by country, create a new file for each country, copy the headers into each target file, copy the appropriate row range. Whenever the table changes, repeat it all over. Tedious work on computer data is asking for automation, so I built a LibreOffice macro.
Why LibreOffice? Because it is free and works on all relevant desktop platforms (Linux, Mac, Windows) and I had already some experience with LibreOffice macro programming.
I won’t go into details here. To have a look at it, grab it from
https://gitlab.com/martinstut-opensource/table-splitter