Spreadsheet Workbook Inspector & Repair Studio
Inspect internal ZIP packages, formula integrity, hidden sheets, external references, and document metadata completely client-side in your browser, generating verified clean and repair copies.
Drop your XLSX or XLSM workbook here
Audit OOXML internal structure, hidden sheets/rows, formula errors, broken references, external URLs, and privacy metadata entirely inside your browser.
About Spreadsheet Workbook Inspector & Repair Studio
When sharing spreadsheets across teams and organizations, hidden sheets, concealed rows, author metadata, cell comments, external URLs, and broken #REF! formulas often remain embedded unnoticed, risking accidental data exposure and miscalculations.
Solasu's Spreadsheet Workbook Inspector & Repair Studio is a client-side forensic and repair workspace designed to deconstruct, audit, and clean OpenXML (.xlsx and .xlsm) packages purely in your browser's local memory.
Operating under the strict principle of 'Audit before Modify', Solasu never mutates your original files on disk. It provides objective observations, verifiable evidence, and transparent scope tracking (Preserved, Modified, Removed), enabling you to safely export sanitized Clean Copies or repaired workbooks verified through in-memory roundtrip re-import.
100% Client-Side Architecture with Zero Persistent Storage
All ZIP decompression, XML parsing, formula audits, and package rebuilding take place entirely inside your browser using JavaScript and WebAssembly. No files are uploaded to servers, cloud converters, or external APIs.
Solasu uses zero persistent storage: no localStorage, sessionStorage, IndexedDB, cookies, or cache storage. When you close or refresh the browser tab, all workbook contents vanish immediately from RAM.
Deep Hidden Content, Comment, and External Link Auditing
Detects standard Hidden sheets as well as Very Hidden worksheets that cannot be unhidden via Excel's normal user interface context menu.
Audits hidden rows, hidden columns, embedded cell comments with author names, external hyperlinks, and external workbook relationships, compiling a comprehensive pre-sharing privacy checklist.
Formula Integrity, Pattern Deviations, and Hardcoded Values
Scans every worksheet cell for formula error tokens (#REF!, #DIV/0!, #VALUE!, #NAME?, #N/A, #NUM!, #NULL!) and identifies broken references pointing to missing or deleted sheets.
Compares formula consistency across rows within columns, objectively highlighting 'Hardcoded value candidates' (constant values placed amidst continuous formulas) and 'Formula pattern deviation candidates' without subjective guesswork.
Safe Clean Copy and Structural Repair Copies
Selectively strip identifying metadata, cell comments, external hyperlinks, or hidden sheets to generate a safe Clean Copy ready for public or client distribution.
Perform non-destructive repairs on broken named ranges pointing to #REF! and dangling package relationships. Every generated file is immediately re-imported and validated in memory before download.
No Macro Execution Principle with XLSM Preservation
For macro-enabled (.xlsm) workbooks, Solasu identifies the presence of the VBA binary container (vbaProject.bin) and verifies its preservation status, but guarantees zero script execution.
Macros are never evaluated or run, eliminating script-based attack vectors while allowing safe inspection and preservation of genuine macro files.
FAQ
1. What is an XLSX file?
XLSX is the default spreadsheet file format introduced in Microsoft Excel 2007 based on the Open Packaging Conventions (OOXML / ISO/IEC 29500). An XLSX file is essentially a ZIP archive containing XML documents, relationships, styles, and shared strings.
2. What is an XLSM file?
XLSM is a macro-enabled Excel workbook format. Unlike XLSX, which strictly forbids macro code, an XLSM workbook contains a binary VBA container (xl/vbaProject.bin) that stores Visual Basic for Applications scripts.
3. Are legacy .xls files supported?
Legacy binary BIFF8 files (.xls from Excel 97-2003) are not supported for client-side structural OOXML inspection. Solasu will honestly display 'Unsupported format'. Please convert your file to .xlsx or .xlsm before auditing.
4. Are my Excel files uploaded to any server or cloud?
No. Zero bytes are uploaded to external servers, cloud processing services, or remote conversion APIs. All extraction, XML parsing, and clean/repair generation happen purely in your browser's local memory.
5. Is any data stored in cookies, localStorage, or IndexedDB?
No. Solasu employs zero persistent storage. It never writes workbook data, cell values, formulas, filenames, or metadata to localStorage, IndexedDB, cookies, or cache storage. Data exists only in volatile browser RAM.
6. What is a Hidden Worksheet?
A hidden worksheet has its state set to 'hidden' in xl/workbook.xml. While invisible in standard tab bars, all of its formulas, cell values, and potential confidential records remain fully accessible in the underlying XML.
7. What is a Very Hidden Worksheet?
A Very Hidden sheet has state='veryHidden' in the workbook XML. It does not appear in Excel's standard 'Unhide' dialog box and normally requires VBA script to reveal. Solasu detects and highlights it directly from package structures.
8. Can hidden rows and columns be detected?
Yes. Solasu scans worksheet XML definitions for hidden='1' and hidden='true' attributes on <row> and <col> tags, reporting counts and locations across all sheets.
9. How are formula errors (#REF!, #DIV/0!) detected?
Solasu parses all cell formula tags (<f>) and cached value tags (<v>) across worksheets, categorizing standard error tokens including #REF!, #DIV/0!, #VALUE!, #NAME?, #N/A!, #NUM!, and #NULL!.
10. What is a broken formula reference?
A broken reference occurs when a formula points to deleted cells (#REF!) or references a worksheet that no longer exists in the workbook (e.g. ='DeletedSheet'!A1).
11. What is a Named Range inspection?
Solasu catalogs defined names from xl/workbook.xml, analyzing their scope (workbook-wide or sheet-specific) and referring formulas, flagging broken named ranges that resolve to #REF!.
12. What are external links and external workbooks?
External links represent relationships connecting the workbook to external Excel files, remote URLs, or OLE data sources. Solasu lists them statically without contacting remote servers.
13. What is the 'No External Refresh' guarantee?
Solasu never initiates network requests to external links, connections, or hyperlink URLs discovered inside a workbook. External queries and database connections are strictly catalogued, never executed.
14. Where are cell comments and notes stored?
Comments are stored in separate package parts such as xl/comments*.xml along with author identifiers. Solasu indexes all comments so you can review drafting notes before sharing.
15. What metadata is stored in document properties?
Core document properties (docProps/core.xml) store author names, last modified by, creation and modification timestamps, and titles. Solasu flags these as potentially identifying metadata.
16. What is the 'No Macro Execution' policy?
Solasu never executes VBA macro code in the browser. It inspects the presence of xl/vbaProject.bin for preservation and security audit purposes while completely preventing script execution.
17. What are the formula calculation limitations?
Solasu inspects formula syntax and reference structures independently; it does not replicate Microsoft Excel's complete calculation engine. Stored cached values (<v>) are displayed as recorded by Excel.
18. What is a Hardcoded Value Candidate?
A hardcoded value candidate is a constant numeric cell positioned inside a sequence of continuous formulas within the same column, suggesting a potential formula gap or manual override.
19. What is a Formula Pattern Deviation Candidate?
When neighboring rows in a column follow an established calculation pattern (e.g. multiplying by 10) but a specific row uses a different formula structure, Solasu flags it as a pattern deviation candidate for verification.
20. What is a Clean Copy?
A Clean Copy is a newly generated workbook where user-selected sensitive components—such as author metadata, comments, external hyperlinks, or hidden sheets—have been safely removed while preserving untouched cell data.
21. What is a Repair Copy?
A Repair Copy cleans broken relationship definitions that reference non-existent package parts, removes invalid #REF! named ranges, and normalizes sheet state attributes.
22. Why does the exported file SHA-256 hash differ from the original?
This is expected and normal. Applying clean or repair operations modifies internal XML structures, relationship tables, and re-compresses parts, resulting in a distinct cryptographic hash.