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.