What is a good batch size?

500 rows is a safe default. Use 1000 or 2000 when your client allows larger packets, or 100 for very wide tables.

How many statements will it produce?

The toolbar shows the row count and statement count, so you can plan before running anything.

Is there a size limit?

Guests process up to 500 rows; a free account processes up to 50,000 rows, all in the browser.

Will it include a transaction wrapper?

No. Wrap the statements in BEGIN/COMMIT yourself if you want the whole load to be atomic.

Bulk INSERT SQL generator

A bulk INSERT packs many rows into one statement, which is far faster to run than thousands of single-row inserts. This generator writes them for you from CSV, Excel, JSON, or TSV.

Set the rows per statement to match your database's limits, then copy the whole set at once. Large files are handled in a Web Worker so the page stays responsive.

SQL INSERT

Drop a file to generate INSERT statements

Processing stays in this browser. Guests can process up to 500 rows per file.

How to use this tool

1Drop your data file.
2Set Rows per INSERT to 500, 1000, or 2000 depending on your database.
3Review the statement count shown in the toolbar.
4Copy the bulk statements.

Frequently asked questions

What is a good batch size?: 500 rows is a safe default. Use 1000 or 2000 when your client allows larger packets, or 100 for very wide tables.
How many statements will it produce?: The toolbar shows the row count and statement count, so you can plan before running anything.
Is there a size limit?: Guests process up to 500 rows; a free account processes up to 50,000 rows, all in the browser.
Will it include a transaction wrapper?: No. Wrap the statements in BEGIN/COMMIT yourself if you want the whole load to be atomic.

Private by design

This tool runs entirely in your browser. Files, tables, and results are never uploaded to a server — you can even disconnect your network and keep working. See the Privacy Policy.