90 per cent of spreadsheets have at least one major error: Study

A recent study has brought to light a startling statistic: 90 per cent of spreadsheets containing more than 150 rows have at least one significant error. This finding underscores the inherent risks in the widespread use of spreadsheets, a tool integral to numerous business operations worldwide.

The very flexibility that has made spreadsheets a cornerstone in various industries is also a contributing factor to these errors. Despite advancements like the integration of Python scripting in Excel, human error remains the primary culprit behind spreadsheet-related issues.

Occasionally, these errors have led to high-profile incidents. For instance, the Police Service of Northern Ireland suffered a massive data leak due to a spreadsheet error, compromising the personal details of 10,000 officers. In Wales, a spreadsheet mistake significantly disrupted the recruitment process for trainee anesthetists, mistakenly classifying all candidates as “unappointable.” Financial blunders include erroneously transferring $10.5 million instead of $100 to a customer and an Icelandic bank undervaluing its shares by millions due to a spreadsheet error.

The lack of published examples from the U.S. or Canada doesn’t mean such errors are non-existent in these regions. In fact, for every major spreadsheet error that makes the news, countless others occur daily in various organizations.

According to an article from The Conversation, these widespread errors often stem from a lack of standardization in spreadsheet formatting and structure. This issue, combined with the prevalent practice of manual data entry, significantly increases the likelihood of mistakes.

The study suggests that it might be time for organizations to adopt more standardized practices in spreadsheet usage. Improving training for users and fostering a culture that encourages critical thinking in spreadsheet creation and maintenance could be key steps in mitigating these risks.

This situation brings to mind a famous line from Spiderman’s Uncle Ben: “With great power comes great responsibility.” As spreadsheets continue to be powerful tools for data management and analysis, the responsibility to use them accurately and effectively becomes increasingly important.

Sources include: The Conversation

Jim Love
Jim Love
I've been in IT and business for over 30 years. I worked my way up, literally from the mail room and I've done every job from mail clerk to CEO. Today I'm CIO and Chief Digital Officer of IT World Canada - Canada's leader in ICT publishing and digital marketing.

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

ITW in your inbox

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

More Best of The Web