Toggle navigation
CSV demo files
You can download these files to test it:
test-cars.csv
8 columns, 10853 rows
test-categories.csv
1 columns, 35 rows
test-customers.csv
12 columns, 5506 rows
test-orders.csv
5 columns, 3275 rows
DB Tables
You can view the DB tables content:
categories
clients
coupons
orders
products
Import
New
List
Export
New
List
Settings
Import
File to import
Choose the location of the file to import
Desktop
URL
FTP
Server
URL
ex: http://www.mydomain.com/downloads/file.csv
Address or URL
Port
Username
Password
Remote Path
ex: /httpdocs/folder/file.csv
Server Path
ex: /home/folder/file.csv
.CSV
columns
records
Header
Delimiter
Enclosure
Encoding
BIG-5
EUC-JP
EUC-KR
GB2312
GBK
ISO-8859-1
ISO-8859-2
ISO-8859-9
ISO-8859-15
SJIS
UTF-8
Windows-1251
Windows-1252
Windows-1254
Warning!
Indicates a warning that might need attention.
Table
Select the database table where you want to import the data
Table
categories
clients
coupons
orders
products
Mapping
Assign the columns of the CSV to each DB field
DB
CSV
Filter
Filter the data you want to import
Rows to import
ex: 1,2,5-10,15,20-
Conditions
CSV column
Value
Add
Duplicates
Choose how to handle duplicates
Field that defines a duplicate
Actions for the duplicates
Skip record
Insert as a new record
Update
Delete
Actions for the rest
Create new records from data newly present in your file
Delete records that are no longer present in your file
Import
Review if everything is ok and import
.CSV
columns
records
IMPORT
columns
records
Time elapsed:
00:00:00
Date begin:
Date end:
Imported:
/
SKIPED:
0
INSERTED:
0
UPDATED:
0
DELETED:
0
ERROR:
0
View log
Log
Back
Next
Import
×
Preview input file
×
Preview data to be imported
This doesn't show the duplicates actions