Hidden worksheet and row/column inventory
Inventory declared hidden/veryHidden worksheets and explicitly hidden row/column ranges in a local XLSX without modifying it.
- 1Add input
- 2Review and run
- 3Get your result
Tool input and files are processed in this browser without being uploaded.
Before you start
Read actual workbook relationships and worksheet XML, then download complete names, IDs, part paths and1-based ranges. Missing state means visible; collapsed or zero size is not guessed to mean hidden. This version atomically rejects default zeroHeight=true rows and any overlapping column declarations.
How to use this tool
- Select a local XLSX.
- Review hidden worksheets and compressed row/column ranges.
- Download full JSON/CSV; the original stays unchanged.
Supported inputs and limits
One30MiB XLSX; ZIP80MiB expanded/10,000 entries/ratio200; XML20MiB total/1m nodes,200k nodes each/depth128. At most1,000 worksheets,100k declared rows and100k column definitions; complete reports10MiB.
Ordinary unsigned/nonmacro/unencrypted XLSX with transitional OOXML. Reject external/escaping/missing/duplicate worksheet targets, duplicate names/IDs, bad booleans and bounds. No formula execution,decryption,password changes or claim to find all sensitive content.
Worked example
Example input
Three sheets: =Public,Hidden,Internal; hidden rows7–8/12 and columnsB–D/G.
Example options
{}Example output
One hidden,one veryHidden,3 hidden rows,4 hidden columns; collapsed-only is not hidden.
When something does not work
Resolve default zeroHeight/overlapping columns in a full spreadsheet editor, then rerun. Failure and cancellation produce no misleading inventory.
Frequently asked questions
Does the inventory certify a private-data-free workbook?
No. Cells,formulas,media,comments and other objects may contain information. This tool inventories declared visibility only.