SQL IN clause generator

Paste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...). Free, and your data never leaves your browser.

Input
Result
Ad space: paste your AdSense code here

How to use it

  1. Copy a column in Excel and paste it into the input box.
  2. Choose the quote style, separator and options such as remove duplicates.
  3. Click Copy and paste the result into your SQL query.

Frequently asked questions

How do I convert an Excel column to a comma separated list?

Copy the column, paste it here, and choose Comma as the separator. The result updates as you type.

Is there a limit on how many values an IN list can hold?

It depends on the database. Oracle allows 1,000 items in an IN list, while others allow more. For very long lists, split them or use a temporary table.

More SQL tools

🔄 Rows ↔ columnsSwap pasted data so vertical becomes horizontal, and the other way round.✂️ Split to rowsTurn one line like a,b,c into one value per row.📥 Excel to INSERTPaste rows copied from Excel and get one INSERT statement per row.⚖️ Compare two listsFind what is in one list but not the other, what both share, or all unique values.🧹 Clean & sort linesTrim spaces, remove duplicates, sort, change case, and add text to every line.✨ SQL formatterPut each major clause on its own line and uppercase keywords.