I’m not the best person to address that, as I’ve not [yet] encountered the need. However, it does look like it’s come up before.
Perhaps something like an automated GSheet approach might be worth considering after all.
Do you mind my asking where that “file” (the original data) comes from? IOW, how does it get into the spreadsheet? Is it provided to you in CSV format? Is it accessible via an API?