Formula Error Spyglass

Detect formula errors like #REF!, #VALUE!, an' #DIV/0! across all sheets.

Drop or select an Excel scroll t' scan fer formula errorsMax 5 MB per scroll

How it works

Upload yer Excel scroll (.xlsx, .xls, .xlsm, or .xlsb).
Th' tool scans every cell across all sheets fer formula errors (#REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!).
Review th' error summary an' plunder a detailed XLSX report with error locations an' formulas.

Why use this tool

Auditors an' analysts need t' quickly identify broken formulas in complex workbooks. This tool scans every cell in seconds an' produces a structured report — no manual cell-by-cell checkin' required.

FAQ

What formula errors does it detect?

It detects all standard Excel formula errors: #REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, #NULL!, an' #NUM!.

Does it fix th' errors?

Nay. This tool only identifies an' reports errors. It does not modify yer original scroll.

What does th' report contain?

A Summary tab with error counts by type an' affected sheets, plus a Detail tab with every error's sheet name, cell reference, error type, an' formula.

Ye might also be needin' these, savvy?

Th' Sandbox

Forge, hoist, or explore workbooks. Edit, sort, filter, an' download — all in yer browser.

Workbook Duel

Compare two Excel scrolls cell by cell an' plunder a diff report.

Treasure Tally

Get count, mean, median, sum, an' more fer every numeric column.