xlLens manual

Supported formats and limits

See what xlLens reads directly and which workbook features are not implemented yet.

In short: See what xlLens reads directly and which workbook features are not implemented yet.

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.

Supported

Basic and Smart comparisons stream XLSX and XLSM through the Rust engine. Table mode uses a bounded compatibility path for XLS and XLSB, plus streaming CSV and TSV reads with UTF-8 and CP949 decoding.

Advanced workflows included in xlLens

xlLens includes three-file comparison and conflict-aware merge, password-protected workbook comparison, interactive formula dependency and risk analysis with CSV/SVG export, folder batches with explicit duplicate and renamed-file pairing, CLI automation, Git/SVN/Perforce integration, and highlighted workbook export.

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