How to import an excel table into PHPMyAdmin?

Question

PHP

Good day!

I ask for help, because the solutions that I found did not help me.

There is a table from 26 columns on >2500 rows. You need to import it into the database to implement a search on the site for this table. How to do it through PHPMyAdmin. When translating into textual representations of the table, conflicts occur, since the contents of the cells contain the symbols , " ; : - which does not allow you to set up the correct division. I

am attaching a screenshot of the table:

Answer 1

Convert to CSV with a different delimiter. For example through PLEX .

And upload to PMA specifying the desired separator