Skip to content
hateitall

Excel Hidden Data Inspector

See what a workbook is really carrying: hidden sheets, hidden rows and columns, names, links, and comments.

Processed locallyIn: XLSX, XLS, ODSOut: Inspection report (on screen), XLSX (unhidden copy)

Loading tool…

How to use excel hidden data inspector

  1. Select a workbook. The package is parsed locally and inventoried.

  2. Review the report: sheet visibility (including very-hidden), hidden rows/columns, defined names, hyperlinks, comments, and document properties.

  3. Preview any sheet's contents — including hidden ones — in inspection mode.

  4. 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.

Fresh values-only rebuild: no formulas, comments, links, hidden sheets, macros, or document properties.

XLSX · XLS · ODSXLSXModerate on device

Inspect core and custom document properties, strip identity fields, and verify the clean export.

XLSXXLSXLight on device

Convert each worksheet to CSV with delimiter choice and a ZIP for multi-sheet workbooks.

XLSX · XLS · ODSCSVModerate on device