SQL INSERT Generator

Convert CSV / TSV / JSON into INSERT INTO statements — multi-row VALUES or one statement per row.

Table nameOutput style

Empty cells → NULL Include column list

CSV / TSV / JSON input

Generated SQL (3 rows)

INSERT INTO users (id, email, active, created_at) VALUES
  (1, 'alice@example.com', TRUE, '2024-01-15'),
  (2, 'bob@example.com', TRUE, '2024-02-03'),
  (3, 'carol@example.com', FALSE, '2024-03-22');

Output styles

One per row — easiest to diff, slowest to load
Multi-row VALUES — one INSERT, many tuples (MySQL / PostgreSQL / SQLite)
Per-row, with column list — most explicit; survives column re-ordering

Type handling

Numbers are emitted bare. Booleans become TRUE/FALSE. Empty cells become NULL when the column allows it; otherwise an empty string. Everything else is single-quoted with ' escaped per ANSI.

Used in these workflows

CSV to SQL InsertsParse CSV and emit one INSERT per row.

Output styles

Type handling

You might also like

Used in these workflows