Skip to content
Formula Audit XL

Find hardcoded numbers in your Excel formulas, free.

Drop a workbook below. Formula Audit XL lists every formula with a typed number in it, and every value typed over a formula, in one sortable table. No data leaves your machine.

Drop an .xlsx file here, or click to choose

Runs entirely in your browser. Your file is never uploaded. It stays on your machine.

What this tool checks

A model is only as good as its inputs, and the inputs you cannot see are the dangerous ones. A growth rate typed into a formula (=B4*1.2) or a one-off adjustment (=SUM(A1:A9)+500) looks like a calculation, but it is an assumption with no label. Change the input cells and that number stays.

The finder checks two things. It splits every formula into tokens and lists the typed numbers that remain once references, names, text and error values are taken out. Then it looks at every typed value in the workbook and flags the ones that sit in a row or column of matching formulas: almost always a formula that someone overwrote with its own result.

How to use it

  1. Drag your .xlsx file onto the box above (or click to choose one).
  2. Read the summary counts, then sort the table by sheet, cell, formula or reason.
  3. Move each typed number into a labelled input cell, or restore the formula that was overwritten.
  4. Download the CSV to track the fixes, or install Formula Audit XL to colour hardcodes live inside Excel.

For the full review routine, read the financial model audit checklist, or see how the add-in shows hardcodes in Cell Map and lists them in the audit checks.

Frequently asked questions

Is my Excel file uploaded anywhere?

No. The finder runs entirely in your browser using your device's memory. Your file and its contents never leave your machine, so it is safe for confidential models.

What counts as a hardcoded value?

Two things. First, a number typed inside a formula, such as =B4*1.2 or =SUM(A1:A9)+500: the 1.2 and the 500 are assumptions hidden where nobody can see or change them. Second, a typed number in a row or column that is otherwise formulas: usually a value pasted over a formula, so that cell no longer updates.

Which numbers are not flagged?

A short allow-list. 0, 1 and -1 are never flagged, because they are identities and tests (=A1*1, =IF(A1>0,...)). 100 is not flagged next to * or /, because =A1/B1*100 is a percentage conversion. And a bare number in a structural argument is not flagged: the digits of ROUND, the column index of VLOOKUP, the match type of MATCH, the function code of SUBTOTAL. Those choose how a function works, not a model input.

Can it mistake a cell reference or a text for a number?

No. The formula is split into tokens before anything is checked, so the digits in A1, $B$7, 3:3, Sheet2!C4, LOG10, "Q4 2024" and #DIV/0! are never read as numbers. Scientific notation such as 1E+6 is read as one number.

Why is the first value in a row not flagged?

A row of formulas usually starts from a typed value: an opening balance or a first-year actual. The finder only flags a typed value when formulas with the same pattern sit on both sides of it, or when it ends a run of matching formulas.