How to Compare Two Excel Columns Online

Q: How do I compare Excel columns and return a value from a third column?

That's the Column Compare tool . Paste your full datasets with headers, choose which column is the key on each side, and optionally pick a value column to see what changed. It works like VLOOKUP but in the browser.

Comparing two Excel columns is something people do every day and still find annoying. The formula-based approaches work, but VLOOKUP and COUNTIF take time to set up, break when you reorganise the sheet, and are genuinely overkill if you just want a simple answer. Paste your columns here and you get the answer in seconds.

Compare your columns now. Free, nothing to install.

Open Compare Tool →

How to do it

Copy your first Excel column. Click the top data cell, hold Shift, click the bottom one, then press Ctrl+C (or Cmd+C on a Mac). Leave the header out if you have one. You want just the values.
Paste into List A. Click the List A text box and press Ctrl+V. Each cell pastes onto its own line.
Do the same for your second column in List B. Select, copy, click, paste.
Read the results. Four panels update as you paste. No button needed.
- A Only - values in your first column that aren't in the second.
- B Only - values in your second column that aren't in the first.
- A ∩ B - values in both columns.
- A ∪ B - every unique value from either column.
Copy whatever you need. Each panel has a Copy button.

Google Sheets works the same way

Select the column in Google Sheets, press Ctrl+C, paste into ListDiff. Google Sheets and Excel use the same clipboard format when you copy cells, so this tool doesn't know or care which one you're using.

When the results don't look right

Case sensitivity. The comparison is case-sensitive by default. "Apple" and "apple" count as different. If that's causing false mismatches, open Options and uncheck Case Sensitive.

Invisible spaces. If you're getting mismatches that make no sense visually, invisible spaces are usually the culprit. Excel adds them when importing CSVs. The Ignore Leading/Trailing Spaces option (on by default) handles the obvious cases. If something more stubborn is going on, paste your list into the Invisible Character Detector to see exactly what's in there.

Leading zeros. If one column stores "007" and the other stores "7", turn on Ignore Leading Zeros and they'll match.

When this tool is the wrong tool

This tool compares single-column lists by value. If your data has multiple columns and you want to match rows on a key (like a customer ID) and then check what changed in a value column, use the Column Compare tool instead. It's a browser-based VLOOKUP: paste two datasets, pick which columns to match on, and see exactly what changed.

Working with multi-column data?

Column Compare matches two datasets by a key column and shows what changed.

Try Column Compare →

Frequently Asked Questions

How do I compare two columns in Excel for matches?

Paste each column into the List A and List B boxes on the Compare Two Lists tool. The A ∩ B result shows every value that appears in both.

Can I compare Excel columns with different numbers of rows?

Yes. The tool matches by value, not by row position. A 200-row column and a 150-row column produce perfectly valid results.

What if my Excel data has duplicate values?

Duplicates within a column are counted as a single item. If 'Apple' appears three times in List A, it shows up once in the output. If you want to see which values are duplicated before comparing, run your list through Text Fixer with Remove Duplicates enabled.

How do I compare Excel columns and return a value from a third column?

That's the Column Compare tool. Paste your full datasets with headers, choose which column is the key on each side, and optionally pick a value column to see what changed. It works like VLOOKUP but in the browser.

Can I compare columns without worrying about uppercase and lowercase?

Open Options and uncheck Case Sensitive. Done.

How do I find rows that exist in one Excel sheet but not another?

Copy just the key column (ID, name, whatever identifies a row) from each sheet and paste into List A and List B. A Only shows what's unique to your first sheet. B Only shows what's unique to your second.

Does this work with Google Sheets?

Yes. Select the column, press Ctrl+C, paste into ListDiff. Google Sheets and Excel copy cells in the same format, so this tool works identically with both.

What's the difference between comparing two lists and using VLOOKUP?

VLOOKUP looks up a value and returns something from the same row in another table. Comparing lists tells you which values exist in each list and how they overlap. If you need to match rows and pull a value column, use the Column Compare tool for that.