Spreadsheet error statistics (2026)
About 94% of operational spreadsheets contain at least one error. The average cell error rate is ~5%, in line with the 2–5% rate at which humans make mistakes in complex cognitive steps.
How common are spreadsheet errors?
- ~94% of operational spreadsheets audited contained at least one error (Panko).
- The average cell error rate is around 5%.
- Humans make mistakes in roughly 2–5% of complex cognitive steps — and spreadsheets preserve every one.
Why they matter
Because spreadsheets often feed real decisions, even small error rates carry real financial risk. High-profile spreadsheet failures have cost organisations millions and led to public restatements.
Source: Prof. Raymond Panko's research summarising spreadsheet-audit studies, compiled in The State of Spreadsheets 2026.
Reducing the risk
Automating calculation and reporting removes whole classes of manual error. See spreadsheet usage statistics for the adoption picture, or try the spreadsheet risk checker.
Frequently asked
What percentage of spreadsheets have errors?
About 94% of operational spreadsheets contain at least one error, according to research by Professor Raymond Panko.
What is the average cell error rate in spreadsheets?
Around 5% — consistent with the 2–5% rate at which humans make mistakes in complex cognitive steps.
Can spreadsheet errors be prevented?
Manual errors can be sharply reduced by automating calculation and reporting, so figures aren't re-entered or re-built by hand each time.
Get your own numbers out of a spreadsheet — in about a minute
DataHub Pro turns any Excel or CSV file into dashboards, forecasts and a written report, automatically.
Try DataHub Pro free →