Skip to main content
Free tool — no signup

Compare Two CSV Files Online

Drop two spreadsheets and see exactly what changed — added rows, removed rows, and modified cells, matched on any key column. Nothing uploaded. Works in your browser.

File A — baseline

Drop File A here

CSV or Excel

File B — updated version

Drop File B here

CSV or Excel

Who uses Two-File Reconciler?

Real teams solving real problems — see if your use case is here.

📊

RevOps Analyst

Sales Operations

Comparing last month's CRM export to this month's to understand which deals closed, which accounts churned, and which records were updated.

Drops both exports in, keys on account_id. In seconds: 14 new accounts, 3 removed (churned), 22 changed (stage updates). Exports the changed set for stakeholder reporting.

📒

Finance Manager

Accounting / Finance

Reconciling a vendor invoice CSV against the approved purchase order. Needs to find line items that don't match before approving payment.

Keys on PO line item number. Finds 3 rows in the invoice but not the PO, and 2 amount discrepancies in changed rows. Flags for AP review before payment runs.

🛒

E-commerce Ops

Retail

Comparing product catalog exports before and after a bulk edit to verify only the intended changes were applied.

Keys on SKU. Confirms 150 price updates were applied correctly, no unintended changes to other columns.

🏥

Data Analyst

Healthcare / Research

Comparing two versions of a patient registry export after a data migration to verify all records transferred intact.

Keys on patient_id. Zero rows in 'only in A' or 'only in B' — all records present. 4 changed rows: address corrections that were expected.

How to compare two CSV files for differences

1

Upload File A and File B

File A is your baseline (the older version). File B is the updated version. Both are read entirely in your browser — nothing is sent to any server.

2

Pick your match key

Select the column(s) that uniquely identify each row — an ID, email, or order number. The tool auto-suggests likely keys. You can select multiple columns for composite keys.

3

Review the four buckets and export

See rows only in A (removed), only in B (added), changed (same key, different values with cell-level highlighting), and unchanged. Export any bucket as CSV.

Why VLOOKUP isn't the right tool for spreadsheet comparison

Finding rows in one CSV but not another is a common task — comparing a vendor invoice to a purchase order, reconciling a bank export to a ledger, or verifying a data migration landed intact. Most people reach for VLOOKUP. It works for small files, but it only tells you whether a key exists in the other file — it won't highlight which fields changed, and it breaks when the two files have different column orders.

This tool does a proper keyed diff: it matches rows by the column you choose, compares every field, and gives you four clean buckets you can act on. Cell-level change highlighting shows exactly which fields changed in matched rows, so you don't have to compare columns manually.

Frequently asked questions

The tool performs a keyed join on your chosen columns. Rows where the key exists in both files are compared cell by cell to detect changes. Rows that appear in only one file are reported as added or removed.

Related free tools