How to import a large excel spreadsheet into MySQL?

Question

PHP

Since the morning I've been trying to export a table from Excel to a database, but everything is even. As soon as I did not save the csv, xml format, different import settings ... Everything is even! Can someone explain what the trick is?

Answer 1

The problem was that the delimiters had to be specified with ; instead of ,
Here is the solution =|

Answer 2

tricks no
be sure to save in UTF8 format
match the fields check
csv loads without problems
try it on a test table