Skip to content
toolsdocks

Compare two lists

Paste one list into each box to see what is only in list A, only in list B and in both. This page opens the spreadsheet comparison in Two lists mode; case and extra spaces are ignored unless you untick them.

Runs on your device

More options in the full Spreadsheet comparison.

Loading tool…

How to use it

  1. Paste the first list into List A, one item per line.
  2. Paste the second list into List B.
  3. Leave Ignore case and Ignore extra spaces ticked, or untick them for exact matching.
  4. 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

InputLists, one item per line, Columns pasted from Excel
OutputOnly in A, only in B, in both, CSV
EngineKey-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.