Skip to content

Compare two lists

Paste two lists of emails, names or IDs and see what is only in one, only in the other and in both. Ignore case and spaces; nothing is uploaded.

  • Runs in your browser
  • Nothing is uploaded
  • Free, no sign-up

No items yet

No items yet

How to compare

Paste a list on each side to see what they have in common and what differs.

How it works

Paste two lists, one item a line, and the page finds the list difference both ways: the items only in list A, the items only in list B, the items in both, and the two lists combined with no repeats. Use it to see who is on an old mailing list but not the new one, which invoice numbers are missing from a payment report, or which products two suppliers both stock. Everything happens on your device, so the lists can hold personal data.

Items match when they are the same text. By default upper and lower case don't count, across alphabets: ß matches SS, Greek final ς matches σ, and the Turkish İ and ı match i. Spaces at the start and end of an item don't count either, and blank lines are never items. The same text typed in two ways (é as one character, or as e followed by an accent) always matches. Turn the options off for an exact comparison.

With duplicates removed, each item is listed once, written as it first appears, and items in both lists are written as list A has them. Items that appear more than once in a list are shown separately with how many times, so you can find repeated entries too. Turn duplicate removal off to keep every line: then only in list A lists each copy of an item missing from list B. Results keep the order of the lists unless you sort them A to Z, with numbers in number order (item 2 before item 10).

Lists from an email client or a spreadsheet row can be split at commas, semicolons or tabs as well as new lines. To compare two versions of a document line by line instead, use Text compare; to change the case of a whole list, use the Case converter.

Questions

How do I compare two lists to find the differences?

Paste one list into List A and the other into List B, one item a line. The page shows at once what is only in list A, what is only in list B, and what is in both, each with a count, a Copy button and a .txt download. A column copied from Excel or Google Sheets pastes as one item a line, so it works as it is.

How is this different from text compare?

Text compare is a diff checker: it lines two versions of a document up and shows which lines and words changed, so order matters. Compare two lists treats each list as a set of items: order doesn't count, repeats are counted, and the answer is which items are in one list, the other or both. Use text compare for two versions of a text, and this page for two lists of emails, names, IDs or invoice numbers.

How do I compare two lists in Excel?

In Excel, put the lists in columns A and B, then in C1 type =COUNTIF(B:B,A1)=0 and fill it down: TRUE marks items of list A that are missing from list B. Swap the columns for the other way round, or use Conditional Formatting, Highlight Cells Rules, Duplicate Values to colour the items in both. Like COUNTIF, this page ignores upper and lower case by default, and it also ignores stray spaces, which make COUNTIF miss matches.

Are my lists uploaded anywhere?

No. Both lists are compared in your browser, so customer emails, staff IDs or anything else you paste never leave your device: nothing goes to kitkeeps or anyone else, nothing is put in the page address, and nothing is kept once you close the page.

Limits

Each list can have up to 1,000,000 items. The comparison runs in the background, and 100,000 items on each side take a fraction of a second, though the browser itself takes a moment to show such long lists in the boxes. Each result shows its first 1,000 items; Copy and Download always give all of them. Items match only when their text is the same once case and outer spaces are set aside: "Jon Smith" and "Smith, Jon", or a phone number written with and without spaces, are different items. Accents count, so "José" and "Jose" differ.

Each line is one item, so a list pasted from a spreadsheet should be a single column; splitting at commas doesn't understand quoted CSV fields. Files can't be opened yet: copy the column and paste it. Your lists aren't kept anywhere, not even in the page address, so reloading the page clears them.

Privacy

This tool runs entirely in your browser. The files you open and what you type are never sent to a server, and nothing is stored after you close the page. See the privacy page.

Related tools