How to use Data Reconciliation Report
- Paste the two delimited tables or choose their CSV, TSV or XLSX files. A workbook uses its first visible worksheet.
- Name each side's unique, nonblank key column and choose case-sensitive or case-insensitive matching.
- Enter numeric headings independently on each side, in corresponding order, or leave both numeric lists empty for a key-only report.
- Run the comparison and inspect shared, left-only and right-only key counts, plus each right-minus-left total difference. Download the report and investigate the source rows.
Example: Data Reconciliation Report
Match A100 and B220, then compare totals of 30 and 51 for a difference of 21.
Options
- Left table
- Paste a CSV with a heading row. Up to 100,000 data rows, 500 columns and 2,000,000 cells.
- Right table
- The second table. Each table keeps its own key column name, so the two headings do not have to match.
- Left key column
- The heading of the unique, nonblank key column in the left table.
- Right key column
- The heading of the unique, nonblank key column in the right table.
- Key matching case
- Case-insensitive matching refuses two keys that fold to the same value instead of merging them.
- Left columns to total
- Comma-separated headings in the left table. Leave both column boxes empty for a key-only report.
- Right columns to total
- Comma-separated headings in the right table. The two lists must name the same number of columns; the heading names may differ.
- Delimiter
- The same delimiter is used to read both tables.
- Protect spreadsheet formulas
- A report cell whose first visible character is = + - or @ receives an apostrophe in the download. Turn it off to keep the raw value.
Supported inputs and limits
- Each source supports up to 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells.
- A selected CSV/TSV or first-visible XLSX sheet replaces pasted text.
- Keys must be unique and nonblank under the chosen case policy.
- Numeric totals pair the explicitly listed columns; headings may differ.
- Matching keys do not prove equal row values.
More details
The report does not merge or correct records, and CSV formula protection may prefix exported text.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
A matching key does not mean every field matches
The report identifies shared, missing and unexpected keys and compares selected numeric totals. It does not assert equality of every nonnumeric field or merge the two datasets. Use the row evidence to investigate the specific differences you care about.
Totals can conceal offsetting differences
A total can match while individual records differ, or differ because a key exists on only one side. Read the key categories alongside the arithmetic. The total difference is right minus left; it is not a cause or an automatic correction instruction.
Questions about Data Reconciliation Report
Does a matching key prove the row values agree?
No. It proves only that the key exists on both sides. Use a row-comparison tool when you need field-level differences.
Can the numeric headings differ between tables?
Yes. Enter the numeric headings separately on the two sides, in the order you want them paired. Totals are calculated independently, and the difference is right minus left.
Can a number with currency signs be totaled?
Only the numeric form documented by the fields is accepted. Remove ambiguous separators or currency text before calculating a control total.