Compare Two Lists to Find Differences Free

To compare two lists and find the differences, first put both in the same order with the free alphabetizer (A to Z, duplicates removed), then paste them into the two boxes of the free text compare tool and compare by Lines. Anything shown in pink is only in the first list; anything in green is only in the second. Items in both lists stay unhighlighted. It takes about a minute, and neither list leaves your device.

Why you sort first

A text comparison works through both lists from top to bottom, matching lines in order. If the lists are in different orders, the same name in a different position looks like a removal plus an addition, and the result fills with false differences.

Sorting both lists the same way lines up the matching items, so the only highlighted lines are the real differences. Removing duplicates and stray spaces at the same time stops Aarav Shah and Aarav Shah (with a trailing space) from looking different.

How to compare two lists

Prepare list 1:

1. Open the free alphabetizer and paste the first list, one item per line.
2. Choose A to Z, tick Remove duplicates, and leave Ignore capitals, Trim spaces and Remove empty lines ticked.
3. Click Copy result.
4. Open the free text compare tool in another tab and paste into Original text.

Prepare list 2:

5. Back in the alphabetizer, click Clear, paste the second list, and copy the result with the same settings.
6. Paste it into Changed text.

Compare:

7. Select Lines and tick Ignore capitals and Ignore extra spaces.
8. Click Compare. The summary shows, for example, "− 2 lines removed + 1 line added".

Worked example: registered vs attended

A workshop had 8 registrations and 7 people signed the attendance sheet. After sorting both lists, the comparison looks like this:

Registered (original)	Attended (changed)
Aarav Shah	Aarav Shah
Ananya Iyer	ananya iyer
Dev Patel	Dev Patel
Ishita Rao	Ishita Rao
Kabir Singh (pink)
Meera Nair (pink)
	Nikhil Jain (green)
Rohan Gupta	Rohan Gupta
Zoya Khan	Zoya Khan

Reading it:

• Pink, only in the first list: Kabir Singh and Meera Nair registered but didn't attend.
• Green, only in the second list: Nikhil Jain attended without registering, perhaps a walk-in or a name spelled differently on the form.
• ananya iyer matched Ananya Iyer because Ignore capitals was on.

So 6 people were on both lists, 2 were no-shows and 1 was unexpected.

Everyday uses

• Attendance: class roll vs today's sign-in sheet, to find who was absent.
• Wedding or event invites: guest list vs RSVPs, to see who hasn't replied yet.
• Fees or dues: member list vs payments received, to chase who hasn't paid.
• Email lists: last month's subscribers vs this month's, to see who left and who joined.
• Stock checks: item codes in the system vs codes scanned on the shelf.
• Group chats and forms: the class list vs the names who submitted an assignment form.

Getting lists out of spreadsheets, forms and chats

• From Excel or Google Sheets, copy a single column. Each cell becomes a line.
• From a comma-separated line, like Asha, Ravi, Meera, set Items are separated by to Commas under Separators and numbering in the alphabetizer. The result comes back one per line, ready to compare.
• From a WhatsApp message or email, paste and check each name is on its own line. If names run together in a paragraph, put them on separate lines first. If they've been broken across lines oddly, the free line break remover can help tidy them.

Watch for near-matches

The comparison is exact, apart from capitals and spaces. These will all show as differences even though they're the same person or item:

• Mohd. Imran and Mohammed Imran
• Priya Sharma and Sharma Priya
• +91 98200 12345 and 9820012345
• INV-0042 and INV-42

After comparing, glance at the pink and green items side by side. If a pink and a green item are obviously the same thing, it's a spelling difference, not a real gap. For phone numbers and codes, make the format consistent in your spreadsheet before comparing.

Comparing one list against itself to find repeats is a different job; for that, see removing duplicates from a list. For comparing paragraphs of text rather than lists, our guide to comparing two texts for differences covers the word and character views.

Spreadsheet alternative

If both lists live in the same spreadsheet, a formula like =COUNTIF(B:B, A2)=0 next to list A returns TRUE for items missing from list B. It's handy for repeated monthly checks. The sort-and-compare method above is quicker for a one-off, and works just as well with lists from emails, chats or PDFs.

Compare your lists now

Sort both lists with the free alphabetizer, then paste them into the free text compare tool and compare by Lines. It's free, there's no sign-up, and nothing is uploaded.