How to import Excel data to MySql Table

How to import Excel data to MySql Table in simple 3 steps

Step 1: Save your excel sheet as a CSV by using “Save As”

Step 2: Delete the header if you have in the CSV file

Step 3: Open PhpMyAdmin and click on the table you want to insert to. Then click import and choose CSV file. Check the file and set  “Format Specific Action”  in the import page like your columns are separated by comma(‘) and click go.

Now you are done Enjoy!!!