CSV to SQL INSERT statements
Drop a CSV and get INSERT statements back. The parser tolerates the messy files people actually have: semicolon and tab separators are auto-detected, unclosed quotes are reported with a line number, and GBK-encoded exports from Chinese Excel open without garbled text.
Every value is escaped for the dialect you pick, so a name like O'Connor becomes 'O''Connor' in the SQL instead of breaking the statement.
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 CSV (or TSV / TXT) onto the panel.
- 2Confirm the auto-detected separator and encoding notes.
- 3Set the table name and dialect, and adjust the rows per INSERT batch.
- 4Copy or download the generated .sql file.
Frequently asked questions
- Does it handle commas inside quoted fields?
- Yes. CSV quoting follows RFC 4180, so commas, double quotes, and line breaks inside a cell are preserved.
- Can it read semicolon-separated files?
- Yes. The delimiter is detected from the first rows, and the app tells you when it chose something other than a comma.
- How many rows can I convert?
- Guests can process up to 500 rows per file. A free account raises that to 50,000 rows, still entirely in your browser.
- Are empty cells written as NULL?
- Empty cells and the text NULL (case-insensitive) become NULL. Other placeholders like NA or - are kept as text.
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.