SQL INSERT Generator Online - Script Builder

SQL INSERT Generator

This SQL INSERT generator turns a table into an INSERT INTO script. Type rows into a grid, paste CSV, or upload an Excel sheet, and copy one multi-row INSERT statement for seed data, test fixtures, or a quick data migration. It runs entirely in your browser, so the data is not uploaded.

What the Output Looks Like

Given a table with the headers id, name, and email:

INSERT INTO `table_name` (`id`, `name`, `email`)
VALUES
  (1, 'Alice', 'alice@example.com'),
  (2, 'O''Brien', NULL);

How values are written:

Column names come from the header row and are quoted with backticks. The table name is the placeholder table_name; replace it with your real table name after copying.

The multi-row VALUES syntax is supported by MySQL, PostgreSQL, and SQLite.

Common Uses

• Seed or fixture data for local development and automated tests
• Moving a small spreadsheet or CSV export into a database table
• Writing a reproducible data patch to review in a pull request

How to Generate SQL INSERT Statements

1. Add your data:
   • Click Generate Table, set rows and columns, and fill in the Table Editor, or
   • Paste CSV, a Markdown table, JSON, or YAML into the input panel, or upload .csv, .xlsx, or .xls
2. Make sure the first row contains the exact column names of your database table.
3. Set the output format to SQL.
4. Click Copy, or Download to save table.sql.
5. In your editor, replace table_name with the real table name, then run the script.

Adapting the Script to Your Database

• MySQL / MariaDB / SQLite: backtick-quoted identifiers work as is. SQLite accepts backticks for MySQL compatibility, as noted in its keyword documentation
• PostgreSQL: identifiers are quoted with double quotes, not backticks. Replace every backtick with " before running, see PostgreSQL identifiers
• SQL Server: replace backticks with double quotes or square brackets

Check These Before Running

• Leading zeros: a value like 007 is digits only, so it is written unquoted and a database will read it as the number 7. Quote such codes manually if the column is text
• Negative numbers and dates: -5 or 2026-01-31 are written as quoted strings. Most databases convert them when the target column is numeric or a date, but check strict modes
• Booleans: true / false are written as strings 'true' / 'false'; change them to the form your database expects
• Large scripts: one statement holds all rows. Very large inserts can hit statement size limits (for example MySQL's max_allowed_packet), so split big datasets into batches

FAQ

Q: How do I generate an SQL INSERT script from a table?

Put your data in the Table Editor (generate a grid, paste CSV, or upload Excel), keep the first row as column names, set the output to SQL, and copy the result. You get one INSERT INTO ... VALUES statement with a row for each table row.

Q: Can I convert CSV to SQL INSERT statements?

Yes. Paste the CSV into the input panel with the input format set to CSV, or upload the .csv file, then choose SQL as the output format.

Q: How do I set the table name?

The output uses the placeholder table_name. Replace it in your SQL editor after copying, for example with find and replace.

Q: How are NULL values and numbers handled?

Empty cells and cells containing the text NULL become NULL. Values made only of digits (with an optional decimal part) are written without quotes. Everything else is a single-quoted string with embedded quotes doubled, as the PostgreSQL docs on string constants describe for standard SQL.

Q: Does the script work in PostgreSQL?

After one change: PostgreSQL quotes identifiers with double quotes, so replace the backticks around the table and column names with ". The multi-row VALUES syntax is supported (PostgreSQL INSERT).

Q: Can it generate CREATE TABLE or random test data?

No. This tool writes INSERT statements for the data you enter or paste. Create the table first, and use your own values or another data source for the rows.

Q: Is my data uploaded?

No. The SQL is generated in your browser and your data stays on your device.