Export SQL table in CSV With Headers

Question

I have a sql database in which i want to export some tables in CSV format. Users and purchases.

By using phpmyadmin, > Export function i've successfully exported all data in table but there are no headers (column title) in the excel sheet and its very confusing to determine data retrieved from that table.

its look like this:

And i need it like this:

Any suggestion how to do this?

Answer 1

This works for me. What version of phpmyadmin do you have?

1. Under Browse, click on the table you want to export.
2. At the bottom, in the Query results operations section, click on Export.
3. In Export method, choose Custom.
4. Change Format to CSV for MS Excel.
5. Under Format-specific options, check Put columns names in the first row.

Answer 2

1. Click on the export button
2. Export method custom
3. Format CSV
4. Format-specific options: Put columns names in the first row ( Select this checkbox)