> 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

> 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-data-set-is-too-large-for-the-excel-grid-976e6a34-9756-48f4-828c-ca80b3d0e15c https://support.microsoft.com/en-us/office/what-to-do-if-a-d...