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
