Batch import Excel files data to PostgreSQL

How to batch import Excel data to PostgreSQL from a folder

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

Batch import Excel data To PostgreSQL - task window

then show the import wizard.

1. Select a folder.

Batch import Excel data To PostgreSQL - select a folder

2. Select a table and config fields.

Import data from Excel to PostgreSQL - select table

3. Preview data.

Batch import Excel data To PostgreSQL - preview

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

Import data from Excel to PostgreSQL - import data