Find the differences between two tables
Last month's list and this month's, the old price list and the new one: no more checking line by line.
Steps
- Drop the old file and the new one on "Compare two files" (swap them with the arrows if needed).
- An ID-like column is picked to match rows; choose another under "Match rows by" if you like.
- The counts of added, removed and changed rows appear, with the table in colour. Show only the changed rows to check them.
- Press "Save a colour-marked Excel report" for a comparison you can share as is.
Questions
- Can the columns be in a different order?
- Yes. Columns are matched by their names; new and missing columns are listed.
- What about spaces and letter case?
- Turn on the loose option to treat values that look the same as the same.
- Large files?
- Up to 50,000 rows free; larger tables with the Pass.
The CSV is never sent anywhere; everything runs in this browser.