xlLens manual
XLSX and CSV audit reports
Export bounded comparison results with hashes, alignment evidence, and product version.
In short: Export bounded comparison results with hashes, alignment evidence, and product version.
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.
What the report records
Reports include source hashes, xlLens version, comparison rules, alignment evidence, change types, original addresses, and previous/current representations.
Safe output
XLSX export is streamed by the desktop main process. CSV cells are escaped against spreadsheet formula injection before writing.
Try xlLens