Convert CSV to MySQL

Add your CSV data and automatically convert it to MySQL.

CSV input options
MySQL output options

CSV

Comma-separated values (CSV) is a simple and widely used format for storing tabular data. It is human-readable and easy to generate and parse.

Row delimiter

The row delimiter is the character used to separate each row in the CSV data. This is usually a new line character (LF), or a carriage return plus a new line character (CRLF).

We will automatically detect this and parse the rows correctly.

Value separator

The value separator is the character used to separate each value inside a row.

For CSV files, as the name implies it is usually a comma, but it can be different depending on the software used to generate the CSV file, we support the following separators:

  • Comma ,
  • Tab \t
  • Pipe |
  • Hash #
  • Semicolon ;

Character encoding

Depending on what software you used to generate the CSV file, it might have a different character encoding

If no character encoding is specified we will automatically try to guess it, so you don't have to worry about it if you're unsure.

MySQL

MySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL).

It's widely used for web applications and is known for its reliability, performance, and ease of use. MySQL supports multiple storage engines, transactions, and replication.

Convert CSV