Which characters are escaped?

Single quotes are doubled. Commas and line breaks are kept inside their quoted string literal, which is what makes the statement valid.

Are newlines kept in the output?

Yes. A multi-line cell is written as a single-quoted string that spans lines, so the data is not lost.

Does it handle tab characters?

Yes. Tabs inside a cell are preserved as text within the quoted value.

Is the escaping dialect-specific?

String escaping is the same across PostgreSQL, MySQL, and SQLite; identifier quoting differs, and that follows the dialect you select.

Escape special characters in SQL INSERTs

Commas, apostrophes, and line breaks inside cells are the usual reasons a hand-built INSERT fails. This page reads your file with RFC 4180 CSV rules, so those characters stay inside their cells, and then escapes quotes when writing the SQL.

Line breaks inside a cell are preserved in the string literal, and single quotes are doubled. The result is SQL you can paste without hunting for the one value that breaks it.

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 the file with the tricky values.
2Expand the SQL pane to inspect how each special character is written.
3Choose your dialect.
4Copy the statements.

Frequently asked questions

Which characters are escaped?: Single quotes are doubled. Commas and line breaks are kept inside their quoted string literal, which is what makes the statement valid.
Are newlines kept in the output?: Yes. A multi-line cell is written as a single-quoted string that spans lines, so the data is not lost.
Does it handle tab characters?: Yes. Tabs inside a cell are preserved as text within the quoted value.
Is the escaping dialect-specific?: String escaping is the same across PostgreSQL, MySQL, and SQLite; identifier quoting differs, and that follows the dialect you select.

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.