Page 1 of 1
phpmyadmin error: Invalid column count in CSV input
Posted:
Wed Mar 28, 2012 1:35 pmby support
Re: phpmyadmin error: invalid field count
Posted:
Sun Apr 22, 2012 9:44 amby support
Another possible cause of this "invalid field count in CSV input on line 1" error is that the file you are importing is not actually CSV format. The filename might end in ".CSV" but could actually be a different format, usually Excel binary / XLS format.
The fix is to "Save As" and change format to CSV, in your Spreadsheet application (Excel, OpenOffice Calc, Numbers, etc). Upload the new file you just saved in actual CSV format.
Re: phpmyadmin error: invalid field count
Posted:
Sat Nov 03, 2012 11:34 amby support
Re: phpmyadmin error: Invalid column count in CSV input
Posted:
Sat Mar 05, 2022 10:53 amby lindah
so, I'm having this problem (in excel files saved as CSV DOS)... repeatedly with different files for different sources... how do I find the hidden quotes ("")?
I've done a search with "find" and it comes up as not found.
I've tried save as and selecting the CSV option, but it's not working
Re: phpmyadmin error: Invalid column count in CSV input
Posted:
Thu Apr 21, 2022 10:51 amby support
If you can't find the double quotes "" with a search in a text editor, then that's not the cause of your error. There are multiple possible causes of this error - that is just one of many.