XLSX Inspector
See what is inside an Excel or OpenDocument workbook without opening it. The inspector lists every sheet with its visibility, used range, size, number of filled cells, formulas and merged ranges, plus the defined names, document properties and the formulas themselves with their cached values.
Frequently asked questions
Which files can I inspect?
XLSX, XLSM, XLSB, XLS and ODS workbooks up to 10 MB. Password protected workbooks cannot be read.
Does it show hidden sheets?
Yes. Every sheet is listed with its visibility: visible, hidden, or very hidden, which is the state that can only be changed from VBA and does not show up in Excel's Unhide dialog.
What is the used range?
The range of cells that the file records as in use, such as A1:F120. It can be larger than the area that holds values when cells were formatted or cleared, which is a common reason for files that are bigger than they look.
How are formulas listed?
Each formula is shown with its cell, the formula text and the cached value, which is the result Excel stored when the file was last saved. The list shows up to 200 formulas and the count covers all of them.
Does it run macros?
No. A workbook with a VBA project is reported as containing macros, but nothing in the file is run.
What are the limits?
Files up to 10 MB with at most 25 MB of uncompressed content and up to 100 sheets. Cells and formulas are counted in the first 50,000 rows of each sheet, and sheets with more rows are named in the report.