Skip to content
SheetCompare is in private beta.Join the beta →
SheetCompare
Menu
← All use cases

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.

StatusKeyWhat changedOld valueNew value
changedORD-5531StatusPendingShipped
addedORD-5602New row—Paid · 89.00
removedORD-5420Row is goneCancelled · 0.00—
Example rows with sample data

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.