Import Excel or CSV to MYsql

1. Convert Excel file to CSV format.
2. Use PHPMYAdmin and then execute below SQL statement.

LOAD DATA LOCAL INFILE 'D:\\filename.csv' INTO TABLE database.tablename FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (fieldname1,fieldname2,fieldname3 )