What is a list comparison tool?
A list comparison tool treats each item as a member of an unordered set. It finds items that appear only in the first list, only in the second list, or in both lists. This is useful for checking IDs, URLs, keywords, email addresses, product codes, dependencies, and other discrete values.
The result contains each matched value once. Each input summary reports extra duplicate occurrences so you can see why the item count is larger than the unique count.
How to compare two lists
- Paste items into List A and List B, open a local TXT, CSV, or TSV text file, or select Example.
- Keep the default one-item-per-line format, or choose another delimiter in Options.
- Enable Ignore case only when values such as
Appleandappleshould match. - Select Compare, then copy a result or open Download to name and save it as TXT.
You can paste columns directly from Excel or Google Sheets. Imported files remain editable text in the two input areas. This tool does not open XLSX workbooks or interpret quoted CSV records.
Example
List A:
applebananacherrybananaList B:
bananacherrydateThe comparison reports apple only in List A, banana and cherry in both lists, and date only in List B. All Differences contains apple and date. List A also reports one extra duplicate occurrence of banana.
Understanding the results
| Result | Meaning |
|---|---|
| Only in List A | Unique items found in List A but not List B |
| Only in List B | Unique items found in List B but not List A |
| In Both Lists | Unique items shared by both lists |
| All Differences | Items found in only one of the two lists |
Original order keeps List A’s order for its results and List B’s order for its unique results. All Differences places List A-only items before List B-only items. A–Z and Z–A change only the displayed, copied, and downloaded order.
Matching and duplicate handling
Leading and trailing whitespace is removed from every item, blank items are ignored, and line endings are normalized. Line breaks always separate items. Comma, Tab, and Semicolon options accept that delimiter in addition to line breaks.
Matching is case-sensitive by default. With Ignore case enabled, the first spelling and capitalization from List A is retained for shared values. Duplicate statistics use the same matching rule.
Internal spaces and leading zeros are not normalized. For example, Product 7 remains different from Product 7, and 007 remains different from 7.
Compare lists vs compare text
This tool compares complete items without considering their positions. It does not highlight words or characters changed inside a line.
| Compare lists | Compare text |
|---|---|
| Each item is an independent value | Input is an ordered document or code file |
| Item order does not affect matching | Line and character positions matter |
| Returns shared and unique items | Highlights additions, removals, and edits |
Use a text diff tool when you need to review edits inside paragraphs, source code, or configuration files.
Common uses
- Compare two spreadsheet columns without writing a lookup formula.
- Check IDs or fields exported from two databases or APIs.
- Find missing URLs, domains, keywords, or email addresses, then open the resulting links with the URL Opener.
- Compare product SKUs, dependency names, routes, or configuration keys.
Compare Two Lists FAQ
Does list order matter?
No. Matching uses unique item values, not line positions. Original order is preserved only for displaying the results.
How are duplicate items handled?
Each result contains one copy of a value. The input summary reports how many extra duplicate occurrences were removed from the unique comparison set.
Is the comparison case-sensitive?
Yes, by default. Enable Ignore case to match values that differ only by capitalization while preserving the first original display value.
Can I compare CSV or TSV files?
You can open UTF-8 CSV, TSV, and TXT files as plain text and choose the matching delimiter. Quoted fields, embedded delimiters, headers, and workbook features are not parsed as table structure. Use the CSV Viewer when you need to inspect structured CSV data first.
Can I compare more than two lists?
No. This tool is intentionally limited to two lists. Comparing three or more lists needs a different result model and is not included here.
Are my lists uploaded?
No. The comparison, file reading, copying, and TXT generation happen locally in your browser.