Easiest way to take a CSV, modify the header column to known values, then split up into smaller CSVs?

Hello, I’m trying to figure out what method I could use to do this. Basically the user uploads a CSV file (could have 1000s of rows). But the headers somehow need to be “translated” from the known input value to the one that matches the database.

After that is handled it would need similar functionality to Eli’s 1T CSV Upload plugin, but without the UI and still splitting up the CSVs into smaller CSVs of (75 ish?) rows per line?

I feel like if a plugin can almost do what is needed then it can be done. I see a lot of posts about external APIs for this but it seems like a basic idea that shouldn’t need another monthly charge.

Thank you!

1 Like