phpmyadmin error: Invalid column count in CSV input

[support]

[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.

[support]

[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

[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.