Import multiple Excel sheets to a single Percona table

by

Want to import data from multiple Excel sheets to a single Percona table at a time?

Try Withdata FileToDB, a desktop Excel to Percona converter for Windows, MacOS, and Linux, Convert Excel to Percona, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Import data from multiple Excel sheets to a single Percona table

Login to Percona -> Choose Excel file -> Set Percona table -> Import multiple Excel sheets to Percona

Choose Percona and logon.

convert multiple Excel sheets to a single Percona table - Choose Percona and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert multiple Excel sheets to a single Percona table - task window

Select the “Excel” file type.

load multiple Excel sheets to a single Percona table - select file type

then show the wizard.

1. Open Excel file, set “Sheet” to “All”.

convert multiple Excel sheets to a single Percona table - Open Excel file

2. Select a Percona table and config fields.

import multiple Excel sheets to a single Percona table - select table

3. Preview data will be in Percona table.

import multiple Excel sheets to a single Percona table - preview

4. Import multiple Excel sheets to a single Percona table.

import multiple Excel sheets to a single Percona table - import data

View imported data in Percona table

import multiple Excel sheets to a single Percona table - view data


More about Excel to Percona converter