XLSX formula inventory
List ordinary formulas across workbook sheets with cell addresses, visibility and raw cached values, without recalculating.
- 1Add input
- 2Adjust settings
- 3Get your result
Tool input and files are processed in this browser without being uploaded.
Before you start
Audit a workbook before sharing or moving its formulas. Read every supported worksheet locally, including hidden sheets, then download a searchable inventory.
How to use this tool
- Open a local .xlsx workbook, or keep the example checkbox enabled to inspect the provided demo.
- Run the inventory and check sheet names, hidden status, formula addresses and cache types. A workbook with no formulas returns an empty valid list.
- Download JSON for exact formulas or CSV for a review sheet. Recalculate only in the spreadsheet application if fresh results are needed.
Supported inputs and limits
One unencrypted ordinary .xlsx file up to 5 MiB. At most 2,000 ZIP entries, 25 MiB expanded bytes, 100× compression ratio, 100 worksheets and 10,000 formula cells. A selected file always takes precedence over the example.
Supports UTF-8 transitional OOXML worksheet parts and ordinary cell formulas. Shared, array and data-table formulas, formula metadata, macro workbooks, chart-sheet relations and unsupported package forms reject the entire workbook before output.
Formulas are not executed or recalculated. Cached values are raw OOXML lexical text with its cell type; they may be stale, absent or empty. A shared-string cache remains its numeric index. Missing-cache count means no <v> element; an empty <v/> is reported as an empty lexical value. No linked files or URLs are fetched.
Enable the example checkbox to run the built-in two-formula workbook without a file and download formula-demo.xlsx for inspection. JSON preserves exact formula strings. CSV prefixes formulas for spreadsheet safety; preview shows up to 200 cells, downloads include the full list.
Worked example
Example input
Built-in formula-demo.xlsx (useExample=true)
Example options
{"params": {"useExample": true}}Example output
{
"demonstration": true,
"calculation": "not executed",
"cachedValues": "raw OOXML lexical values, possibly missing or stale; shared-string caches remain indices",
"sheets": [
{
"name": "Demo",
"state": "visible",
"formulaCells": 2
}
],
"formulas": [
{
"sheet": "Demo",
"state": "visible",
"cell": "A1",
"formula": "=SUM(1,2)",
"cachedType": "n",
"cachedLexical": "3"
},
{
"sheet": "Demo",
"state": "visible",
"cell": "B1",
"formula": "=IF(A1>0,\"yes\",\"no\")",
"cachedType": "str",
"cachedLexical": null
}
]
}When something does not work
Use an ordinary unencrypted .xlsx with only supported formula kinds, or inspect unsupported formulas in the spreadsheet application. To run without a file, enable the example checkbox. Remove a selected file before switching to the demo.
Frequently asked questions
Does it recalculate Excel formulas?
No. It reads stored formula expressions and caches. A present cache does not prove that it is current.
Why reject a shared or array formula?
Those formats require additional formula expansion semantics. This version rejects the whole workbook rather than claim an incomplete inventory is complete.
Are hidden worksheets included?
Yes. Their hidden or veryHidden state is included in the inventory. No sheet is made visible or edited.