Generator
SQL INSERT Generator
Paste CSV, TSV, or other delimited text, preview the parsed rows, and generate valid INSERT statements for MySQL, PostgreSQL, SQLite, or MSSQL.
Used when header row is off. Leave empty to auto-generate column_1, column_2, and so on.
Validation
Paste data, choose your options, then generate SQL.
Output actions
What this handles
- Quoted CSV values, including commas inside fields
- Apostrophes escaped as doubled single quotes
- Blank rows skipped safely during parsing
- Numbers kept unquoted when possible
- Boolean handling for MySQL, PostgreSQL, SQLite, and MSSQL
Parsed data preview
Preview the rows that will be used to build your INSERT statements.
No preview yet. Generate SQL to inspect parsed rows.
Generated SQL
Client-side only, ready to copy or download.
How to use
Paste your structured text, set the table name, choose whether the first row is a header, then generate SQL.
Good for
Seed data, quick fixtures, database testing, migration prep, and browser-only mock data creation.
Notes
If row widths differ, the tool warns you and fills missing values using the selected blank-cell behavior.