Batch export database tables to Excel

This article will introduce how to export multiple or even thousands of database tables to Excel files in batches. Prepare data The following figure shows the tables in the database. We need to export them all to Excel files. Here we take MySQL database as an example New Export Open the DiLu Converter tool and create a new database connection. Here we take MySQL database as an example. After the connection is successful, select Export and click New Export. Start export Click Select Table-Select the table name we want to export, select a folder for the target Excel file, and click Start View the results Continue to optimize You can see that the exported workbook name and title row name are the table name and field name of the database, respectively, both in English letters. If there are comments in the database table, the comments can be used as the workbook name and title row name. We can also add a date suffix to the exported table name to distinguish it You can also export in batches to csv files View the results

May 4, 2025 - 08:16

This article will introduce how to export multiple or even thousands of database tables to Excel files in batches.

Prepare data

The following figure shows the tables in the database. We need to export them all to Excel files. Here we take MySQL database as an example

New Export

Open the DiLu Converter tool and create a new database connection. Here we take MySQL database as an example. After the connection is successful, select Export and click New Export.

Start export

Click Select Table-Select the table name we want to export, select a folder for the target Excel file, and click Start

View the results

Continue to optimize

You can see that the exported workbook name and title row name are the table name and field name of the database, respectively, both in English letters. If there are comments in the database table, the comments can be used as the workbook name and title row name.

We can also add a date suffix to the exported table name to distinguish it

You can also export in batches to csv files

View the results