xlLens manual
Difference types and filters
Understand value, formula, format, structure, VBA, connection, name, comment, and protection changes.
In short: Understand value, formula, format, structure, VBA, connection, name, comment, and protection changes.
ValuesCalculatedFormulasStructureNamesCommentsVBAConnectionsFormattingProtection
xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
PreviousBudget-2025.xlsx
ABCD
4Revenue475,000,000118.8%OK
5Operating profit118.8%=C5*1.08OK
6New customers531,360,000120.8%OK
7Repeat sales73.8=E7*1.0892.5
CurrentBudget-2026.xlsx
ABCD
4Revenue482,000,000118.8%OK
5Operating profit120.5%=C5*1.10OK
6New customers541,200,000120.8%OK
7Repeat sales73.75=E7*1.1092.50
Sheet 1 19Change detailsVBA 1
RevenueB4475,000,000482,000,000
10 change types in one workspace
Review multiple semantic changes side by side while preserving the visual structure of the desktop product.
xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
✓ Matched by key: 4 + Inserted row: 1
PreviousORD-101#101ORD-102#102ORD-103#103ORD-104#104
CurrentORD-101#101ORD-NEWInserted rowORD-102#102ORD-103#103ORD-104#104
Smart alignment
See inserted and removed rows realigned without a cascade of false changes.
xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
Key column✓ SKUIDEmail
PreviousA-100Desk$180B-200Chair$80C-300Lamp$45
CurrentC-300Lamp$45B-200Chair$92A-100Desk$180
✓ B-200 · Matched by key · row 2 → 2
Key-based Table mode
Match reordered business records by SKU, ID, email, or another selected key.
Cell semantics
Input values, calculated values, formulas, and number formats are classified independently so the result explains why a cell changed.
- Value and calculated value
- Formula and array formula range
- Font, fill, border, alignment, and number format
Workbook semantics
Sheet order and visibility, rows, columns, merged cells, names, protection, notes, VBA source, and connection package metadata appear as dedicated change types.
Try xlLens