The everyday "what is in one list but not the other" problem
This comes up constantly outside of programming. You have a list of everyone invited and a list of everyone who replied, and you need the people who have not responded. You have last month's subscribers and this month's, and you want to know who joined and who left. You have a list of product codes from two systems and need the ones that do not match.
The underlying question is always the same: given List A and List B, what is only in A, what is only in B, and what is in both? A diff tool answers all three at once, and it is far faster and less error-prone than scanning two columns by eye or building a spreadsheet formula.
Step one: one item per line
A line-based diff compares line by line, so the first step is to get each list into a format where every item sits on its own line. If your list is comma-separated or spread across a row, convert it to one-per-line first — in a spreadsheet, that usually means putting the items down a single column and copying that column.
Paste List A into the left panel and List B into the right panel of the Text & Code Difference Checker. Leave the language as plain text. You do not need to compare anything else on the page — for list comparison the two panels of text are all you need.
Step two: sort both lists first
This is the step that makes list comparison actually work. A diff tool compares position by position, so if your two lists are in different orders, almost everything shows up as different even when the lists contain mostly the same items.
Sort both lists alphabetically (or numerically) before comparing. In a spreadsheet, select the column and sort A→Z. In many text editors there is a "Sort Lines" command. Once both lists are sorted the same way, identical items line up next to each other and drop out of the diff, leaving only the genuine differences: items that appear in one list but not the other.
After sorting and comparing, the removals (red) are items only in the left list, and the additions (green) are items only in the right list. Lines with no colour are the items present in both.
Reading the result: A-only, B-only, and shared
Once both lists are sorted and compared, the diff answers all three questions directly:
Only in List A (removed / red): these lines exist in the left panel but not the right. If A is your invite list and B is your reply list, these are the people who have not replied.
Only in List B (added / green): these lines exist in the right panel but not the left. In the same example, these are replies from people who were not on the invite list.
In both (unchanged): lines with no highlight appear in both lists. Turn on "Hide unchanged" to collapse these and leave only the differences on screen — useful when the shared portion is large and you only care about what differs.
Handling case, whitespace, and duplicates
Real lists are messy, and a few options clean up the comparison:
Ignore case treats [email protected] and [email protected] as the same. Turn it on when the items are emails, usernames, or anything where capitalisation should not count as a difference.
Ignore whitespace removes false differences caused by trailing spaces or inconsistent spacing — very common when data was copied from different sources.
Duplicates need a decision. If an item appears twice in one list and once in the other, the diff will show one instance as a difference. If you only care about the set of distinct items, remove duplicate lines in both lists first (most spreadsheets have a Remove Duplicates command). If duplicates are meaningful — say, counting how many times something occurs — leave them in and read the counts carefully.
When a spreadsheet formula is the better tool
A visual diff is ideal for a one-time answer you can read immediately, and for lists up to a few thousand items it is the quickest route. But if you need a comparison that updates automatically as the lists change, a spreadsheet formula is the better fit.
In Excel or Google Sheets, =COUNTIF(ListB, A2) tells you how many times each item from List A appears in List B — zero means it is missing. Filtering on that column gives you a live "only in A" view that recalculates whenever the data changes. Use the formula approach when the lists are part of an ongoing process; use the diff tool when you just need the answer once, right now, without setting anything up.