Excel Spreadsheet Error Checker
Upload your file · select checks · click Audit. Your data never leaves your browser.
Drop your Excel file here
or click to browse your files
100% private — files are never uploaded to any server
What the Auditor Checks
Formula Error Cells
Every cell showing #REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, #NULL!, or #NUM! — with its location and the exact error type.
Inconsistent Formulas
Cells where the formula in a column breaks the pattern — often a sign of an accidental overwrite or a hardcoded value hiding in a formula column.
Hidden Sheets
Both standard hidden sheets and very-hidden sheets (which cannot be unhidden via the normal right-click menu). These are a common source of unexpected data.
Broken External Links
References to external workbooks that are missing or use a path that no longer exists. These silently return #REF! when the linked file is unavailable.
Hardcoded Values
Literal numbers embedded inside formula text (like =A1*1.05) instead of being in a referenced cell. These are invisible to reviewers and hard to update consistently.
Volatile Functions
NOW(), TODAY(), RAND(), INDIRECT(), and OFFSET() recalculate on every workbook change. In large workbooks they slow down calculation significantly.
Deeply Nested IFs
IF statements nested 4 or more levels deep are hard to read and maintain. The auditor flags them so you can consider replacing them with IFS() or a lookup table.
Hidden Rows & Columns
Lists all hidden rows and columns by sheet. Hidden data can affect filter results and create unexpected formula behaviour.
Unprotected Division
Division operations not wrapped in IFERROR or ISNUMBER — these will show #DIV/0! if the denominator becomes zero.
When to Run a Spreadsheet Audit
A spreadsheet audit is most valuable at the following moments in a workbook's lifecycle:
- Before sharing with stakeholders: Catch broken formulas, hidden sheets with draft data, and hardcoded assumptions before a file leaves your hands. Error cells in a report sent to management are embarrassing and avoidable.
- After inheriting a workbook: When you receive a workbook built by someone else, an audit gives you an immediate map of its risk areas — without reading every formula manually. See the Formula Extractor for a full formula inventory alongside the audit.
- After a large edit session: Inconsistent formulas most commonly appear after bulk edits where a paste overwrites part of a formula column. Run an audit after significant changes to verify nothing broke.
- Before archiving: Remove hidden sheets, volatile functions, and external links before saving a final version. External links to temporary paths will fail for anyone who opens the archived file later.
- Data quality reviews: The audit is often faster than a manual review for checking whether all required columns are fully populated and formula-consistent.
For a deeper dive into Excel auditing best practices, see Microsoft's guidance on finding and fixing formula errors.
Frequently Asked Questions
What does the Excel Spreadsheet Auditor check?
The auditor checks nine categories: formula error cells (#REF!, #VALUE!, #DIV/0!, #N/A, #NAME?), inconsistent formulas in columns (where one row uses a different formula to adjacent rows), hidden and very-hidden sheets, broken external file links, hardcoded values embedded in formulas, unprotected division (division without IFERROR), hidden rows and columns, volatile functions (NOW, RAND, INDIRECT, OFFSET), and deeply nested IF statements with 4 or more levels.
Is my Excel file uploaded to a server?
No. The entire audit runs in your browser using JavaScript. Your file is read locally and never sent to any server, stored, or seen by anyone. Close the tab and the data is gone.
What is a hardcoded value in a formula?
A hardcoded value is a literal number typed directly inside a formula — for example =A1*1.2 where 1.2 is hardcoded. These are risky because they are easy to miss when reviewing assumptions, and changing them requires finding every cell that contains the value rather than updating one source cell. Best practice is to put constants in named cells and reference those.
What is a volatile function and why is it flagged?
Volatile functions recalculate every time any cell in the workbook changes — not just when their inputs change. Common volatile functions include NOW(), TODAY(), RAND(), INDIRECT(), and OFFSET(). In large workbooks they can significantly slow down calculation. The auditor flags them so you are aware of them and can decide whether they are intentional.
What is an inconsistent formula?
An inconsistent formula is a cell in a column where every other row uses the same formula pattern, but one cell uses a different formula (or a hardcoded value). For example, if B2:B99 all contain =A2*C2 but B50 contains =A50*0.8, B50 is inconsistent. These are often caused by accidental overwrites and can silently produce wrong results.
Can I download the audit report?
Yes. After the audit completes, click "Download Report" to save a formatted HTML file containing every finding, sorted by severity. You can open this file in any browser and share it with colleagues.
Related Excel Tools
Excel Formula Extractor
List every formula in the workbook — sheet, cell, formula text, and current value.
Compare Excel Files
Diff two versions of a workbook to see exactly what changed.
Excel Password Remover
Remove sheet protection so you can edit locked cells before auditing.
Excel Find & Replace
Bulk-replace values across the entire workbook in one pass.