Convert CSV to SQL

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.

SQL (Structured Query Language) is a standard language for storing, manipulating, and retrieving data in relational database management systems.

It's used by many database systems including MySQL, PostgreSQL, SQLite, and others. SQL allows you to create, read, update, and delete database records with commands like SELECT, INSERT, UPDATE, and DELETE.