Guide

XLSX diff: values, formulas, formatting, and structure

Treat XLSX as a workbook package with semantics instead of flattening it into plain text.

In short: Treat XLSX as a workbook package with semantics instead of flattening it into plain text.

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.

XLSX is more than cell text

An XLSX package contains worksheets, formulas, styles, merged cells, defined names, protection, comments, connections, and relationships. A plain-text diff can expose XML noise while hiding the business meaning of a change.

Classify workbook changes

xlLens groups value, formula, formatting, structure, VBA, name, comment, protection, and connection differences. Previous and current addresses remain available for investigation.

Align structural edits

Use Smart mode to realign inserted or deleted rows and columns, or Basic mode for a strict same-address diff. Table mode is intended for record-shaped data with stable keys.

Export a reviewable result

A bounded result view keeps large comparisons responsive, and XLSX or CSV reports record the source hashes, rules, alignment evidence, and detailed changes.

Next step

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