Compare two lists

Find what is in one list but not the other, what both share, or all unique values. Free, and your data never leaves your browser.

Input
Result
Ad space: paste your AdSense code here

How to use it

  1. Paste list A in the first box and list B in the second.
  2. Choose what to show, such as In A, not in B.
  3. Copy the result.

Frequently asked questions

How do I find items in one list but not the other?

Paste both lists and choose In A, not in B (or In B, not in A).

Is the comparison case sensitive?

By default yes. Tick Ignore upper/lower case to match regardless of case.

More SQL tools

📋 List to IN clausePaste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...).🔄 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.🧹 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.