Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 112

Here we test it on the authors table.
PDF is interesting because of its vectorial inherent nature: the results can be zoomed.
Let's have a look at the generated report, as seen from Acrobat Reader:
Microsoft Excel 2000
This export format directly produces an .xls file suitable for all software that
understands the Excel 2000 format. We can specify which string should replace any
NULL value. The Put field names in the first row option, when activated, generates
the table's column names as the first line of the spreadsheet. Again, the Save as file
checkbox should be checked. This produces a file where each table's column becomes
a spreadsheet column.