Skip to content

Compare two lists

Compare names or two Excel columns. Find common items and values unique to each list, with options to trim spaces and ignore case.

Enter one item per line. Blank lines and duplicate items are excluded.

Enter one item per line. Blank lines and duplicate items are excluded.

Result

Enter lists to see the comparison.

What you enter is processed only in this browser and is never sent to a server. How it works

Two lists with common and different items connected

Compare names and Excel columns

Paste one item per line into each list. The results separate items found in both lists, only on the left and only on the right. Copy each result separately. If you fill only one side, its unique items appear on that side.

Matching rules and result order

Empty and whitespace-only lines are excluded. Repeated items within a list appear once. Trimming removes spaces at both ends of each line. Ignoring case compares lowercase forms. Results preserve input order; common items use the first spelling from the left list.

Scope and limits

Each input supports up to 200,000 characters. This tool does not parse comma-separated or tab-separated columns: copy one Excel column at a time. Similar names with different spelling remain different. Internal spaces, accents and full-width characters are not normalized.

Sources

Frequently asked questions

Does it compare duplicate counts?

No. It compares whether an item exists. Repeated names count as one item, so this is not a comparison of attendance counts or stock quantities.

Does ignore case follow every language’s rules?

It uses JavaScript Unicode lowercase conversion. It does not apply language-specific dictionary comparison or Turkish-specific casing rules.

Last updated: