MysqlToExcel

MysqlToExcel is a simple to use conversion environment, in which you can import MySQL database information and export it straight into a Microsoft Excel spreadsheet.

The application enables you to map the selected table in MySQL database to corresponding columns in the spreadsheet.

MysqlToExcel allows you to easily setup the details for the transfer in a graphical interface, with just a few mouse clicks.

Alternatively, you can also configure the connection by creating an SQL query and establishing the details.

The program requires connection to the MySQL manager and supports both local hosts or remote servers. You need to specify the host address, port, database name and the authentication details.

Moreover, the application also supports SSH connections, so you can activate the SSH Tunneling option from the logon screen.

You can save the connection details so that you can simply load the profile the next time you wish to logon.

MysqlToExcel allows you to extract the information from a single table or the entire database.

Alternatively, you can define the source and other details via query. You need to select the schema, the table and then you can individually transfer the columns from the database to the output spreadsheet.

The program supports UNICODE characters, so you may activate this encoding method if required.

You need to select the output spreadsheet, the sheet name and the number of records per sheet. Moreover, the process implies either replacing the information from the selected spreadsheet or appending it.

MysqlToExcel features a progress bar that indicates the duration of the transfer, as well as notifies you if any errors should occur.

The program can also be operated from Command Line and allows you to generate batch (*.bat) files to save the sessions. You may easily run the same transfer again or schedule an automatic recurrent event.