Size and bloat
Find the parts, ranges, caches, and rules that make a workbook heavy.
Client-side file inspector
ExcelAnalyzer audits, analyzes, and inspects an Excel workbook in your browser. It reads .xlsx and .xlsm locally, with a partial reading for .xlsb, and shows clear stats plus advice that can improve performance. It does not edit, convert, repair, or upload the file. Legacy .xls is refused.
Find the parts, ranges, caches, and rules that make a workbook heavy.
See volatile functions, cached errors, names, and formatting that slow calculation.
Inventory macros, hidden sheets, and links to other files before you trust a workbook.
Check whether the ZIP package and its XML parts are complete and well formed.
The audit score starts at 100 and subtracts capped deductions for file efficiency, calculation speed, structural integrity, and security hygiene. Every deduction names its reason. The score is a reading of the package, not a promise that a workbook is safe to open.
See which sheets, images, pivot caches, and styles make a workbook large.
Compare each sheet’s declared used range with the last cell that holds a value.
Measure pivot cache records, saveData, and refreshOnLoad without opening Excel.
Count conditional formatting rules and fragmented ranges that bloat styles.
Count NOW, TODAY, RAND, OFFSET, INDIRECT, and whole-column refs.
List cached #REF!, #VALUE!, and #N/A cells with sheet addresses.
List workbook links and the formulas that still use them.
Review hidden, broken, external, and unused defined names.
See whether a workbook contains VBA, which modules it lists, and auto-start names.
List visible, hidden, and very hidden sheets from the workbook part.
Test ZIP integrity, missing parts, and XML well-formedness.
.xlsx and .xlsm are read fully: size, used range, pivots, formatting, formulas, names, links, sheets, macros, and package integrity. .xlsb reports size, sheet names, visibility, and whether a VBA project is present. .xls from Excel 97–2003 is not a ZIP package, so it is turned away instead of being misread as corruption.