SQL IN list
Turn a pasted spreadsheet column or one-value-per-line TXT file into a quoted SQL IN fragment.
- 1Add input
- 2Adjust settings
- 3Get your result
Tool input and files are processed in this browser without being uploaded.
Before you start
Paste a single column of IDs or names and generate an IN (...) fragment. Choose Text or Number before generating, then check skipped blank rows and repeated values.
How to use this tool
- Paste one spreadsheet column or open a UTF-8 TXT file with one value per line.
- Choose Text for IDs/names or Number for numeric columns, and check the preflight counts.
- Generate the fragment, review its quoting and target column type, then copy or download the complete SQL.
Supported inputs and limits
Processes input locally; no query is executed or sent to a server.
One value per line, up to 50,000 lines. Blank rows are skipped; duplicates are retained.
Text uses standard SQL apostrophe doubling. Backslashes and control characters are rejected because SQL dialects differ. Use query parameters for untrusted or dynamic data.
Large IN lists and NULL matching depend on your database; this tool does not validate a complete query.
Worked example
Example input
Mori O'Brien
Example options
{"type":"text"}Example output
IN ('Mori', 'O''Brien')When something does not work
No query is executed. If a pasted range contains tabs, select only one column; for backslashes or dynamic data, use query parameters.
Frequently asked questions
Can I paste a column copied from Excel?
Yes. Paste one column; each row becomes one SQL value. Empty rows are skipped and duplicates remain visible in the counts.
When should I choose Number?
Only for numeric database columns. Keep IDs with leading zeros in Text mode. For untrusted or dynamic data, use parameterized queries.
Is my input sent to a server?
No. Tool input is processed in your browser, not sent to a server. Temporary workspaces stay in the same tab and are cleared by a refresh or tab closure. Save the results you need.
Documentation & further reading
Related tools
JSON formatting workspace
Format or minify strict JSON, sort object keys, and encode or decode strings while preserving raw number tokens.
Regex tester
Try a pattern and see what it matches in your text.
Compare text
See what changed, side by side.
HTML formatter
Format HTML indentation so its structure is easier to read.