Runs locally in your browser
Turn one value per line into a quoted SQL IN clause with correct single-quote escaping and compact or multi-line output.
About this tool
SQL filters often begin as IDs, names, or codes copied from a spreadsheet. Adding commas and quotes by hand is slow and easy to get wrong.
This formatter doubles embedded single quotes according to standard SQL string-literal rules and can include the IN keyword or output only the parenthesized values.
FAQ
A single quote inside a value is doubled, so O'Reilly becomes 'O''Reilly'.
No. It is a text formatter, not a database parameterization layer. Use prepared statements for untrusted input.
Related tools
Guides
Learn safe methods to convert Excel columns to SQL IN clauses. Handle apostrophes, leading zeroes, query length limits, and use reusable browser tools.
Read guide →