How to Compare Two Excel Files and Find What Changed
A practical way to compare monthly, versioned or before-and-after Excel files so you can identify added records, removed records and changed values without checking rows manually.
How to do it
Choose comparable datasets
Use two files that represent the same type of data, such as August versus September sales or a source file before and after an update.
Identify a stable key
Use a field such as Order ID, VIN, Customer ID or Product Code to match the same record across both files whenever possible.
Align field names and formats
Make sure equivalent columns use compatible names and data formats so differences represent real changes rather than formatting noise.
Separate added, removed and changed records
Do not collapse every difference into one count. Distinguish new records, records that disappeared and matched records whose field values changed.
Summarise change by category
Group differences by region, product, status or another business dimension to understand where the movement is concentrated.
Review the underlying records
Export or inspect the exact records behind each change before acting on the summary.
Why row-by-row comparison is risky
Manual comparison becomes unreliable as files grow. Sorting differences, inserted rows and small field changes can make two spreadsheets look different even when most records are unchanged.
A key-based comparison is more robust because it matches the same business entity across both files first, then evaluates what changed.
Choose the right comparison key
The strongest key uniquely identifies a record and remains stable between versions. Order numbers, serial numbers, account IDs and product codes are common examples. Names and descriptions are weaker keys because spelling and formatting can change.
- Unique in each file
- Stable over time
- Present in both versions
- Not generated from row position
Summaries are useful, but evidence matters
A result such as 42 changed records is only the starting point. You still need to know which fields changed and whether the changes are concentrated in one category or process.
Keep the record-level output available so the summary can be validated and shared with the people responsible for the source data.
Comparing two monthly product files
A simple key-based comparison can classify the movement clearly.
| Product ID | August | September | Result |
|---|---|---|---|
| P-101 | $120 | $120 | Unchanged |
| P-102 | $95 | $99 | Changed |
| P-103 | $80 | — | Removed |
| P-104 | — | $110 | Added |
What this tells you: Instead of saying the files are different, the comparison tells you exactly what happened: one price changed, one product disappeared and one product was added.
Common questions
What is the best way to compare two Excel files?
Use a stable record key to match rows first, then classify records as added, removed, unchanged or changed. This is more reliable than comparing row positions.
Can I compare monthly Excel reports?
Yes. Monthly files are a strong use case when both reports contain comparable fields and a stable identifier for matching records or categories.
What if the files have different column names?
Align or map equivalent fields before interpreting differences. Otherwise a naming change can be mistaken for a data change.
Use the guide with your own data.
Upload a CSV or Excel file to Azhan Data Studio and move from raw spreadsheet to evidence faster.