Product plus currency identifies a price
Before / after: use custom keys SKU, Currency in the CSV tool. SKU alone is ambiguous. The composite key yields one changed price and two matches. 001, 01 and 1 are different identifiers.
Reconcile Two Spreadsheets Online
Reconcile two spreadsheets in your browser by a shared key. Review additions, removals, changed values, and ambiguous keys; XLSX reconciliation reads only the first worksheet. Everything runs locally, with no account required.
XLSX · CSV
XLSX ≤ 30 MB compressed · expanded ≤ 150 MB · 100,000 rows × 1,000 columns · CSV/TSV ≤ 50 MB
Choose record identity before comparing values
For a synthetic inventory, keep SKU 00123 distinct from 123 unless the source system says otherwise. Choose the key, inspect duplicate and empty identifiers, then review added, removed and changed records. Row order alone is not record identity.
RFC 4180 describes CSV record and quoting conventions, including quoted fields containing commas or line breaks. It is informational and does not define your SKU’s business meaning. Export identifiers deliberately before reconciling.
Need a positional review instead? Use CSV comparison or Excel comparison. The worked examples below use synthetic files and keep duplicate-key exceptions visible.
Synthetic warehouse and shop sample
Expected result: 4 matched, 16 changed, 2 added, 2 removed, 1 duplicate group, and 1 blank-key group held for review.
Duplicate and blank keys are held for review. Row order does not establish identity. Negative stock is reported as data, not adjudicated. XLSX reconciliation reads only the first worksheet.
Spreadsheet Reconciliation
Reconcile two spreadsheets in your browser by a shared key. Review additions, removals, changed values, and ambiguous keys; XLSX reconciliation reads only the first worksheet.
Original file
Drop an .xlsx, .csv, or .tsv file here
Updated file
Drop an .xlsx, .csv, or .tsv file here
Content is processed in your browser · Not sent to the application server · Free to use
Synthetic worked examples · 22 October 2026
Reconcile a warehouse and shop by SKU
Use the synthetic sample action above the workbench, then click Compare. To load files yourself, download warehouse.csv and shop.csv, select SKU as the key, and keep tolerance at 0. Row order differs intentionally. Preserve SKU codes such as 0001 as text.
The expected result is 16 changed, 2 added, 2 removed and 4 matched records. A repeated DUP key and a blank key are held for review, rather than paired by row order. Download the expected counts and rules. Negative stock is a reported value; ExactDiff cannot decide which source is correct.
- Load the synthetic sample above the workbench, or download both CSV files and open reconciliation.
- For manually selected files, choose the custom key SKU and leave numeric tolerance at zero.
- Compare the twenty stock differences and review the duplicate and blank-key groups separately. Download the report and keep both source files unchanged.
Equal totals can hide different records
Both before and after total 30, but A is duplicated. Reconciliation reports one withheld group, with no claimed matches. A full-row duplicate check is a different question from key uniqueness.
A formula becomes a stored value
Formula workbook / value workbook: Sheet!B2 changes from 1+1 to a stored 2. Formula diff reports the removed expression; data comparison sees the same cached value. Neither tool recalculates or approves the formula.
A European CSV is still text
Semicolon fixture includes a quoted semicolon, escaped quotation marks, a newline inside a field, Unicode and decimal commas. The parser keeps 10,50 as text. No date, currency or locale conversion is implied.
Three sheets, different coverage
Before workbook / after workbook: Inventory is unchanged; Prices and Archive values change, and Archive is renamed. Data reconciliation compares only the first worksheet, Inventory, and warns that the workbook has three sheets. Formula diff and structural audit scan all sheets for their respective tasks; neither is a full workbook value diff. Coverage and expected outcomes.
How Spreadsheet Reconciliation works
Reconciliation reads the first worksheet of each XLSX file, combines unique-key matching, duplicate detection, configurable normalization, file hashes, and a downloadable exception report. Incomplete or duplicate key groups are not paired.
The comparison is deterministic: the same files and settings produce the same classification. File contents remain inside the current browser session.
Get a cleaner result
- 01Reconcile counts before values.
- 02Document every tolerance used.
- 03Export the report with both source hashes for evidence.
Frequently asked questions
What is different from a normal spreadsheet diff?
Reconciliation emphasizes keys, tolerances, duplicate control, and auditable exceptions rather than cell position.
Can I ignore small numeric differences?
Yes. Set an absolute tolerance before running the comparison.