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. If you insert ...

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.