CSV to MySQL Conversion

CSV to MySQL Loader is a tool to convert and migrate data from CSV files to a MySQL database, or from MySQL to CSV files. Convert multiple files in one go, map source columns to matching destination columns, and filter rows by specifying WHERE conditions.

CSV to MySQL Loader comes with a built-in scheduler so you can run transfer jobs at specified intervals — no need to run jobs repeatedly. Just create a session, define the schedule date and time, and it will automatically execute your session in the background and record the actions in a log file which you can check later.

It also provides a command line interface to run migration jobs manually, so it can be easily integrated with your own application. All sessions are stored in a repository, with a user friendly interface to take a backup, restore from a previous backup, or create a new blank repository.

Features

Wizard based
Map source columns to target table columns
Specify WHERE conditions to filter data
Save and schedule sessions for recurring data transfers
Fast speed
Completely user friendly
No need to write any code

Select single or multiple tables to transfer
Select or deselect columns while transferring
Change destination datatypes and widths
Automatic checking of datatype mismatch
Economical cost of just $99 for the Standard Version
Fully functional trial version with a 50 rows limit
Transfer millions of rows easily and fast

What is CSV?

CSV stands for Comma Separated Values — a simple, common standard for tabular data. It's supported by a huge range of tools, from spreadsheets like Excel, OpenOffice, and Google Docs, to complex databases and almost all programming languages. It is probably the most widely supported structured data format in the world.

Example of CSV

As a CSV file is plain text, you can open it in any text editor. It looks something like this:

101,"Smith Jones",4000
102,"Karren",2300
104,"John, Kenny",8000

Limitations of CSV

No Datatypes

CSV lacks any way to specify type information — there's no way to distinguish "1" the string from 1 the number. This shortcoming can be addressed by adding some form of simple schema.

No Relationships

No support for relationships between different "tables".

Tabular Data Only

CSV is really only for tabular data — it's not so good for data with nesting or where structure isn't tabular.

Using our tool you can easily load data from any CSV file into MySQL or other databases. Just select the CSV files and let the tool do the rest.

Convert CSV to MySQL in Three Steps

Step 1: Select the folder and CSV files you want to load

CSV files

Step 2: Select the MySQL target database

Select MySQL database

Step 3: Click the Start button

Start converting CSV to MySQL