Match rows by ID and find the differences
When two order exports are sorted differently, comparing row 2 with row 2 can pair unrelated orders. Match rows by Order ID, then compare Amount to see what changed for each order. This small example includes a changed amount and records found in only one file. All Amount values in both files are in USD. Use the same currency in your own files; RowKite does not convert currencies.
Download the sample files
These fictional records are safe to use for practice. Each file contains only the data shown in this tutorial.
What is in the sample files
Reference file
| Order ID | Amount | Order status |
|---|---|---|
| SO001 | 120 | Paid |
| SO002 | 80 | Paid |
| SO003 | 50 | Paid |
Comparison file
| Order ID | Amount | Order status |
|---|---|---|
| SO003 | 50 | Paid |
| SO001 | 125 | Paid |
| SO004 | 60 | Paid |
Follow these steps
Prepare two exports covering the same scope
Download the reference and comparison files below. Each has headers in the first row and text values for Order ID. For your own data, use the same reporting period and the same definition of Amount.
Choose the files and sheets
Open the comparison workspace. Add baseline.xlsx as the Reference file and target.xlsx under Files to compare. Select the Orders sheet in both files.
Match by Order ID and compare Amount
Under Match rows by, select Order ID. Under Columns to compare, select Amount. Identical headers map automatically. These amounts are numbers, so keep the default Raw values rule.
Review the results
Click Compare files. The default Differences and needs review filter shows SO001, SO002, and SO004. Select All records to see the unchanged SO003. Moving an order to a different row does not count as an amount change.
Download the full report
Click Download Excel report to keep the summary, all comparison details, and issues. The report includes the full result, regardless of the current filter or page.
Expected results
Match rows by: Order ID. Columns to compare: Amount.
| Record | Result | What changed |
|---|---|---|
| SO001 | Changed | Amount changed from 120 to 125. |
| SO002 | Only in reference file | This order appears in the reference file, but not in the comparison file. |
| SO003 | Same | Amount is still 50. Its new row position does not affect the result. |
| SO004 | Only in comparison file | This order appears in the comparison file, but not in the reference file. |
Before using your own files
- If an order has multiple line items, add a line item ID or SKU to the matching columns. Order ID alone cannot identify a unique row.
- In Raw values mode, text "001" differs from the number 1. RowKite cannot restore leading zeros or digits already lost in Excel.
- Use standard .xlsx tables. Formulas are read from their saved results; RowKite does not recalculate them.
Limits: 2–5 .xlsx files, 10 MiB per file, 30 MiB total, 10,000 rows and 50 columns per sheet, and 1 million populated cells across all files. Refreshing, closing the page, or leaving the workspace clears the current files.
Read the full guide and comparison rules · Learn how files and results are handled
Keep reading
Download sample files, follow the steps, and apply the same approach to your own records.