How to compare CSV or Excel columns without uploading data
A repeatable reconciliation workflow for customer IDs, SKUs, emails, and any other one-dimensional field stored in two spreadsheet files.
6 min readBy Comparable List Editorial Team
Comparing spreadsheet columns is rarely about whether two files look identical. Usually the decision is more specific: which customers were added, which SKUs disappeared, or which IDs failed to make it into a second system. A column comparison works well when each value represents one record and row order is not important.
1. Choose the field that identifies a record
Select a stable identifier before you upload anything. Customer IDs are usually more reliable than display names; SKU codes are usually more reliable than product descriptions. Do not compare two columns that mean different things just because they happen to sit next to one another in a spreadsheet.
2. Upload both files and select one column from each
Use the CSV & Excel comparison tool to upload CSV, XLSX, or XLS files. It reads the files in the browser, shows the columns from the first sheet, and lets you select the field to compare on each side. Leave “First row has headers” enabled when the first row contains labels such as customer_id or email; turn it off when the file begins directly with data.
- Choose files produced by comparable dates and filters.
- Confirm both selected columns contain the same type of identifier.
- Keep an untouched source copy for audit and recovery.
3. Normalize only what is not meaningful
After selecting columns, decide whether case and outer whitespace should matter. Emails often need case-insensitive matching and trimming. API tokens and some codes do not. The tool removes blank values and treats repeated values as one member of a comparison set; that is correct for “which records are present?” but not for “how many times did this record occur?”
If a CSV has several values in one cell, use the main list tool’s comma and semicolon splitting option only when that is truly how the source encodes a list. Do not split ordinary address or description fields simply because they include punctuation.
4. Review the queues in the right order
Start with Common to confirm the expected overlap. Then review Only in A and Only in B: those are records present in one source but absent from the other after your chosen rules. Download a result as CSV, add a status column in your spreadsheet, and record why each exception exists. The combined Different result is useful when you only need one consolidated exception list.
Ready to check your data?
The tool runs locally in your browser. Review the result before you act on it, especially when a list contains customer, account, or operational data.
Open CSV & Excel compareRelated workflows
For duplicate cleanup, use the duplicate list guide. For JSON API responses instead of flat spreadsheet columns, read the JSON keys and values guide.