Compare Two Columns or Lists

Paste two lists, or pick two columns from a spreadsheet, and see what matches and what is missing on each side.

Your files are read in this browser tab and never uploaded.

Paste two lists

Pick two columns from a file

List A (one value per line)

List B (one value per line)

Ignore extra spaces

Ignore upper/lower case

How to compare two columns without a formula

Paste List A and List B (one value per line), or switch to Pick two columns from a file and upload your .xlsx or .csv.
Keep Ignore extra spaces and Ignore upper/lower case ticked so "SKU-1 " and "sku-1" count as the same value.
Click Compare. You get three lists: in both, only in A, only in B.
Copy any list, or download all three as one Excel file with a sheet each.

When people use this

Inventory and listings: which SKUs are in your warehouse file but missing from your store export.
Email and CRM lists: which subscribers are not yet in the CRM, or which contacts unsubscribed.
Attendance and rosters: who registered but did not attend, or who is on payroll but not on the HR roster.
Need whole rows instead of single values? Use Compare Excel Files, which returns the full missing rows.

Frequently Asked Questions

It gives the same answer as =ISNA(MATCH(A2,B:B,0)) or a COUNTIF check in both directions, without writing or dragging formulas, and it handles both directions at once.

No. Each output list shows every value once, in the order it first appears.

There is no fixed limit. Lists with hundreds of thousands of values work on a normal laptop because the comparison uses hash sets inside your browser.

No. The page reads your text and files in the browser tab. Nothing is sent to our server.