xlLens manual

Getting started

Choose two workbooks, select a comparison mode, and inspect your first result.

In short: Choose two workbooks, select a comparison mode, and inspect your first result.

ValuesCalculatedFormulasStructureNamesCommentsVBAConnectionsFormattingProtection
xlLens
Search changesDifferences 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 changesDifferences 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 changesDifferences 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.

1. Select the previous and current files

Use the native file picker for each side. xlLens reads only paths selected by the user and never uploads workbook contents.

  • Previous: the baseline workbook
  • Current: the workbook you want to review
  • Supported: XLSX, XLSM, XLS, XLSB, CSV, and TSV

2. Pick the mode

Smart is the default for most workbook reviews. Basic compares the same addresses strictly. Table matches reordered business rows by selected key columns.

3. Read the workspace

The result opens with changed source rows only. Original row numbers stay visible. Turn off Differences only when you need the unchanged context around a change.

Try xlLens

SUPPORT

Need help?

Report a bug

Found a bug? Include the following details in your email.

  • Device and OS version
  • xlLens app version
  • Description of the issue
  • Screenshot or sample file, if possible