Compare two Excel lists without writing formulas
Last updated: 2026-08-02
If you need to compare 2 Excel lists—IDs, emails, SKUs, names—and know what differs, what matches, or what repeats, you do not have to build lookup formulas. Copy each column, paste it into the compare tool, and read the results in your browser.
What you can answer in a few minutes
- Differences: values that show up in one list but not the other.
- Matches: values that appear in both lists.
- Duplicates: values that repeat inside the same list before you trust the final set.
Fast method: copy, paste, compare
- In Excel, select one column (or the part of a column you care about) and copy it.
- Paste it into the first list on the compare page.
- Copy the second column the same way and paste it into the second list.
- Run the comparison.
- Check three kinds of results first: only in the first list, only in the second list, and in both. Those cover most “what’s different / what’s the same” questions.
Tip: compare one logical value per row—usually one ID or label—not a full multi-column row stuck together. If you need paste details for messy spreadsheet copies, see the Excel paste tips.
Find differences
After you compare, look at values that exist in only one list. That is the practical answer when you want to know what is missing, extra, or out of sync between two spreadsheet columns.
- Only in list 1 → present in the first spreadsheet column, absent from the second.
- Only in list 2 → present in the second column, absent from the first.
- Need both sides in one view? Use the combined “exactly one list” result when available.
Find matches
Matches are the overlap: values that appear in both columns. Use this when you want shared customers, shared SKUs, or confirmed overlap before you act on the leftovers.
Check for duplicates
Spreadsheet exports often repeat the same ID. Scan each side for repeats before you treat a difference list as final. Cleaning duplicates first keeps your “missing” and “extra” results honest.
Google Sheets works the same way
The steps are identical in Google Sheets: copy one column, paste into the first list, copy the other column, paste into the second list, then compare. You do not need a Sheets formula for a straight list-to-list check.
When a formula in Excel still makes sense
- You must keep everything inside one workbook for audit or handoff rules.
- You are matching across many columns with complex conditions, not a single key.
- You need live formulas that update as the sheet changes.
For a one-time check of two plain lists, pasting into the browser tool is usually faster than building and debugging lookups.
Common snags
- Extra spaces in cells can make two identical-looking values look different—trim before you trust the result.
- Blank rows inflate counts; remove empty cells when they do not mean anything.
- Letter case can matter. Decide whether
ABCandabcshould count as the same. - If overlap looks too low, confirm you copied the same kind of value on both sides (for example ID vs name).
FAQ
Do I need VLOOKUP to compare two Excel lists?
No. For one-value-per-row lists, paste both columns and read the difference and match results directly.
How do I find differences between two Excel lists?
Paste both columns, then look at values that appear in only one list. Those are your differences.
How do I find matches between two Excel lists?
After you compare, open the overlap result—the values that appear in both lists.
Can I do the same thing in Google Sheets?
Yes. Copy a column from Sheets the same way you would from Excel, then paste and compare in your browser.