Compare two versions of an Excel list — see what was added, removed or changed
Pick the old file and the new one. Kita lists every new row, every removed row, and every value that changed — old and new side by side.
Last month's customer list vs. this month's. Yesterday's price list vs. today's. Usually that means a VLOOKUP, a column of #N/A errors, and a second VLOOKUP the other way to catch what disappeared — and you still can't see which values changed. Kita answers all three questions at once.
or download the installer directly
No subscription. The files your tools process stay on your computer.
How it works
-
Get Kita and the tool
Free download, one-click install from the store.
-
Pick the old file and the new file
Kita finds the ID column for you, or you choose it.
-
Run
Get one result file with three sheets: Added, Removed and Changed.
What it handles
- .xlsx, .xls and .csv — the two files can even be different formats
- Finds the key column automatically (a unique, ID-like column in both files), or uses the one you pick
- Matches keys ignoring capitalisation and extra spaces at the ends
- Columns matched by header name, so a different column order doesn't matter
- The Changed sheet shows the old and new value of each column that differs
- Title rows and total rows are skipped; your original files are never changed
Why not VLOOKUP?
VLOOKUP only looks one way, breaks on extra spaces, and tells you nothing about which values changed. You'd need two lookups, a comparison column per field, and cleanup. Kita checks both directions and every shared column in one run.
Questions
Can I match on two columns at once (e.g. name + date)?
This version uses one key column. Describe what you need in Kita and it will build a two-column version for you.
What if the same ID appears twice in a file?
The first occurrence is used, and the duplicate IDs are listed in the result.
What if one file has extra columns?
Only columns in both files are compared; the others are listed so you know.
Does it keep my formatting?
No — the result is a plain data table with the original values.
Are my files uploaded?
No. Everything runs on your computer.
Related tools
-
Merge Excel files
Pick a folder of spreadsheets, click Run, and get one combined sheet. Columns line up by name, even when every file orders them differently.
Open tool → -
Split Excel by column
Choose a column like Region or Department, click Run, and get one sheet (or one file) per value, with your formatting intact.
Open tool →
Stop doing it by hand.
Get Kita, install this tool from the store, and run it on your own files.