Export SQL table in CSV With Headers
This works for me. What version of phpmyadmin do you have?
- Under
Browse
, click on the table you want to export. - At the bottom, in the
Query results operations
section, click onExport
. - In
Export method
, chooseCustom
. - Change
Format
toCSV for MS Excel
. - Under
Format-specific options
, checkPut columns names in the first row
.