Question: how to import data from excel to mysql using phpmyadmin?
Answer: Open your Excel file. ... 
Once your worksheet is selected, go to the 'File' menu and select 'Save As'. ... 
Once you have saved each of your Excel worksheets separately into CSV format, you are ready to utilize phpMyAdmin's import functionality.