Excel Formula Syntax & Error Auditor

Xlsx Formula Auditor · Client runtimeSandboxed

Xlsx Formula Auditor Input

Xlsx Formula Auditor Output

Formatted results will render here in real time.

Xlsx Formula Auditor: JavaScript is required to run this tool in the browser.

About this excel formula syntax & error auditor

Lists formulas, numeric constants, VLOOKUP / SUMIFS / INDEX-MATCH usage, formula error tokens and stored error cells. Shows static A1 dependencies across sheets and detected circular groups. Function classification is an inventory, not a financial correctness score Parses and structures office document payloads locally in memory without transmitting private company files to external servers.

Document parsing & data extraction pipeline

Inspects and extracts deep metadata from Microsoft Office OpenXML document containers (DOCX, PPTX, XLSX) in compliance with ECMA-376 and ISO/IEC 29500 standards. Decompresses ZIP packages in browser memory to parse XML DOM trees: Word comment parts (word/comments.xml, commentsExtended.xml), revision marks, PowerPoint master font themes (ppt/presentation.xml, ppt/theme/theme1.xml), and embedded media archives. Exports comment threads and font audits directly to structured Excel workbooks (XLSX).

Worked document extraction example

Scenario: Execute Excel Formula Syntax & Error Auditor with sample data to verify transformation accuracy and output formatting.

Sample input:

Download /examples/xlsx-inspection.xlsx: Calc and Internal; Calc row 3 and Internal are hidden. Calc!B2 =A2*2, C2 stores #REF!.

Processing: Values come from stored cells and cached formula results; missing caches remain empty. Numbers are not converted through floating point. Date serials or stored date text remain unchanged. Formatting, macros and charts are not exported; formulas are not recalculated. Only lexical delimiters and error tokens are checked, not complete Excel grammar. External, 3D, structured, defined-name, dynamic, spill, array and data-table references may be unresolved. Partial coverage means other cycles may exist; no detected cycle is not proof of a correct workbook.

Illustrative output:

{ "sheets": [ "Calc", "Internal" ], "formulaCells": 1, "formulas": [ { "sheet": "Calc", "cell": "B2", "formula": "=A2*2", "storedFormula": "A2*2", "formulaType": "normal", "functions": [], "categories": [], "constants": [ { "value": "2", "offset": 3 } ], "formulaErrors": [], "references": [ { "text": "A2", "sheet": "Calc", "range": "A2", "resolved": true } ], "warnings": [] } ], "errorCells": [ { "sheet": "Calc", "cell": "C2", "value": "#REF!" } ], "dependencyTree": [ { "sheet": "Calc", "cell": "B2", "dependsOn": [] } ], "circularReferences": [], "dependencyCoverage": "complete-for-static-a1-references", "recalculated": false, "syntaxCoverage": "lexical-delimiters-and-stored-errors-only" }

File size & structure constraints

XLSX only, nonempty and smaller than 50 MB (50,000,000 bytes); legacy XLS and encrypted packages are unsupported. Limits: 128 MiB selected XML total, 8 MiB each for workbook and relationships, 2,000,000 actual or CSV-expanded cells, 1,000 sheets, 100,000 ZIP entries, 128 MiB CSV output and 64 XML levels. Formula limits: 20,000 formulas, 1,000,000 dependency edges and 5,000,000 range comparisons. Processing stops after 30 seconds. Preview shows 50 records per page. JSON keys, formula text and diagnostic codes are stable technical identifiers; sheet names and values are original data. The complete JSON download includes all records, references and warnings.

Excel Formula Syntax & Error Auditor parses structured OpenXML and PDF data locally. Review exported tables or sheets against original files.

Zero-upload document security boundary

File buffers and document assets in Excel Formula Syntax & Error Auditor are processed in-memory via local browser APIs with zero file uploads to CZOA servers.

Document schemas & interchange standards

ECMA-376 Office Open XML specifications and ISO 32000 PDF reference standards:

Excel Formula Syntax & Error Auditor verification · Audit standards

How to use it

Choose a local XLSX
Process locally
Click the action button or observe immediate live calculations rendered by Excel Formula Syntax & Error Auditor.

Frequently asked questions

What does the Excel Formula Syntax & Error Auditor produce?+

Operational requirements for "What does the Excel Formula Syntax & Error Auditor produce?" are verified in local memory during execution of Excel Formula Syntax & Error Auditor.

How are values and formulas handled?+

Extracts formula expressions, cross-sheet references, external workbook links, and circular calculation dependencies without evaluating macros.

What limits and privacy rules apply?+

Formula parse trees are constructed locally in web workers up to 20,000 formulas and 1,000,000 dependency edges.

How should I interpret the report?+

Security isolation for "How should I interpret the report?" ensures zero transmission beyond your local workstation.