CODEWITHSUNDEEP
mysqlsqlexcel
wrahool
wrahool

Reputation: 1141

Download MySQL table as a spreadsheet

How do you download an sql table as an Excel spreadsheet?

Any help would be appreciated.

Thanks

Upvotes: 0

Views: 266

Answers (4)

Niki
Niki

Reputation: 1924

Use a database client like Navicat.

Upvotes: 0

Alien Technology
Alien Technology

Reputation: 1848

Navicat, MySQL Workbench and phpMyAdmin would all work if you want to create the spreadsheet yourself.

To allow users to download spreadsheets from a website, you can use a library. Some good options are:

IIS: EPPlus http://epplus.codeplex.com/ or NPOI http://npoi.codeplex.com/

Apache: PHP Excel (http://phpexcel.codeplex.com/) or Apache POI (http://poi.apache.org/)

Upvotes: 0

cichy
cichy

Reputation: 10644

Use phpMyAdmin, it has option of exporting thata to multiple formats:
csv,scv for excel, json, doc, latex, wiki table, odf, pdf, sql

Upvotes: 0

aserwin
aserwin

Reputation: 1050

Use a SELECT ... INTO OUTFILE ... statement to write a CSV file or a tab-delimited file that you can open directly in Excel.

Upvotes: 3

Related Questions