Convert a List to a SQL IN Clause
Paste a column of values and get 'a', 'b', 'c' — quoted, comma-separated, ready for your WHERE ... IN (…).
'.
Paste one item per line and press convert to join it up.
Examples
| Input | Output | |
|---|---|---|
| Simple | 1001 ⏎ 1002 ⏎ 1003 |
'1001', '1002', '1003' |
| Realistic | ORD-9001 ⏎ ORD-9002 ⏎ ORD-9003 |
'ORD-9001', 'ORD-9002', 'ORD-9003' |
Why convert this way
Hand-quoting a list of 200 IDs is where afternoons go to die. Single quotes plus a comma join is the exact shape SQL wants, and doing it by hand is both slow and easy to get wrong by one stray quote.
When you will need it
- Pulling specific records by ID from a spreadsheet of results
- Building a one-off report query from a list someone emailed you
- Filtering by a set of SKUs, emails or order numbers
- Writing a
DELETEorUPDATEscoped to known rows
id is an integer, set wrapping to none — quoting forces a type cast in some databases and quietly kills index usage. Also check for apostrophes in your values; O'Brien needs escaping.
What the settings do here
- Split on newline — the tool reads
1001⏎1002⏎1003as 3 separate items. - Join with ,
— producing
'1001', '1002', '1003'. - Wrapped in
'— turn wrapping off in Options when the values are numeric.
Where this comes up
The realistic scenario is a spreadsheet of flagged accounts from someone in finance, and a request to pull those exact rows. Hand-quoting 200 IDs takes ten minutes and one missed apostrophe breaks the query silently.
Related conversions
Going the other way, or joining with something else entirely? The delimiter converter accepts any split and join pair including custom separators, and the index has the 16 ready-made ones.
Frequently Asked Questions
How do I build a SQL IN clause from a list of IDs?
Paste the column, split on newline, join with a comma and wrap each item in single quotes. The result pastes straight into WHERE column IN (...).
Should numeric IDs be quoted in an IN clause?
No. Quoting an integer column forces a type cast in several databases and can stop the index being used. Set wrapping to none when the column is numeric.