[FIXED] Export SQL table in CSV With Headers

Issue

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?

Solution

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.

Answered By - S. Ahn