Apps / File & Data Converters / CSV ↔ SQL INSERT Converter

⇆ CSV ↔ SQL INSERT Statements

Turn a CSV (with a header row) into INSERT statements, or paste INSERT statements and pull the data back out as CSV.

Column and table identifiers are emitted double-quoted (ANSI SQL / PostgreSQL / SQLite style) — if your target is MySQL without ANSI_QUOTES, swap the double quotes for backticks after copying. Numeric-looking cells are written unquoted; everything else is a single-quoted string with single quotes doubled per standard SQL escaping. The SQL→CSV direction is a hand-rolled parser (no real SQL engine) that expects INSERT INTO table (cols…) VALUES (…), (…); syntax — it does not evaluate expressions, only literal strings, numbers and NULL.

Direction

1. Paste CSV

2. Result