Export MySQL query to Excel file

Export MySQL query to Excel file (XLS or XLSX file)

Tools

• PHPExcel
• other MySQL client softwares

two steps conversion: ex

• CSV --> XLSX or
• XLS --> XLSX

Technical issues: If it costs too much time to convert to Excel file

First steps for CSV file. The CSV file will be converted to Excel file more convenient.

• Add delimiter character between different column ex: comma symbol (,) or tab symbol
• Add enclosure character ex: double quote symbol (") or single quote symbol (')
• Add escape character escape the column value if contains the enclosure character
• Remove return symbol:

  SELECT REPLACE(REPLACE(REPLACE(`my_column`, '\r\n', '   '), '\n', '   '), '\r', '   ') 

References

< references />