CSV to SQL Insert Generator

CSV → INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server, with per-dialect identifier quoting and an inferred CREATE TABLE.

Table name

Dialect

Rows per INSERT

Include CREATE TABLE

CSVid,email,signup_date,credits,is_active
1,ada@example.com,2024-01-15,120,true
2,grace@example.com,2024-02-02,75,true
3,alan@example.com,2024-03-11,0,false

SQLCREATE TABLE "users" (
  "id" INTEGER,
  "email" VARCHAR(34),
  "signup_date" TIMESTAMP,
  "credits" INTEGER,
  "is_active" BOOLEAN
);

INSERT INTO "users" ("id", "email", "signup_date", "credits", "is_active") VALUES
  (1, 'ada@example.com', '2024-01-15', 120, TRUE),
  (2, 'grace@example.com', '2024-02-02', 75, TRUE),
  (3, 'alan@example.com', '2024-03-11', 0, FALSE);

CSV to SQL Insert Generator — Free Online Tool

Generates SQL INSERT statements from CSV data for PostgreSQL, MySQL, SQLite and SQL Server, applying each dialect's identifier quoting (backticks, double quotes or square brackets), inferring column types for an optional CREATE TABLE, escaping single quotes, mapping empty cells to NULL, and chunking multi-row VALUES lists to stay under packet limits.

How to use the CSV to SQL Insert Generator

Open the tool above — it runs entirely in your browser, so your input never leaves this page.
Paste or type your input into the field, then press the relevant button (e.g. Encode / Decode, Generate, or Convert).
Copy the result from the output area with the copy button orCtrl/Cmd + C.
No signup, no upload, and no tracking — repeat as often as you need.

Frequently asked questions

Which SQL dialects are supported?

PostgreSQL, MySQL/MariaDB, SQLite and SQL Server. The dialect controls identifier quoting (double quotes, backticks or square brackets), how booleans are written, and the types used in the generated CREATE TABLE.

Are the generated statements safe against SQL injection?

Single quotes inside values are doubled, which is the correct escape for string literals in all four dialects. That said, generated INSERT scripts are for trusted data loads — for user input in an application, always use parameterized queries instead.

Why does it split the INSERT into several statements?

Multi-row VALUES lists are chunked by the rows-per-INSERT setting so a large CSV does not produce one statement bigger than the server's limit (MySQL's max_allowed_packet is the usual culprit). Lower it if your import still fails.

Free & private — why use this CSV to SQL Insert Generator

The CSV to SQL Insert Generator runs 100% client-side in your browser. Your data is never uploaded to a server, no account is required, and the tool is completely free. It works offline once the page has loaded and is part of a growing collection of privacy-first developer utilities.

More config & serialization

YAML to JSON TOML to JSON Converter TOML to YAML Converter XML JSON Converter .env File Parser JSON to TOML Converter View all 23 Config & Serialization →