A PyPI published package to split spreadsheet data into separate grouped files based on a column.
When working with data files in csv or Excel format, I often found myself having to split the one large file into separate sub-files based on a grouping.
For example, a large file of receipts might need to be split by the purchaser, so each respective file could be sent to the right person.
Or also, a large file of project data might need to be split by client, so that each respective file could be sent to the correct client.
After writing a specific script once to split a specific file, I rewrote it as a generalized script that accepts csv, xls, xlsx, or xlsm files, can take in multiple worksheets, and output data to a template file with preformatted columns.