So here's a weird one. the "too many fields in record #1" error but there are not too many fields.
One might think there's a hidden carriage return in one field (I've encountered that before) but see here for when I open csv the file in excel, save it, close it, and run the plan again there is no error! I make no change and tadah!
Next time the error happens I'm going to try opening it and NOT save it to see if it still works.
edit: Nope doesn't help (of course) also opening and saving in Notepad++ doesn't have the same effect as saving it in excel (still as a csv) without any changes.
Setting it to "ignore errors" just corrupts my data so that's a nogo.