How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.

Use the Excel file as an ODBC data source (connection string info here), and your MySQL database as the destination (using their ODBC connector). What OS is your process running on?

The database size is under 50MB. The database export file is small enough to overcome upload size limits (note: you can compress the file before uploading to pack more in).