> When I tell them to do it in Excel by themselves, they would say Excel couldn't open a CSV larger than 1M rows...

Sure it can. Just use the "Import from Text/CSV" feature instead of directly opening the CSV. https://support.microsoft.com/en-us/office/what-to-do-if-a-d...