What percentage of spreadsheets have errors?
Audits find that about 94% of operational spreadsheets contain at least one error, with an average cell error rate of roughly 5%. This comes from decades of research summarised by Professor Raymond Panko.
The numbers
Decades of research by Professor Raymond Panko, summarising real-world spreadsheet audits, found that about 94% of operational spreadsheets examined contained at least one error, with an average cell error rate of around 5%.
The underlying cause is simple and human: people make small mistakes in roughly 2–5% of complex cognitive steps, and a spreadsheet faithfully preserves every one of them — then compounds them through references and copied formulas.
Source & methodology
These findings draw on Panko's long-running review of spreadsheet-audit studies, compiled in The State of Spreadsheets 2026. "Operational spreadsheets" means real spreadsheets used in organisations, not lab exercises — which is what makes the 94% figure so striking.
Source: Prof. Raymond Panko's research summarising spreadsheet-audit studies, as compiled in The State of Spreadsheets 2026 (DataHub Pro).
Why it matters
When a spreadsheet feeds a business decision, a 5% cell error rate is not a rounding concern — it is a material risk. Automating the calculation and reporting steps removes whole categories of copy-paste and formula errors, which is a core reason teams move reporting off manual spreadsheets.
Frequently asked
What percentage of spreadsheets contain errors?
Audits find about 94% of operational spreadsheets contain at least one error, based on research summarised by Professor Raymond Panko.
What is the average spreadsheet error rate?
The average cell error rate in operational spreadsheets is roughly 5%, consistent with the 2–5% rate at which humans make mistakes in complex cognitive steps.
Why are spreadsheet errors so common?
Spreadsheets rely on manual entry and hand-written formulas. Small human mistakes — mistyped cells, wrong ranges, copied formulas — are preserved and compounded by the spreadsheet.
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 →