ExcelToDatabase is an automatical tool which can batch import multiple excel files into database(mysql/oracle/sqlserver/postgresql/access/hive/sqlite/dm). Automation is its main feature beacuse the tool can import data into database automatically and no need you to provide a mapping. Batch is the another feature beacuse of automation, so you can import 10 or 10000 excels one time but not one by one. Scheduler make you can import excel to database at any time.
Based on the excel, the tool can create table and import data into the database automatically, or just append/merge the data based on the automatical mapping between the excel and databases.
Usually you only can import excel one by one using the other tool. But now, you can import all excels you want one time.
You only need to provide the location of excels and the connect information of database, the tool can work until all the excels are imported
The fastest, no others
When you manually import excel into database, whether if you feel sad when error occurs? DO NOT WORRY! The tool can deal with them!
Rich options could be custom choose to make more fuction come true.
You can make a schedule using it on windows/linux.
Sync data in excel into database in realtime.
DO NOT connect to internet. Work on offline to protect data
The packaged executable program(ExcelToDatabase.exe on windows) is available,
you can download it from sourceforge.
Start Program ExcelToDatabase.exe
Choose and Input
Choose the directory or excel files;
Input target database information;
Click Start
- Windows
- MySQL/Oracle/SQLServer/PostgreSQL/Access/Hive/SQLite/DM
- Excel(xls,xlsx,xlsm,csv)
Open/Save/Import Configuration
you can choose one database according to your target database
- Files: choose Files as your data source, in this case, you can select one or more excel files to import
- Directory: choose Directory as your data source, in this case, excels under the directory will be imported
New/Edit/Import a schedule task. Programmer is crontab
Choose directory or files as your data source
Input connection information of your target database
Recursive sub directories to find all excel files
Only Import Excel Last Modified since last imported
only supported windows installed office and file format is xlsx/xls
suggest only open for large excel file)
Tools can auto-detect encoding of csv files(default),
and you can choose or input other value
input excel password
sheet index as:1,sheet names as:Sheet1,Sheet2
if @,sheet name starts witj @ will be ignored
eg: 1,default is 1,multiple header as: 1-3
eg: 2,default is header row+1
eg:1
trim()
Skip Blank Rows
values populated(comma separated) will be replaced to null
sql:drop table if exists
sql:delete from
sql:create table if not exists
import all data to the table populated
Same Sheet Name、Same Excel Name、Similar Excel Name
defaule use excel file name as table name if not checked
Transform chinese in table name and column name to the first letter of its pinyin
The value populated will be added to table name before/after
Add a Key Column, Value is The Row Number
sql:alter table modify column
Nothing/Ignore redundant column/Add new column in table(sql:alter table add column)
Nothing:sql:insert into
Ignore:sql:insert ignore into
Update: sql:delete then insert
delete table data by value of the columns
parallel insert
When starting import, run sql in the sql file choosed before
When complete import, run sql in the sql file choosed after
Some logic is described below when the tool work
If only one sheet in excel >> excel name
If multipule sheets in excel >> excel name + '_' + sheet name
If table name is more than the limit of database >> cut off
Default is the first row, but if the first row is all blank, next row will be used
If column name is blank, abcd will be set as column name
If column name is repeated, number like '0' will be added as its suffix
Varchar(255) is default. If max length of column more than 255, text/clob will be set.
- Email: [email protected]