SQL Insert Generator
Generate SQL INSERT statements from CSV data, one per row or batched into a single statement.
Processed locally in your browser. Your data is never uploaded.
- Choose one INSERT per row (each row executes/reviews independently) or a single batched INSERT with multiple VALUES tuples (more compact, typically faster for a bulk load).
- Numbers stay unquoted, empty cells become NULL, everything else is string-quoted.
- Runs in your browser — no upload.
Why this is private
- Processed locally in your browser. Your data is never uploaded.
- Open your browser's DevTools → Network tab while using this tool — you won't see a request carrying your input, because it never leaves your device.
- Nothing you enter is uploaded to a server or shared with us — the processing happens entirely on your device.
Overview
Generates SQL INSERT statements from CSV data — either one statement per row, or a single batched statement with every row as its own VALUES tuple — useful for quickly seeding a table from a spreadsheet export.
How to use it
- 1Enter the target table name.
- 2Paste CSV data with a header row matching your column names.
- 3Choose "One INSERT per row" or "Batched (single INSERT)".
- 4Copy the generated statement(s).
Tips
- Values are quoted as strings unless they look like plain numbers, and empty cells become NULL — review the output for any column that needs different handling (dates, booleans).
- Batched mode executes as one all-or-nothing statement — if you need to run rows selectively or want a partial failure to only affect one row, use one-per-row mode instead.
Frequently asked questions
What people use it for
Seed a dev or test databaseTurn a sample spreadsheet into INSERTs to populate a table.
Bulk-load a large dataset efficientlyUse batched mode for a single, more compact multi-row INSERT instead of hundreds of individual statements.
Migrate a small lookup tableMove reference data from a sheet into SQL without an ETL tool.
Prepare a data fixGenerate INSERTs for missing rows, then review before applying.
Load a CSV into SQLite or Postgres quicklyPaste the output into a client to run in one go.
Related tools
All data toolsSQL IN Clause GeneratorTurn a list of values into a ready-to-paste SQL WHERE...IN (or NOT IN) clause.SQL FormatterFormat and indent SQL queries for readability.CSV to JSONConvert CSV data to a JSON array of objects, with a delimiter choice and a header-row toggle.CSV FormatterClean up CSV formatting and convert between delimiters.
Ready to use SQL Insert Generator?
SQL Insert Generator