Databases

SQL INSERT Generator from CSV

Create simple SQL INSERT statements from CSV data. The tool runs locally in the browser, does not execute SQL and is useful for test data, import preparation and small database examples.

CSV input

CSV data

Table name

Override columns manually

Delimiter

Identifier quoting

Output

Batch size

Options First CSV row contains column names Output empty fields as NULL Detect numbers, Boolean values and NULL automatically Add a comment with table name and row count

Analysis

No CSV data has been analyzed yet.

Lines0

Rows0

Columns0

Delimiter-

SQL statements0

This tool creates text output only. It does not connect to a database and does not execute SQL statements.

SQL output

Ready

Preview

The preview shows at most the first 20 data rows.

Usage notes

Column names are cleaned so that simple SQL identifiers are created.
Text values are output with single quotes and internal quotes are doubled.
For production data, data types, constraints and maximum packet sizes should be checked separately.
Large imports are usually better handled by native database import features.