Tiny Online Tools logoTiny Online ToolssearchSearch tools…grid_viewAll Tools
Homechevron_rightDocument Toolschevron_rightXLSX Formula ExtractorXLSX Formula Extractor

XLSX Formula Extractor

List every formula in a workbook by sheet and cell, including shared formulas and the ones on hidden sheets.

upload_file

Click to browse or drag & drop files here

XLSX, XLSM, XLTX or XLTM

Accepted: .xlsx,.xlsm,.xltx,.xltm

Similar Tools

PDF Table Extractor

PDF Table Extractor

Find the tables inside a PDF and export them to CSV or XLSX, with the detection method and confidence shown for every table.

PDF Link Extractor

PDF Link Extractor

List every link in a PDF — external, internal, mailto, and the bare URLs in the text that carry no annotation — with pages, anchor text and risk flags.

CHM Extractor

CHM Extractor

Unpack a compiled HTML Help file into its pages, stylesheets and images, as a ZIP that keeps the original folder structure.

MHTML Extractor

MHTML Extractor

Take an MHT archive apart into HTML, images, stylesheets and assets, and download it as a folder that still opens in a browser.

Merge PDF

Merge PDF

Merge multiple PDF files into one document quickly and securely in your browser.

CSS Minifier

CSS Minifier

Minify CSS by removing whitespace, comments, and redundant rules.

Mesh to Point Cloud

Mesh to Point Cloud

Sample the surface of a 3D model into a point cloud in your browser and export PLY or XYZ.

apps

More Tools

Browse our full collection of free online tools.

Every formula, including the ones you cannot see

Excel shows you one sheet at a time and hides whatever the workbook's author hid. This tool reads the file directly and lists every formula in it: sheet name, cell reference, the formula text, and the value Excel last calculated and cached.

Hidden sheets are included and marked. veryHidden sheets — the ones that do not even appear in Excel's Unhide dialog, because they can only be revealed from the VBA editor — are included too. If something is calculating and you cannot find where, this is usually where it is.

Shared formulas, resolved

This is where most formula listings go wrong. When you fill a formula down a column, Excel does not store it a hundred times. It stores it once, in a master cell, and every other cell in the group gets <f t="shared" si="0"/> — with no formula text at all.

A tool that just reads the element text leaves ninety-nine of those cells blank. Here the master's formula is translated to each follower's position: relative references shift by the row and column offset, references anchored with $ do not move, and a reference pushed off the edge of the sheet becomes #REF!, exactly as Excel would show it. The translation tokenises the formula first, so a string literal, a quoted sheet name or a function name that ends in digits is never mistaken for a cell reference.

Array formulas and what-if data tables are labelled as such.

What gets flagged

  • Cross-sheet references — formulas that reach into another tab.
  • External workbook links — [1]Sheet1!A1 style references that point at another file and break the moment it moves or is renamed. The linked paths are listed.
  • Cached errors — #REF!, #DIV/0!, #N/A, #VALUE!, #NAME?, #NUM!, #SPILL! and the rest, exactly as they were last calculated.
  • Defined names, both workbook-wide and sheet-local, with what each one refers to.

There is also a tally of which functions the workbook uses and how often — click one to filter the list down to it.

Export

CSV, JSON, or an XLSX with the formulas, the function tally and the defined names on separate sheets.

Privacy

The workbook is read in your browser and never uploaded.