Batch import Excel files data to MySQL

How to batch import Excel data to MySQL from a folder

Click "Wizard - N Files To 1 Table" at task dialog.

Batch import Excel data To MySQL - task window

then show the import wizard.

1. Select a folder.

Batch import Excel data To MySQL - select a folder

2. Select a table and config fields.

Import data from Excel to MySQL - select table

3. Preview data.

Batch import Excel data To MySQL - preview

4. Import to table or save sql script to file.

Import data from Excel to MySQL - import data