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:

enter image description here

And i need it like this: enter image description here

Any suggestion how to do this?

What happened when you Googled "phpmyadmin export csv with headers"? Please do that before asking here. — Tim Williams
– Tim Williams, Commented May 28, 2014 at 21:04
I did not find any post over the internet for phpmyadmin, I found some posts for sql server 2008 — user2997826
– user2997826, Commented May 28, 2014 at 21:05
There's a format specific option for column names in the first row. — VMai
– VMai, Commented May 28, 2014 at 21:07
Yes! same no headers after checking "put name of columns in first row I've done all these methods then i decided to ask here to some experts — user2997826
– user2997826, Commented May 28, 2014 at 21:11

S. Ahn · Accepted Answer · 2014-05-28 22:08:45Z

17

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 on Export.
In Export method, choose Custom.
Change Format to CSV for MS Excel.
Under Format-specific options, check Put columns names in the first row.

answered May 28, 2014 at 22:08

S. Ahn

6735 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jignesh Patel · Accepted Answer · 2020-12-17 08:47:57Z

1

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

answered Dec 17, 2020 at 8:47

Jignesh Patel

3162 silver badges11 bronze badges

Collectives™ on Stack Overflow

Export SQL table in CSV With Headers

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related