CODEWITHSUNDEEP
sqlexcelcsvphpmyadmin
Maxime
Maxime

Reputation: 131

how to export phpmyadmin table into csv?

I want to export a table of a database on phpMyAdmin into csv file. I tried SELECT * FROM Table_Name into outfile'D:/wamp/www/projectName/fileName.csv'; but it's very ugly. How to make it more presentable? Thank you in advance.

Upvotes: 0

Views: 3694

Answers (2)

Matt Gibson
Matt Gibson

Reputation: 38238

So you want it in Excel, in the end? In phpMyAdmin, view the table. In the tabs at the top, choose "Export". Choose whichever Excel format you want from the list at the left-hand side. Choose the options you want, hit "Go".

(If you just want CSV, this screen also gives you a friendly way of adjusting the CSV options, e.g. using a comma rather than a semicolon as the separator, which will probably go down better with Excel and other CSV importers.)

PHPMyAdmin Export Interface

Upvotes: 3

Kenan Zahirovic
Kenan Zahirovic

Reputation: 1597

From Excel go to Data - (import) From Text, choose Delimited and select ";"

Upvotes: 0

Related Questions