How to add many customers at once in a database table?

Question

I need to add Name, Phone and Address of many clients who are in excel and pass this to the database. What would be the fastest way to do that ?

Answer 1

Exporting to CSV you can use Heidisql to import as in this answered question (in English) https://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table

or use the Mysql LOAD DATA command described in the documentation (English) https://dev.mysql.com/doc/refman/5.7/en/load-data.html

Just take care with a detail: due to the numbering Excel exports CSV not sepradao by comma, but by semicolon.