Compare Two Lists

Find matches and differences in your browser.

How to compare two lists

Paste one item per line into List A and List B, or choose a UTF-8 TXT, CSV, or TSV file, or an XLSX workbook for each list. Select the column to compare and skip the header for CSV, TSV or XLSX. XLSX opens the first visible worksheet and reads saved values. Ignore case, trim lines, and remove empty lines are on by default. Turn them off to keep those differences. Product IDs such as 00123 stay distinct from 123.

Example

apple
banana
cherry
fig
banana
cherry
date
grape

Comparing the two lists above returns apple and fig as only in A, date and grape as only in B, and banana and cherry as present in both lists.

List comparison outputs

The comparison returns five result panels: only in A, only in B, in both lists, union, and symmetric difference. Each panel can be copied or downloaded as TXT or single-column CSV. Advanced settings can also report differences in item counts separately. The first matching spelling from A is shown when both lists contain the item. Results follow input order unless you select Sort results. Use CSV to preserve line breaks inside a field. To keep leading zeros in a spreadsheet, import the CSV column as text.

Common uses

Compare email segments, product IDs, keyword sets, inventory exports, URL lists, user IDs, or any line-based data from spreadsheets and text files. It also works as a quick way to compare two columns in Excel or Google Sheets: copy each column, paste it into a list, and read the differences.

Compare spreadsheet columns or SKU lists

Paste these CSV samples into A and B. Choose CSV and column 2 on both sides, and turn on Skip header.

name,sku
Cable,00123
Adapter,410
Spare adapter,410
name,sku
Cable,123
Adapter,410
Dock,550

Only in A is 00123. Only in B contains 123 and 550. In both contains 410 once, and List A reports one duplicate. For two columns copied together from a spreadsheet, choose TSV and select the relevant column in each panel.

This workflow checks whether a value exists in each list. It ignores row order and compares only the selected column. CSV downloads preserve values as entered. Import untrusted values as text to avoid spreadsheet formula interpretation.

Trace results to the source file

Turn on Include source lines in CSV under Advanced settings to export line numbers from both inputs. Try the inventory audit walkthrough for an example with repeated SKUs. For field changes after matching rows by SKU, use Compare Spreadsheets by Key. See the spreadsheet column guide for a membership check. Use Text Diff for line-order changes or Merge Lists to combine the inputs.

FAQ

What is a list comparison tool?

A list comparison tool checks two lists against each other and shows what differs and what matches. This one also returns the union and symmetric difference, and runs entirely in your browser.

How do I compare list A and list B?

Paste one list into List A and the other into List B, one item per line. The tool shows items only in A, only in B, and items shared by both lists.

What is symmetric difference?

Symmetric difference means items that appear in one list or the other, but not both.

How do I compare two columns in Excel or Google Sheets?

Copy each column and paste it into List A and List B. Only in A, only in B, and in both show where the columns differ and where they match.

Are duplicates removed before comparing?

Yes. Each list is treated as a set after optional trimming and empty-line removal.

Can I compare case-insensitively?

Yes. Ignore case is enabled by default and can be turned off.

What does union mean?

The union is every item that appears in either list, with duplicates removed.

How many items can I compare?

Each input is limited to 10 MiB and 500,000 text or table rows. XLSX worksheets support up to 250,000 rows. Large results show a preview, and copying or downloading includes every result.