Convert CSV to SQL

Add your CSV data and automatically convert it to a SQL insert file.

Tablepad: Explore and create graphs from CSV. Try it now

Convert files up to 5 MB. Please upgrade to increase the limit.

No conversion done yet

You can also use the API to convert data, check out the documentation to learn more.

curl -X POST \
	-H "Authorization: Bearer ${API_KEY}" \
	-F "input[file]=@myfile.csv" \
	-F "input[format]=csv" \
	-F "input[options][delimiter]=," \
	-F "input[options][has_headers]=true" \
	-F "output[format]=sql" \
	-F "output[options][create_table]=true" \
	-F "output[options][table_name]=mytable"


CSV stands for Comma Separated Values and is a plain-text file format that stores tabular data. CSVs are widely used to import and export data for all kinds of services for it's simplicity and ease of parsing.

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).

Konbert 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 stands for Structured Query Language and is a standarized language used to communicate with almost all relational databases. It can be used to query, insert and manipulate data stored in a database.

The exported file will be a SQL dump (.sql) that you can use to import it to your database.

SQL flavour

Since databases have different syntax for some things. You'll be able to choose a SQL database flavour when exporting to SQL, at the moment we support:

  • MySQL
  • PostgreSQL
  • SQLite

Character encoding

The exports will always be encoded in UTF-8.

Frequently asked questions

What is the monthly data volume?

The monthly data volume is the total size of all the files uploaded over the course of the month. It resets every month.

For example, if you upload a 1GB file and a 2GB file, your monthly data volume will be 3GB.

If you upload a 1GB file and then delete it, your monthly data volume will still be 1GB.

How does the file size limit work?

The file size limit is the maximum size of a single file you can upload.

How do I change my plan?

You can change your plan any time by going to the pricing page and selecting a new plan. If you're in the middle of a billing cycle and you change to a more expensive plan, the subscription price will be prorated automatically.

How do I cancel my subscription?

Go to your account page and find the Billing section, there you can downgrade to the Free plan. Your plan will be cancelled immediately and you won't be charged again.

How secure is your service?

We pride ourselves in building software that's easy to use, but security is also our top priority.

We understand that some data uploaded might be sensitive, so we ensure that your data is only kept when needed.

We follow widely accepted industry standard practices when it comes to security:

  • HTTPS is enforced for all communications with our server
  • We enforce a strict access policy and employees or external collaborators never have access to user data
  • All data is always encrypted at rest
  • All data uploaded for conversion is automatically deleted forever 24 hours after being uploaded.
  • Once you delete a file, it is deleted forever, we do not archive your data

We allow time before auto deleting files just in case you're not done with the data, if you're done with viewing or converting a file and want to delete it right away, you can do it yourself through the API. We will be implementing this functionality in the web app soon.

Note that all files files uploaded without an account are acessible by a unique URL that is hidden but accesible by anyone, so we recommend you to sign up with an account if you want your files to be private, only your account will be able to access your files.

Do you provide an API for converting files?

You can upload files, queue and check the progress of conversion jobs with our API. Check out the API documentation for more detail.

Do you offer a trial?

We don't offer a trial plan at the moment.

You can test our tools with a subset of your data with the Free plan then upgrade if you like it.

Where do I get my API key?

You'll get an API key when you sign up, find it in your account page.

Do you have any SDKs for your API?

Unfortunately, we don't have any language specific SDKs yet, so you'll have to use a standard HTTP client for it.

Related articles