Runs locally in your browser
Paste two spreadsheet columns and find matching rows, values only in the first column, values only in the second, or the union.
About this tool
Column comparison is the spreadsheet-shaped version of list comparison. It is useful when reconciling IDs, emails, SKUs, account numbers, or exported keys.
Paste each column directly from Excel or Google Sheets; duplicates are removed before the selected membership result is produced.
FAQ
No. Omit headers unless you intentionally want them compared as values.
No. It compares value membership regardless of row position.
Related tools
Guides
Learn how to compare two lists in Excel with XLOOKUP, COUNTIF, and conditional formatting. Limitations explained plus when a browser-based tool works better.
Read guide →Compare two spreadsheet columns, identify missing values, handle duplicates and blanks, and validate the result safely in Excel or Google Sheets.
Read guide →Learn a workflow to reconcile customer, SKU, inventory, or account exports by ID. Covers normalization, duplicates, missing records, changes, and audit evidence.
Read guide →