This is a software tool to let you export data from MySQL to Excel.

MysqlToExcel is a tool that helps export MySQL data to Excel file. Configuring the tool is very easy through visual aid and with just a few clicks. Data can be exported easily and very quickly, the progress is displayed and time estimation indicated. You are able to set up the export such that multiple tables can be exported. Export happens from tables as well as query. Session parameters can be saved and reloaded so that when the same kind of export is done, you save the set up time. Command line and scheduled transfers can automate large export tasks. When exporting text data, Unicode characters also can be exported easily and thus all the multi-byte Asian languages are easily transferred. Both versions Excel 2003 and 2007 are supported.

You set up the process by creating the batch list of all the tables that are to be exported. The result is indicated directly on the spreadsheet like display. You select the schema. All the tables are listed in the display space. The specific tables to be exported are to be ticked off on the check boxes available in the display area. “Succeeded” is indicated against the table name in the row. Number of rows in the table is also displayed as a confirmation. The overall progress is indicated by a progress bar below this detailed display area. This area is tabbed. While the main tab shows the progress, you have a log tab that can display the log messages for events that happen during the export process. It is a handy tool that takes out a lot of hassles in the export process.