cancel
Showing results for 
Search instead for 
Did you mean: 

How to export database in xls

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

How to export database in xls

Hi all,

 

I would like to ask you how is possible to export the database in Excel, not in CSV/XML.

Thank you for your help!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to export database in xls

Hello istyfu,

 

You have two options:

 

1. first export your data to csv file and then convert csv to xls (not a problem to find a tool for that, just google: csv to xls)

2. use one of these tools to export data directly to xls:

 

http://www.phpclasses.org/package/8019-PHP-Export-MySQL-table-records-to-Excel-XML-format.html

http://www.bitdaddys.com/MysqlExcelExporter.html

http://www.sql-workbench.net/manual/command-export.html

View solution in original post

1 REPLY 1

Re: How to export database in xls

Hello istyfu,

 

You have two options:

 

1. first export your data to csv file and then convert csv to xls (not a problem to find a tool for that, just google: csv to xls)

2. use one of these tools to export data directly to xls:

 

http://www.phpclasses.org/package/8019-PHP-Export-MySQL-table-records-to-Excel-XML-format.html

http://www.bitdaddys.com/MysqlExcelExporter.html

http://www.sql-workbench.net/manual/command-export.html