WoluTools
Find a tool

Spreadsheets & Data

Audit an Excel file for hard-coded numbers and hidden sheets

Upload an XLSX or XLSM and get a list of formulas that break the pattern around them, numbers typed in among formulas, and hidden rows, columns and sheets.

or drop it here

XLSX, XLSM · Up to 500,000 formula cells
Free account needed for your 3 free jobs a day

No file at hand? See the prepared example

Standard toolIncluded · 3 free jobs a dayFree: 3 jobs a dayPro: up to 200 jobs a day · €12.99/month or €89.99/year
  • XLSX / XLSM
  • Up to 500,000 formula cells
Prepared result preview · fictional sample dataFictional XLSX Formula Pattern & Hidden-Content Audit fixture
Source
1 prepared source file · 407 bytes
Prioritized findings
  • Worksheets: 1
  • Formulas: 1
  • Families: 1

formula-inventory.csv · formula-families.csv · anomalies.csv · hidden-content.csv · findings.csv · manifest.json

BringXLSX, XLSM
GetFormula inventory, family map, anomaly list, hidden-content list, findings and manifest
PrivacyEncrypted source · 24-hour result

One clear job, from source to download

  1. 1

    Add the source

    Supported formats and limits are visible before the upload.

  2. 2

    Confirm the settings

    Review the exact source, options, units and access before processing.

  3. 3

    Inspect and download

    Check the preview and warnings, then unlock the complete package.

Finding typed-in numbers and hidden sheets in Excel

What you upload and what it looks for

You upload one XLSX or XLSM workbook with up to 500,000 formula cells. The tool groups cells whose formulas are the same once relative references are lined up, such as a column filled down from one cell. When a cell inside such a group holds a typed number instead of the formula, it is reported. Hidden rows, columns and sheets are listed too, along with any macro project.

What you get back

The download contains six files. formula-inventory.csv lists every formula. formula-families.csv shows the groups of copied formulas. anomalies.csv lists each typed-in override with its sheet and cell reference. hidden-content.csv covers hidden rows, columns, sheets and macros. findings.csv summarises the results, and manifest.json records which file was read. Open a few flagged cells in Excel to confirm each finding before you change anything.

Sensitivity and what it cannot judge

Override sensitivity has two levels. Strict flags every constant that interrupts a group, including exceptions someone entered on purpose. Balanced reports only the clearer cases. Macros are never run, because the workbook is read as a file and not opened in Excel. The tool also does not recalculate anything, so a formula that is consistent but wrong will not be caught. Whether each flagged number is a mistake is your call.

Questions before you run it

What is a formula family?

A group of cells whose formulas are identical once relative references are normalised, such as a column filled down from one cell. Families make it obvious where a run of copied formulas is interrupted.

How does it find hard-coded numbers?

When a cell inside a formula family holds a typed constant instead of the family formula, it is reported as an override in anomalies.csv with its sheet and cell reference.

What changes between strict and balanced sensitivity?

Strict flags every constant that interrupts a family, including exceptions somebody entered on purpose. Balanced reports the clearer cases only. The file layout is the same either way.

Are macros in an XLSM opened or executed?

Never. The workbook is read as static OOXML, so a macro project is inventoried in hidden-content.csv while no code runs.

Does it recalculate the workbook to find wrong results?

No. There is no calculation engine here and no claim of parity with Excel. The audit describes structure, so a formula that is consistent but conceptually wrong will not be caught.