BuyDownload

xlLens manual

Benchmark methodology

Explore xlLens performance across large workbooks with reproducible native-engine results.

In short: Explore xlLens performance across large workbooks with reproducible native-engine results.

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.

Published performance range

The benchmark drives the real xlLens app in Basic mode from the Compare button to the result screen and verifies injected value and formatting changes. Time and whole-app peak RSS are the median of three successful runs.

  • 1,000 rows × 12 columns · 0.07 MB per file · 0.14 seconds · 589 MB whole-app peak RSS
  • 10,000 rows × 30 columns · 1.71 MB per file · 0.52 seconds · 585 MB whole-app peak RSS
  • 100,000 rows × 30 columns · 17.48 MB per file · 4.26 seconds · 603 MB whole-app peak RSS
  • 500,000 rows × 30 columns · 88.84 MB per file · 20.81 seconds · 623 MB whole-app peak RSS

Fast by design

The native engine streams worksheet data, resolves workbook semantics without loading the entire grid into the interface, and returns bounded result pages for responsive review.

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