#083 · Formula & Cell Inspection Tool

List Unique Excel Formulas

Scan an Excel workbook for distinct formulas, count where each pattern appears, and export an audit-ready CSV formula inventory.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Select a compatible source file.
  2. Review the header or column setting and preview limit.
  3. Choose List formulas, inspect the bounded preview, and download the newly generated result.

What this tool does

Inspects formula cells across the workbook, groups exact formula text, counts occurrences, and lists representative cell addresses. It does not recalculate formulas.

Inspects formula cells across the workbook, groups exact formula text, counts occurrences, and lists representative cell addresses. It does not recalculate formulas.

Keep the original file until you have checked the downloaded result in your spreadsheet application.

Supported formats

Accepts XLSX, XLS, CSV, and TSV. Output fidelity depends on features supported by SheetJS CE.

FormatUse
XLSX / XLSWorkbook data input where applicable
CSV / TSV / XMLPlain structured-data input where applicable
OutputA newly generated XLSX or CSV file

Tips for better results

  • Keep a backup before processing.
  • Use a clear header row and consistent column types.
  • Review IDs, dates, formulas, and leading zeros in the preview.
  • For sensitive files, close the tab after downloading the result.

FAQ

Does the formula inventory recalculate workbook results?

No. It reads stored formula text and never claims to reproduce the Excel calculation engine.

Are identical formulas counted across worksheets?

Yes. Exact formula text is grouped across all sheets and up to five example cells are listed.

Why do similar copied formulas appear as separate entries?

Relative references change as formulas are copied, so their exact formula strings may differ.

Are formula results included in the CSV?

The report focuses on formula text, occurrence counts, and locations rather than cached results.

Can this inspect macro code?

No. VBA and macro modules are outside the scope of this browser formula inventory.

Processing summary

StageBehavior
ReadLocal browser memory
TransformInspects formula cells across the workbook, groups exact formula text, counts occurrences, and lists representative cell addresses. It does not recalculate formulas.
ExportNew downloadable file

Browse more office tools

Office tool hubs