Data Reconciliation Report

Compare keys and exact control totals from pasted or uploaded tables, with a complete downloadable report.

On-device No sign-up Free to use

Reconcile tables controls

Showing an example. Edit to see your own.

Drop your table file here

or choose one from your device

Chosen file replaces pasted text; first visible XLSX sheet.

    Drop your table file here

    or choose one from your device

    Chosen file replaces pasted text; first visible XLSX sheet.

      ?

      Paste a CSV with a heading row. Up to 100,000 data rows, 500 columns and 2,000,000 cells.

      ?

      The second table. Each table keeps its own key column name, so the two headings do not have to match.

      ?

      The heading of the unique, nonblank key column in the left table.

      ?

      The heading of the unique, nonblank key column in the right table.

      ?

      Comma-separated headings in the left table. Leave both column boxes empty for a key-only report.

      ?

      Comma-separated headings in the right table. The two lists must name the same number of columns; the heading names may differ.

      ?

      Case-insensitive matching refuses two keys that fold to the same value instead of merging them.

      ?

      The same delimiter is used to read both tables.

      ?

      A report cell whose first visible character is = + - or @ receives an apostrophe in the download. Turn it off to keep the raw value.

      Processed in your browser. Your inputs stay on this device.

      Result

      Showing an example.

      Match A100 and B220, then compare totals of 30 and 51 for a difference of 21.

      Matched 2 of 3 left keys and 3 right keys; 1 key appears only in the left table and 1 only in the right. amount 30 in the left table, amountTotal 51 in the right table, difference 21. Saved reconciliation-report.csv.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/data-reconciliation-report · 20 November 2026

      Was this helpful?

      How to use Data Reconciliation Report

      1. Paste the two delimited tables or choose their CSV, TSV or XLSX files. A workbook uses its first visible worksheet.
      2. Name each side's unique, nonblank key column and choose case-sensitive or case-insensitive matching.
      3. Enter numeric headings independently on each side, in corresponding order, or leave both numeric lists empty for a key-only report.
      4. 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.

      You add
      Left table: sku,amount A100,10 B220,12 C340,8; Right table: sku,amountTotal A100,20 B220,25 D400,6; Left key column: sku; Right key column: sku; Key matching case: sensitive; Left columns to total: amount; Right columns to total: amountTotal; Protect spreadsheet formulas: true
      You get
      Matched 2 of 3 left keys and 3 right keys; 1 key appears only in the left table and 1 only in the right. amount 30 in the left table, amountTotal 51 in the right table, difference 21. Saved reconciliation-report.csv.

      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.

      Page updated · Project managed by Tony Hines · Report a problem with Data Reconciliation Report