Compare Two Excel Columns Online

Paste or upload two columns to instantly find matches, differences, common and unique values.

100% private. Your data is compared right here in your browser and never leaves your device.

Compare Columns

What does this tool do?

This tool compares two lists of values from Excel side by side and instantly shows you which values appear in both columns, which appear only in Column A, and which appear only in Column B. It runs entirely in your browser, so nothing is uploaded to a server.

How to use Compare Two Excel Columns - Free Online Tool

  1. Paste your first list into Column A (one value per line), or click "Try with sample data".
  2. Paste your second list into Column B.
  3. Choose whether to ignore letter case and extra spaces.
  4. Click "Compare Columns" to see matches, differences, and unique values.
  5. Copy any result list, or download the full comparison as an Excel file.

Example

Comparing two lists of employee IDs:

Before

Column A Column B
1001 1003
1002 1004
1003 1007

After

Common 1003
Only in A 1001, 1002
Only in B 1004, 1007

1003 appears in both lists; the rest are unique to their column.

Excel formula alternative

Prefer a formula? You can achieve a similar result with COUNTIF:

=IF(COUNTIF(B:B, A2) > 0, "In both", "Only in A")

Drag down column A to flag which values also exist in column B. This tool does the same for both columns at once, without formulas.

When should I use this tool?

Reconciling two customer or CRM exports
Finding employees present in one list but not another
Matching invoice numbers between two reports
Comparing this month vs last month data
Spotting missing SKUs between inventory files
Checking email lists for overlap

Frequently Asked Questions

No. The comparison happens entirely inside your browser using JavaScript. Your values never leave your device.

Yes. Both options are on by default, so " John " and "john" are treated as the same value. You can turn either option off.

Because it runs in your browser, you can comfortably compare tens of thousands of rows. Very large lists depend on your device memory.

Yes. Click "Download Excel report" to get an XLSX file with three columns: common values, values only in A, and values only in B.

Related tools

Remove Duplicates
Trim, Clean & Convert Case
Compare Excel Files
Remove Blank Rows/Columns
Excel Formula Generator

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator