How to use it
- Paste the first list into List A, one item per line.
- Paste the second list into List B.
- Leave Ignore case and Ignore extra spaces ticked, or untick them for exact matching.
- Read the three groups, then copy one or download all three as CSV.
Worked example
The sample lists hold 6 and 5 emails. With Ignore case ticked, 3 are in both (ben, Chloe and dev), 3 are only in list A (ana, elena and farid) and 2 only in list B (grace and hiro); Chloe@Example.com matches chloe@example.com.
Formats and limits
| Input | Lists, one item per line, Columns pasted from Excel |
|---|---|
| Output | Only in A, only in B, in both, CSV |
| Engine | Key-based row matching with per-cell comparison and optional numeric tolerance |
Limitations
- Items match only when they are the same after the case and space options; near spellings such as Jon and John do not match.
- A pasted row with several cells is one item unless Also split on commas, semicolons and tabs is ticked.
- Up to 2,000 items per group are listed on screen; Copy and Download include all of them.
Questions
How do I compare two columns from Excel?
Copy the first column in Excel or Google Sheets and paste it into List A, then paste the second column into List B. Each line becomes one item, and the three groups update as you paste.
Are repeats within a list counted?
Each item is listed once, with the spelling of its first appearance. The note under each box says how many items repeat, so 5 lines with one repeat show as 4 distinct items.
Why do Apple and apple match?
Ignore case is ticked by default. Untick it for an exact match, and untick Ignore extra spaces to treat New York with two spaces as a different item.
Is my list uploaded?
No. Both lists are compared in your browser; nothing is uploaded or stored.
Privacy
Runs on your device. Files and text are processed in this browser tab and are not uploaded.
This page opens the Spreadsheet comparison ready for this task. See the privacy policy for how toolsdocks handles data.