Which databases does the output work with?

The generated SQL is standard enough for PostgreSQL, MySQL, SQLite, and SQL Server. Column types default to TEXT — adjust them in the CREATE TABLE if needed.

Are values escaped safely?

Yes — single quotes are doubled per the SQL standard, numbers are unquoted, and empty cells become NULL.

Can I skip the CREATE TABLE?

Untick “Include CREATE TABLE” to get only the INSERT statement for an existing table.

/ free tool

CSV to SQL Insert Generator

Convert CSV to SQL INSERT statements free in your browser. Generates CREATE TABLE and INSERT queries from any CSV — no upload.

100% free
Runs in your browser — nothing is uploaded
No signup required

Table nameInclude CREATE TABLE

Seeding a database from a spreadsheet shouldn't require writing a loader script. Paste your CSV, name the table, and get a ready-to-run CREATE TABLE plus a single batched INSERT statement.

Values are properly escaped (single quotes doubled), numeric values are left unquoted, and empty cells become NULL. Works with PostgreSQL, MySQL, SQLite, and SQL Server with little or no editing.

Example

Input

name,age
Ada,36

Output

INSERT INTO my_table ("name", "age") VALUES
  ('Ada', 36);

Your data never leaves your device

Like everything at OpenCSV, this tool processes files locally in your browser. There is no upload, no server-side processing, and no copy of your data anywhere — which makes it safe for customer lists, financial exports, and other sensitive files.

/ frequently asked

Frequently Asked Questions

The generated SQL is standard enough for PostgreSQL, MySQL, SQLite, and SQL Server. Column types default to TEXT — adjust them in the CREATE TABLE if needed.

/ more free tools

Keep working with your CSV

Need to view or edit the file first?

OpenCSV is the fastest CSV editor on the web — open, fix, and save any CSV in seconds. $1 lifetime access.

Try OpenCSV free