Practical guide · Excel List Compare
Compare Excel lists by a confirmed key
Two versions of a list, different row orders: which values really changed? Compare records by an ID or a combination of fields that identifies them, rather than by row number. Then match the columns containing the values you want to check.
Open toolStep by step
Choose the two lists
Select the previous and current CSV or XLSX files; the included example uses different column orders.
Inspect the source sheets
Choose the intended sheet in each workbook and inspect both source previews. Review encoding and separator settings for CSV.
Match columns and choose the key
Map left columns to right columns. Select one or more key columns and the values to compare. Confirm any proposed mapping.
Review the differences
Review unchanged, changed, new, missing, duplicate and empty-key results separately.
Export the comparison
Create the XLSX report. It includes the comparison settings, source row references, old and new values, and both original value tables.
Reordered rows, a real value change
Before
Left row 3: 0013;DE;Mia;20
After
Right row 2: DE;0013;25;Mia
With only id confirmed as the key, the mapped amount columns identify 20 → 25. Region DE is compared as a value. The source row numbers remain in the exported report.
Open the tool for this exerciseUnderstand the details
Optional extension: use a composite key
The basic training exercise uses id alone as its key. If your task instead identifies records by ID and region together, select both as key columns in a separate comparison. Both parts must then agree. A blank key part is reported separately; it is not silently treated as a reliable identifier.
By default, 0012 and 12 are different strings. Ignoring letter case or outside whitespace is an explicit choice that affects both keys and compared values. It does not rewrite the source tables in the report.
Duplicates are not matched by guesswork
If the same key appears more than once on either side, it is unclear which records belong together. Those source rows stay marked as ambiguous. Matching the first left occurrence to the first right occurrence would look certain without being justified.
The sample contains two left rows and one right row with key 0014. Their region value is CH; region is a compared field, not part of the basic exercise's key. All three are reported as ambiguous source rows. The displayed count means three rows, not three matched pairs or three distinct duplicate groups.
Read the changed amount with its source
In the sample, ID 0013 in DE has amount 20 in left source row 3 and 25 in right source row 2. Reordered columns are mapped from left column 4 to right column 3. ID 0012, whose region is CH, is unchanged despite its different row position.
The verified sample has one changed, one unchanged, one new and one missing record, plus the three ambiguous source rows. A report filter changes what you view; inspect the complete exported workbook before acting on the differences.
Use the same exercise in a class or handover
The synthetic workflow training ZIP linked below includes both example lists and their expected results. For the basic exercise, keep the header enabled, leave whitespace trimming and case folding off, and confirm only id as the key. Map id, region, name and amount to their matching right-hand columns and leave all four selected for value comparison.
Expect ID 0013 to change from 20 to 25, 0012 to stay unchanged, 0016 to be new and 0015 to be missing. The three source rows with key 0014 remain ambiguous. Their regions are ordinary source values; they do not define the key in this exercise. Keep the source row references in the report; do not resolve duplicates by position.
Workbook values and limits
Imported formulas are not evaluated. Saved display values may be stale; this tool cannot know whether the source workbook was recalculated. The report stores explicit text cells and does not preserve macros, charts or workbook formatting.
Each input is limited to 5 MiB. Both selected sheets together may contain at most 10,000 rows and 100,000 cells, with 256 columns per sheet. The expanded report also has limits; a large comparison may need smaller inputs. Processing is local in a cancellable worker, and exported cell values are reopened for verification.