ToolsRiver Income Tax

Spreadsheet Formula Auditor

  • Free, no sign-up
  • Runs in your browser
  • Works on mobile
What it does. Upload an Excel workbook and find wrong formulas before they cause wrong numbers: error values and their root cause, totals that miss rows, inconsistent formulas, typed-over formulas, numbers stored as text, broken references, circular references and risky lookups. The file is read in your browser and never uploaded.

How to use the Spreadsheet Formula Auditor

  1. Click Choose File and pick an .xlsx, .xlsm, .xls or .ods workbook. The check starts as soon as you choose the file.
  2. Wait a few seconds while every formula is read and checked in your browser.
  3. Start with the red items. Fixing a root error often clears many cells that only pass the error on.
  4. Use the cell-by-cell table to jump to each cell in Excel (Ctrl+G, then type the address).
  5. Download the report as .txt or .json to keep a record of what you reviewed.

What the report shows

CheckWhat you learn
Error values#REF!, #DIV/0!, #N/A, #VALUE!, #NAME? and others, with root causes separated from cells that only pass the error on.
Totals that miss dataSUM, AVERAGE, COUNT and similar ranges that stop before the last rows next to them.
Inconsistent formulasA formula that differs from the ones above and below or left and right, often a copy-paste slip.
Typed-over formulasA typed number in the middle of a formula column.
Broken references#REF! inside formulas, missing sheets, broken named ranges and links to other files.
Numbers stored as textValues that SUM and lookups silently ignore.
Circular referencesChains of cells that depend on themselves.
Risky patternsApproximate VLOOKUP or MATCH, IFERROR hiding errors, volatile functions, typed-in rates and deeply nested IFs.

Tips for better results

  • Save the file in Excel right before you audit it, so the stored results are up to date.
  • Remove the workbook password first. Protected files cannot be read.
  • Convert data ranges to Tables (Ctrl+T) so totals grow automatically when you add rows.
  • Put rates such as GST or TDS percentages in one labelled input cell instead of typing them into formulas.

Limits to know about

  • Error values are read from the last calculation saved in the file. If the file was saved without recalculating, press F9 in Excel and save again.
  • The checks look for common mistake patterns. Some flagged items can be intentional, such as approximate lookups for tax slabs.
  • Macros, Power Query, pivot table logic and charts are not audited.
  • Very large files are checked up to 250,000 cells.

Frequently asked questions

How do I find errors in Excel formulas?

Upload the workbook here. The auditor lists every error value, broken reference, inconsistent formula and total that misses rows, with the exact cell address and a fix.

Is my spreadsheet uploaded anywhere?

No. The file is opened and checked inside your browser. Nothing is sent to our server.

What is an inconsistent formula?

In a column of similar formulas, one cell refers to a different row or column than its neighbours, for example =B6*C5 when the rest are =B4*C4. It usually comes from a copy or drag mistake.

Why does my SUM give the wrong total?

Common reasons are a range that stops before the last rows, numbers stored as text that SUM ignores, or a typed number that replaced a formula. All three are checked.

Does it work with Google Sheets?

Yes. In Google Sheets use File, Download, Microsoft Excel (.xlsx), then upload that file.

Related tools

About this tool: free, no sign-up, works on phone and desktop. Last reviewed: November 2026.

Try these next

Share this tool

Scroll to Top