Question: how to import data from excel in phpmyadmin?
Answer: Step 2 - Click Databases in the top-menu.
Step 3 - Click the name of the database you want to import to.
Step 4 - Click Import.
Step 5 - Choose file and click Go. Click Choose file and select the database file you want to import. This is an . ... 
Step 6 - You're done. The import is now done.