how to split a large CSV
I was searching for tools to split a large CSV data file into 1000 rows files, I found this https://www.makeuseof.com/tag/how-to-split-a-huge-csv-excel-workbook-into-seperate-files/ . If you use other tools please share.
If you are lucky enough to use linux:
it's a one liner:
https://stackoverflow.com/a/53062251/401226
probably works in macos too, once you install parallel
You input the CSV file you want to split, the line count you want to use, and then select Split File. The line count determines the number of output files you end up with.