How does MySQL mode differ?

Identifiers use backticks, booleans become 1 or 0, and NULL/quoting follow MySQL conventions.

How big can each INSERT be?

Batch size is adjustable from 100 to 2000 rows per statement. The default is 500.

Does it escape backslashes?

Single quotes are doubled per the SQL standard. For strict MySQL modes that also treat backslashes specially, review the output before running it.

Is the data uploaded?

Never. The whole conversion runs inside your browser.

MySQL INSERT statement generator

Pick MySQL in the dialect dropdown and the generated SQL switches to MySQL rules: identifiers are wrapped in backticks, booleans are written as 1 and 0, and string values keep single quotes escaped as '' so a name like O'Brien inserts cleanly.

Bring your data as CSV, Excel, JSON, or TSV. All of it is processed locally, so imported rows that contain customer details stay on your machine.

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, or click a sample.
2Set Dialect to MySQL.
3Adjust the table name and the rows per INSERT batch.
4Copy the statements into your MySQL client.

Frequently asked questions

How does MySQL mode differ?: Identifiers use backticks, booleans become 1 or 0, and NULL/quoting follow MySQL conventions.
How big can each INSERT be?: Batch size is adjustable from 100 to 2000 rows per statement. The default is 500.
Does it escape backslashes?: Single quotes are doubled per the SQL standard. For strict MySQL modes that also treat backslashes specially, review the output before running it.
Is the data uploaded?: Never. The whole conversion runs inside your browser.

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.