Compare two Excel or CSV files and see what changed
This week's export against last week's: who's new, who's gone, and which values changed. Klerio matches rows on a column like an ID or email, then lists every difference, with the ones that usually matter shown first.
How it works
- Choose the older file and the newer one (CSV or Excel).
- Klerio picks a column that identifies each row; change it if you like.
- See rows added, removed and changed, and every changed value with before and after.
- Download an Excel report of all the differences.
Why Klerio
- Ignore the noise: Treat 07700 900123 and +44 7700 900123, or jane and Jane, as the same; leave out columns like 'Last modified'.
- What matters first: Values wiped out, big jumps in numbers and missing columns are flagged at the top.
- Different column names: Headings are matched whatever their capitals.
- Nothing uploaded: Both files are compared in your browser.
Common questions
What if my files have no ID column?
Klerio compares whole rows instead: a changed row shows as one removed and one added.
Can I compare more than two files?
Compare works on two at a time. Klerio's lists keep each upload, so you can see what changed every time a client sends a new export.
Is it free?
Comparing is part of the Klerio app, which you can try free for 1 day.