Create SQL Insert Statements from CSV

This tool generates SQL insert statements based on CSV data and provided table name.
Ensure 1st row headers match columns to be inserted into
No data is sent to the server, uses client-side JavaScript.




Advertisement

About

Convert a CSV file into SQL INSERT statements ready to run against a database.

How to use

  1. Paste or upload the CSV.
  2. Set the table and column names.
  3. Copy the generated SQL.

Frequently asked questions

What is an INSERT statement?

SQL that adds rows to a table.

Does it handle quotes and commas?

Yes, values are escaped for SQL.

Which databases does it work with?

MySQL, PostgreSQL and most SQL databases.

Advertisement