Tools › Data formatting › SQL IN-Clause Builder
Turn a pasted list (one item per line, or comma/tab separated) into a ready-to-paste SQL IN clause like 'a','b','c'.
Your data is never sent to a server — everything runs in your browser
How to use
- Paste a spreadsheet column or any separated list.
- Choose string or numeric mode — the result updates instantly.
- Copy the result straight into your WHERE … IN ( ) clause.
Prep ad-hoc queries in seconds
Turning "here's the list of IDs, pull their records" into WHERE id IN ('1001','1002',…) by hand is slow and error-prone. Paste the column here and it's done — blank lines and surrounding whitespace are removed, and in string mode any single quotes inside values are escaped the standard SQL way ('' doubling), so names like O'Brien are safe.
FAQ
Is there a limit to how many items an IN clause can hold?
It depends on the database — Oracle, for example, caps a single IN list at 1,000 items. The item count is shown below the output; split the list or use a temp table if you exceed the limit.
Is my data sent anywhere?
No. Formatting happens entirely inside your browser.