Skip to content

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.

Choose files or drag and drop them into the upload field. Maximum file size: 5 MB.

Reset

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.

About OneClick Pro

OneClick Pro is a free collection of more than 150 web tools for everyday work: converting images and units, formatting and validating code, checking domains and SEO, and working with text, dates and numbers. Every tool runs without registration or subscription, and what you enter is only used to calculate your result and is never stored. Use it as a quick toolbox for one-off tasks, or bookmark the tools you rely on every day.