Question: how to export data in excel format from phpmyadmin?
Answer: In phpmyadmin select the table you want to export the schema from.
Click on Print View at the bottom of the page.
Select the entire (or partial) table and click ctrl-c to copy.
Open a new Excel worksheet and select the first cell.
Click ctrl-v to paste.