How to export database in xls

[istyfu]

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!

[Panaceum Soft · Accepted solution]

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