Compare the same records across two snapshots
Paste CSV or TSV, or import CSV, TSV or XLSX. Include unique column headers in the first row. Select the key column separately for each side, then choose Compare records. Keys and cell values are matched exactly; other columns are paired by their trimmed header names.
Example: compare stock by SKU
SKU,Stock,Price 00123,20,9.50 410,2,12.00
Price,SKU,Stock 9.50,00123,17 8.00,550,4
Select key column 1 in A and column 2 in B. Stock for 00123 changes from 20 to 17, 410 is removed and 550 is added. The CSV includes field names, old and new values, and source rows.
Before importing a workbook
XLSX import reads the first visible worksheet and uses saved cell values. Formula results are read from the saved workbook. Date formats may appear as stored serial values. Blank or duplicate keys are reported with their source rows. Keep IDs stored as text if leading zeros matter.
To check membership without comparing other fields, use Compare Lists.