← All use cases
Example rows with sample data
Compare this month's export with last month's
Orders, tickets, records: any export you pull regularly can be compared with the previous one.
How it works here
Paste each export into its own tab of the same spreadsheet. With the record or order ID as the key, the report shows new records, removed records and records whose fields changed, such as a status.
Good key column: Order ID or record ID.
| Status | Key | What changed | Old value | New value |
|---|---|---|---|---|
| changed | ORD-5531 | Status | Pending | Shipped |
| added | ORD-5602 | New row | — | Paid · 89.00 |
| removed | ORD-5420 | Row is gone | Cancelled · 0.00 | — |
Tips
- Check that both exports use the same header names, otherwise those columns are listed as not compared.
- Large exports are fine: it has been tested with up to 100,000 rows per tab.
Want to try it on sample data first? Download the sample files.