cancel
Showing results for 
Search instead for 
Did you mean: 

How to export database in xls

SOLVED

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