Sql Insert Generator

Converts CSV-style rows into INSERT statements. Enter a table name, a comma-separated column list, and one row per line of values, then choose between a single batch INSERT (one statement with multiple value tuples) or individual INSERT statements (one per row). It supports quoted CSV fields, escapes single quotes, and renders numeric and empty values appropriately.

1. Set the Table Name (e.g. users). 2. Choose Insert Mode: Batch or Individual. 3. Enter Columns as a comma-separated list (e.g. id, name, email, age). 4. Paste Data Rows, one row per line, with values separated by commas. 5. Click Generate to produce the SQL; the badge shows how many rows were generated.

Empty values become NULL. Pure numeric values (optionally with a decimal part) are emitted unquoted. Strings are wrapped in single quotes with embedded single quotes doubled (''). Fields containing commas can be wrapped in double quotes, and doubled double quotes inside such fields are collapsed back to a single quote. Each row's field count is validated against the column list and a column-mismatch toast halts generation on the offending row.