Compare Two Excel Lists Online — Missing & Matching Values

Compare pasted columns from Excel, find items missing from the first or second list and identify matching values. Free, private in-browser tool.

Excel list comparison: missing values and intersections

Paste the first list, a line with --- and the second list. Select full report, unique values or matches. Values are compared after optional trimming.

All conversion work is performed locally in your browser. Guides and examples · All tools

Example: identify missing spreadsheet IDs

Suppose one Excel export contains A101, A102 and A105 while another contains A102, A105 and A109. Paste the values from the first column, add a line with ---, then paste the second column:

A101
A102
A105
---
A102
A105
A109

The values unique to the first list are A101, unique to the second list are A109, and common values are A102 and A105. This is a text comparison; the tool does not directly load a binary Excel .xlsx file.

Read the full guide with Excel COUNTIF formulas for an alternative that runs inside the spreadsheet.

Why two lists may not match

IDs containing leading zeros should often be imported as text: 00123 and 123 may be different identifiers. Leading or trailing spaces, capitalization, duplicate values, and hidden Unicode characters can also affect matching. Agree on a comparison rule and verify example records before using the result to update a workbook.