Email support
Send us an email when you need direct assistance.
support@xllens.appxlLens manual
xlLens manual
Learn comparison modes, filters, reports, automation, supported formats, and large-workbook behavior.
Pro interface guide
From advanced comparison to merge and automation
These React-rendered panels follow the real xlLens information structure. Complete each workflow in the order shown.
BaseBase.xlsxOursOurs.xlsxTheirsTheirs.xlsx
2 conflictsResolve conflicts and save merge
xllens before.xlsx after.xlsx --mode smartBuild commands with Basic, Smart, or Table options
0 · 1 · 2Exit 0 identical · 1 different · 2 error
Git diff tool: xlLensInspect Git integration status
GitConfigure or remove in one step
Project: Month-end close24 file pairs
24 / 24Save consolidated report
=SUM(B4:B12)18 dependent cells3 risky changes
SVGSave CSV list and SVG graph
1Enter password2Decrypt and compare locally3Temporary files removed
- Open 3-way compare from the Pro menu, then select the base, ours, and theirs workbooks.
- Review only conflicting cells, choose a result for each conflict, and save a new merged workbook.
- For batch comparison, select two folders, choose filename or folder-location matching, review every pair, resolve duplicates or renamed files manually, and save the setup for reuse.
- Formula analysis traces references and downstream impact, then exports a risk list or SVG graph.
- Encrypted workbook passwords stay in the session and decrypted temporary files are removed after comparison.
- Choose files, folders, and comparison rules on the CLI screen to build a runnable command immediately. The VCS screen inspects the current Git setup and can configure or remove xlLens without editing configuration files by hand.
Getting started
Choose two workbooks, select a comparison mode, and inspect your first result.
Read guide →Smart, Basic, and Table modes
Choose alignment behavior that matches the workbook change you are reviewing.
Read guide →Difference types and filters
Understand value, formula, format, structure, VBA, connection, name, comment, and protection changes.
Read guide →XLSX and CSV audit reports
Export bounded comparison results with hashes, alignment evidence, and product version.
Read guide →CLI and folder batches
Automate deterministic JSON or CSV comparisons with documented exit codes.
Read guide →Large-workbook behavior
Learn how streaming indexes, bounded paging, and spill files keep the UI responsive.
Read guide →Benchmark methodology
Explore xlLens performance across large workbooks with reproducible native-engine results.
Read guide →Supported formats and limits
See what xlLens reads directly and which workbook features are not implemented yet.
Read guide →Frequently asked questions
Does xlLens upload my workbooks?
No. Parsing, comparison, search, paging, and report generation run locally on your computer.
Do I need Microsoft Excel?
No. xlLens reads supported spreadsheet formats directly and does not automate an installed copy of Excel.
What is the difference between the trial and xlLens?
The trial includes every feature for 3 days. Purchasing removes the time limit.
Is the license a subscription?
No. The purchased version does not expire. Updates and email support are included for 12 months; later major versions, new features, and support may be sold separately.
Can xlLens compare password-protected workbooks?
Yes. xlLens accepts the workbook password for the current session, compares the decrypted local copy, and removes temporary files after the workflow.
Does it merge workbooks?
Yes. xlLens provides 3-way comparison and conflict-aware merge into a new workbook. The base and source workbooks are never overwritten.
Which operating systems does xlLens support?
xlLens supports Windows and macOS.
Can xlLens handle large workbooks?
Yes. xlLens loads only the data windows you need and has been verified with workbooks up to 500,000 rows.
How does xlLens stay responsive with large files?
Parsing and comparison run outside the interface, while results are delivered in bounded pages for fast, smooth review.
Is xlLens affiliated with the products on the comparison pages?
No. Product names identify independent comparisons. Official sources, verification dates, and xlLens limitations are shown to keep the comparison checkable.