Tiny Online Tools logoTiny Online ToolssearchSearch tools…grid_viewAll Tools
Homechevron_rightDocument Toolschevron_rightExcel Formula ExtractorExcel Formula Extractor

Excel Formula Extractor

List every formula in an XLSX or XLS 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, XLTM — or a binary XLS from Excel 97–2003

Accepted: .xlsx,.xlsm,.xltx,.xltm,.xls,.xlt,.xlsb

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.

Email Attachment Extractor

Email Attachment Extractor

Pull every attachment out of EML, MBOX and Outlook MSG files at once and save them as a ZIP.

3D Asset Extractor

3D Asset Extractor

Extract every texture, mesh, material and animation from a GLB or GLTF file as a ZIP.

Color Contrast Checker

Color Contrast Checker

Check WCAG 2.1 color contrast ratios for accessibility.

IBAN Generator

IBAN Generator

Generate valid IBAN numbers for more than 30 countries with correct check digits (ISO 13616 mod-97).

Build Plate Arranger

Build Plate Arranger

Pack several models onto a print bed automatically, drag them where you want them, and export the arranged plate as one model.

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.