Fresh values-only rebuild: no formulas, comments, links, hidden sheets, macros, or document properties.
Excel Hidden Data Inspector
See what a workbook is really carrying: hidden sheets, hidden rows and columns, names, links, and comments.
Loading tool…
How to use excel hidden data inspector
Select a workbook. The package is parsed locally and inventoried.
Review the report: sheet visibility (including very-hidden), hidden rows/columns, defined names, hyperlinks, comments, and document properties.
Preview any sheet's contents — including hidden ones — in inspection mode.
Optionally export a copy with all sheets unhidden for full review in Excel.
What this tool does
- Detects hidden and very-hidden sheets (states Excel's UI can't show)
- Lists hidden rows and columns per sheet
- Lists defined names, hyperlink targets, and comment authors/text presence
- Read-only grid preview of any sheet without executing anything
- Export an everything-visible copy for review
How the result is verified
Inspection is read-only. When exporting an unhidden copy, the output is reparsed to confirm every sheet's visibility state is 'visible'.
Frequently asked questions
What is a 'very hidden' sheet?
Excel supports a visibility state called veryHidden that does not appear in the Unhide dialog — it can normally only be changed through the VBA editor. Workbooks are sometimes shared with confidential data sitting on very-hidden sheets. This tool reads the visibility flag directly from the file and shows you all of it.
Can this run the macros in my file?
No. The parser reads the workbook package as data. VBA projects are detected and reported as present, but nothing is ever executed.
Is my file uploaded to a server?
No. The file is opened with your browser's File API and processed by code running in your tab. You can confirm this yourself: open your browser's developer tools, watch the Network panel, and process a file — no request carries your file's bytes. See our How it works page for a step-by-step verification guide.
Related tools
Inspect core and custom document properties, strip identity fields, and verify the clean export.
Convert each worksheet to CSV with delimiter choice and a ZIP for multi-sheet workbooks.