REVISION TO REVISION

Two reports.
A clearer view of change.

Match rows by key columns to see what changed, what arrived and what disappeared. Review the differences, then download a coloured result workbook.

Loading the local comparer… If this message remains, try a current desktop Chrome, Edge, Firefox, or Safari browser.

Choose your reports

Open or drag in the previous revision and the current one. Both stay on your computer.

OLD REPORTSelect or drop the old revisionXLSX, XLSM, XLS, CSV, TSV · up to 30 MBNo old report selected NEW REPORTSelect or drop the new revisionXLSX, XLSM, XLS, CSV, TSV · up to 30 MBNo new report selected

Or paste cells from Excel

Include the header row in both tables.

Old report

New report

Old worksheetNew worksheetHeader row

Select your two reports to begin.

Read locally. Nothing uploaded. Original files stay unchanged.

BEFORE YOU START

A little preparation.
A useful comparison.

Save both report revisions
Recalculate and save both workbooks. Choose the corresponding worksheets and check that their headers are on the selected row.
Choose what identifies a row
Use a unique tag or a combination of key columns. Map renamed key columns between reports. Use cell positions when both layouts are identical.
Review, then export
Check changed, added, removed and skipped rows. Download the result workbook for review, or export the differences as CSV.

Comparing recurring reports? Save your key mapping and ignored columns for the next revision in this browser.

JUST EXPLORING?

See changed, added, removed and skipped rows in two fictional equipment lists. No files required.

Download the sample ZIPIncludes both Excel reports and a short guide.

Match your rows

Pick the columns that identify a row, and the columns to leave out of the comparison.

Match rows by keysRecommended. Best when each row is a tagged, unique item. Compare cells by positionReports every changed, added, or blanked cell at the same address.

Key columns

Click the old-report headers that identify a row. Each one is mapped to a new-report column below.

Combined key delimiter

Ignored columns

Ignored columns stay in the output but are not compared. You can also edit the ; separated list.

Ignored column list

Formatting in the marked copy

When rows are matched by keys, the result workbook includes a marked copy of the new report. Choose how it looks. Cells show the displayed text; changed cells read old --> new.

Cell formatting

PlainValues only, without the reports’ own colours and fonts. Changes are marked green and amber.Keep formatting from the old reportColours and fonts from the old report follow each row by its key, even if rows or columns have moved.Keep formatting from the new reportColours and fonts from the new report, cell by cell.

Mark changed cells with

Fill colourAmber fill, as on the RK Compare sheet.Border onlyAn amber border that keeps the original fill visible.

Available when formatting is kept from the old or new report.

Kept: fonts, fills, borders, alignment, column widths, row heights and merged cells. Not kept: conditional formatting, formulas, images and data validation. Only XLSX and XLSM files carry formatting that can be kept; XLS, CSV, TSV and pasted tables use Plain. Added rows and columns stay green.

Save or restore settings

Saved settings include the compare mode, header row, key mapping, delimiter, ignored columns, marked-copy formatting and the Excel table option. Report contents are never saved. Browser storage can be cleared by your browser.

Name

Saved settings

Compare the reports

The result is a new workbook. Both source files stay untouched.

Format results as Excel tablesEach result sheet gets filter buttons and a named table. Cell colours are unchanged.

No account. No file uploads.

Select your two reports to begin.

READY TO REVIEW

Your comparison is ready.

Download result workbook ↓Download differences (CSV)

Status	Key	Source	Row	Column	Header / reason	Old value	New value

The result workbook includes RK Compare, skipped rows and review notes when applicable, and a marked copy for key matching when output limits allow it.

Supported files, privacy, and common questions

What can I open?

Two report revisions in XLSX, XLSM, XLS, CSV or TSV format. You can also paste either table from Excel, including its header row. Compare one worksheet from each report at a time; choose the corresponding sheets and check the shared header-row setting.

The XLSX result preserves cell text. In key mode its marked copy can keep the fonts, fills, borders, alignment, column widths, row heights and merged cells of the old or new XLSX/XLSM report; see Formatting in the marked copy. In CSV downloads, values beginning with formula-like characters receive a leading apostrophe so spreadsheet readers treat them as text.

The tool compares saved, displayed cell values. It does not calculate formulas, execute macros or refresh external data. Recalculate and save both workbooks first.

What are the limits?

30 MB per report; up to 100,000 data rows and 256 columns per worksheet. Each pasted table is limited to roughly 5 million characters. Available browser memory also affects capacity.

The on-screen table holds up to 2,000 entries, with skipped rows first. Downloads list up to 200,000 differences, and the workbook lists up to 5,000 skipped rows. Totals still count all differences and skipped rows. A marked copy is omitted above 400,000 source cells or when a difference or skipped-row list is incomplete. Export limits and skipped rows are also documented in the workbook’s Review notes sheet.

Should I match by keys or by position?

Match rows by keys uses a unique tag or a combination of columns, so rows and columns can move between revisions. Map renamed key columns to their new names. Compare cells by position compares the same cell addresses; inserted rows or columns can make many later cells appear changed.

Does anything leave my computer?

This tool reads selected reports into browser memory. It has no file upload endpoint, external document processing or telemetry. The website still serves the application files normally. Downloaded workbooks and CSVs contain report data, so share them intentionally.

Are my files or settings saved?

Files and report rows are not saved to WordPress or browser storage. Only Save as stores a named configuration with the compare mode, header row, key mapping, delimiter, ignored columns, marked-copy formatting and the Excel table option on this device for this site.

Clear session clears the loaded reports and results from the tool. To remove saved settings, select the configuration under Save or restore settings and choose Delete. Downloaded files stay wherever you saved them.

Why were rows skipped, or values marked as changed?

In key mode, rows with blank or repeated keys are skipped; the first row with a repeated key is kept. Check the Skipped filter and the workbook’s Skipped rows sheet. Fill missing keys or add another key column to identify each row. Duplicate column headers must be renamed. Columns without headers are not compared in key mode; name them or compare by position.

Different displayed number or date formats can count as value changes. Check the worksheet, header row and formatting if too much looks changed. This tool compares cell values, not workbook styling or formula logic.

A difference is a review item, not automatically an error. Check skipped rows and any output-limit notices before relying on the comparison.

Two reports.A clearer view of change.

Choose your reports

Match your rows

Compare the reports

Your comparison is ready.

What can I open?

What are the limits?

Should I match by keys or by position?

Does anything leave my computer?

Are my files or settings saved?

Why were rows skipped, or values marked as changed?

Two reports.
A clearer view of change.