Import data from online Excel file to MySQL without programming

by

Posted on by

Want to parse cloud Excel file and save to MySQL ?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can convert cloud EXCEL file to MySQL (MariaDB, Percona) table easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Import Excel to MySQL locally and privately, avoid uploading Excel file(s) to online services.

Download FileToDB Download FileToDB

Import cloud EXCEL file to MySQL (MariaDB, Percona) table

Choose MySQL and logon.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - Choose MySQL and logon

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

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - task window

Select “Source Type” with “Url”.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - select type

then show the wizard.

1. Input the EXCEL file URL, and download the file.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - download from EXCEL file URL

2. Open the saved EXCEL file.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - open saved EXCEL file

3. Config target MySQL (MariaDB, Percona) table.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - config MySQL (MariaDB, Percona) table

4. Summary.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - summary

5. Import cloud EXCEL file to MySQL.

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - convert to MySQL (MariaDB, Percona) table

See MySQL (MariaDB, Percona) table

convert cloud EXCEL file to MySQL (MariaDB, Percona) table - view MySQL (MariaDB, Percona) table

Import cloud Excel to MySQL in command line

Save “Excel to MySQL” session, then you can:

Set scheduled tasks for importing Excel to MySQL

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ