How to output from excel to phpmyadmin database?

Question

MySQL

Hello. It was necessary to create many categories for the engine. All categories were stored in the database and looked like this:
Then I created a table in excel with the same number of columns and filled it. I save it in CVS, go to phpmyadmin, click "import", select a file, click "forward", and I get an error in response: "Mismatch in the number of columns in the CSV data on line 1." . Well, most likely it should be, since I did not change the format parameters. Tell me what needs to be changed so that phpmyadmin accepts the file?

Answer 1

I also just had this problem. At random, I found that the problem is still in the encoding. For example, open a csv file in notepad++ and look at the encoding in the "Encodings" menu. Rather, you have it in UTF-8 (with BOM), but it should be in UTF-8 without BOM. As far as I remember, BOM adds some non-printable character to the beginning of the file, which is why the error occurs.

Answer 2

Set the field separator to ";".