Exporting all data from MySQL database to spreadsheets

Question

So, I've got a MySQL database consisting of a bunch of tables that I want to give to my uncle.

Problem is, he doesn't know much about computers, so I can't just hook him up with the database.

Instead, I would like to extract all the data from the database into a more readable format, e.g. Excel spreadsheets.

I've tried mysqldump, but that just gives me a *.sql file which doesn't help much.

Any ideas?

mysqldump --batch will write in TSV form instead of SQL statements. phpMyAdmin is handy if you have it. — Joshua Martell, Jan 19 '13 at 15:32

score 2 · Accepted Answer · edited May 23 '17 at 11:56

2

If you only have command line, this answer explains how to dump into a tab delimited and this answer how to dump into a comma delimited file. You can then import the tab delimited file into Excel.

Alternatively, you can use phpMyAdmin to export to *.csv if you have PHP.

edited May 23 '17 at 11:56

Community

1
1

answered Jan 19 '13 at 15:19

Kermit

33,827
13
85
121

score 0 · Answer 2 · answered Jan 19 '13 at 15:19

0

PHPmyadmin allows you to Export to many different formats - why don't you access your database through that?

answered Jan 19 '13 at 15:19

user1914292

1,586
13
38

Exporting all data from MySQL database to spreadsheets

2 Answers2