How to compare two spreadsheet exports by ID
Match two Excel or CSV exports by a stable ID, find changed, missing, and new records, and learn when formulas or a dedicated tool are enough.
Read the guidePractical guides · Plain Method
Guides for the work between the big jobs.
Start with a clear manual method, then see when a dedicated tool helps and where each approach stops.
A first set of practical reads
Choose a guide by the job.
How to compare sensitive spreadsheets without uploading them
A neutral checklist for comparing sensitive spreadsheets locally: verify processing, network, report storage, license, and your organization’s rules.
Read the guideReconcile two inventory exports by SKU before updating a record
Compare two dated stock exports by SKU, check changed and one-sided rows, and validate filters before changing inventory records.
Read the guideA practical way to track profit across Etsy orders
Build a consistent Etsy order-profit view from actual fees, shipping, ads, other direct costs, and COGS—without relying on a generic fee estimate.
Read the guide