Invalid field count in CSV input on line 1.

also got the same error but after doing some work i got solution. my .csv file look like excel file and i imported it successfully in MYSQL TABLE through phpmyadmin.

make sure you have done following step correctly

empty your table first if it has garbage

1. your cvs file's column name must match your table column name
2. browse your required .csv file
3. select CSV using LOAD DATA options
4. Check box 'ON' for Replace table data with file
5. in Fields terminated by box type ,
6. in Fields enclosed by box "
7. in Fields escaped by box \
8. in Lines terminated by box auto
9. in Column names box type column name seperated by , like column1,column2,column3
10 check box ON for Use LOCAL keyword.