Match records by shared columns, then see each file’s values side by side.
Review changes, records in only one file, and duplicates. Download a report you can work from.
SKU001 · Red · East warehouse
| File / record | Stock | Unit price | Result |
|---|---|---|---|
| A_Reference.xlsx | 100 | 12.5 | Reference |
| B.xlsx | 120+20 | 13+0.5 | Changed |
| C.xlsx | 100 | 12.8+0.3 | Changed |
| D.xlsx | 100 | 12.5 | Same |
| E.xlsx | 100 | 12.5 | Same |
B changed both values. C changed only the price. D and E match the reference.
SKU002 · Blue · South warehouse
| File / record | Stock | Minimum order | Result |
|---|---|---|---|
| A_Reference.xlsx | 200 | 100 | Reference |
| B.xlsx | 200 | 100 | Same |
| C.xlsx | 180-20 | 120+20 | Changed |
See both changes for the same record, alongside the reference values.
A_Reference.xlsx and D.xlsx
| File / record | Stock | Unit price | Result |
|---|---|---|---|
| SKU003A_Reference.xlsx | 80 | 30 | Reference |
| SKU003D.xlsx | — | — | Only in reference |
| SKU005A_Reference.xlsx | — | — | No record |
| SKU005D.xlsx | 40 | 9 | Only in comparison |
SKU003 appears only in the reference. SKU005 appears only in D.
SKU002 · Blue · South warehouse
| File / record | Stock | Minimum order | Result |
|---|---|---|---|
| A_Reference.xlsx | 200 | 100 | Reference |
| E.xlsxSource row 3 | 200 | 100 | Needs review |
| E.xlsxSource row 4 | 210 | 100 | Needs review |
Both rows have the same matching values. Keep their source row numbers for review.
Choose 1–3 matching columns to identify the same product, invoice, or business record.
Compare 1–8 columns side by side. Changed values are highlighted; duplicate records need a separate review.
One Excel report includes the summary, comparison details, and issues, with source locations.
| Team / task | Files to compare | Matching columns | Columns to compare |
|---|---|---|---|
| Check billing line itemsAccounting and bookkeeping teams | Internal transaction registerandCustomer or supplier statement | Document ID + Line item ID | Quantity, Amount, Tax |
| Check order exportsEcommerce and sales teams | Marketplace order exportandInternal order records | Order ID + SKU | Quantity, Unit price, Amount, Order status |
| Compare inventory recordsWarehouse and inventory teams | System inventory exportandCount sheet for the same point in time | SKU + Specification + Warehouse | Stock quantity |
| Review an updated supplier quotePurchasing and supply chain teams | Current purchase price listandUpdated supplier quote | Item ID + Specification | Unit price, Lead time (days), Minimum order |
| Review payroll revisionsHR and payroll teams | Reviewed payroll for the monthandRevised payroll for the same month | Employee ID | Gross pay, Allowances, Hours worked |
| Verify an imported datasetImplementation and QA teams | Records prepared for importandSystem export after import | Record ID + Line item ID | Quantity, Amount, Status, and other business values |
Download sample files, follow the steps, and apply the same approach to your own records.
No. Comparison runs on your computer or phone. Refreshing or closing the page clears the current task. Download any report you need to keep first.
RowKite compares saved formula results and does not recalculate formulas. If required columns contain merged cells, first arrange your data as a table with headers in the first row.
Use up to 5 files: 10 MiB per file and 30 MiB total. Each sheet can have up to 10,000 rows and 50 columns, with 1 million populated cells across all files. Reports are limited to 100,000 rows. Speed depends on your device and file structure.