Convert a column to SQL
Paste a single column copied from Excel, Google Sheets, or a CSV file. Empty cells are ignored, and the result is formatted for use in a SQL WHERE id IN (...) query.
The tool also handles tab-separated rows copied directly from a spreadsheet. When multiple columns are pasted, it reads the first column from each row, which makes it convenient to extract an ID list from a larger table.
How values are formatted
Use single quotes for text values, double quotes when your database convention requires them, or no quotes for numeric IDs. Quotes inside values are escaped for SQL automatically.
For example, a column containing 101, 102, and 103 becomes IN (101, 102, 103) with quotes disabled. Text values are commonly formatted as IN ('alpha', 'beta').
Use the generated clause safely
The generated output is intended for quick manual queries and debugging. For application code, prefer parameterized queries instead of concatenating values into SQL, as parameters provide stronger protection against SQL injection.