How to use the Spreadsheet Formula Auditor
- Click Choose File and pick an .xlsx, .xlsm, .xls or .ods workbook. The check starts as soon as you choose the file.
- Wait a few seconds while every formula is read and checked in your browser.
- Start with the red items. Fixing a root error often clears many cells that only pass the error on.
- Use the cell-by-cell table to jump to each cell in Excel (Ctrl+G, then type the address).
- Download the report as .txt or .json to keep a record of what you reviewed.
What the report shows
| Check | What 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 data | SUM, AVERAGE, COUNT and similar ranges that stop before the last rows next to them. |
| Inconsistent formulas | A formula that differs from the ones above and below or left and right, often a copy-paste slip. |
| Typed-over formulas | A 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 text | Values that SUM and lookups silently ignore. |
| Circular references | Chains of cells that depend on themselves. |
| Risky patterns | Approximate 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.