How Can PHP Export MySQL Query Results to Excel XLSX File Served for Download By Manuel Lemos Many people and companies use Microsoft Excel to view and manipulate financial and other types of data that can be presented on a grid of cells.

Sometimes the data they need to view or manipulate is stored in a database.

Many PHP applications use a MySQL server to store data that the people or companies want to view in Microsoft Excel.

This package provides a simple PHP script that shows how to extract data from a MySQL database and generate a Microsoft Excel spreadsheet that can be downloaded and viewed in the Microsoft Excel application of the user that accesses the PHP site that uses MySQL.