90% of spreadsheets have at least one major error: Study

Share post:

A recent study has brought to light a startling statistic: 90% 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 anaesthetists, mistakenly classifying all candidates as “unappointable.” Financial blunders include Crypto.com 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 US 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


Related articles

Amazon reviews losing trust as number of fake reviews are uncovered

Amazon's customer review system, once trusted for its verified buyer opinions, is increasingly under scrutiny as more and...

Apple Vision Pro U.S. sales plummet

Apple's Vision Pro headset, priced at $3,500, is experiencing a significant drop in U.S. sales. Market analysts report...

Security research team claims to have helped avert a major supply chain attack

JFrog Security Research team continuously scans public repositories such as Docker Hub, NPM, and PyPI to identify malicious...

Phishing attacks on state and local governments surge by 360%

Phishing attacks targeting state and local governments have surged by 360% between May 2023 and May 2024, according...

Become a member

New, Relevant Tech Stories. Our article selection is done by industry professionals. Our writers summarize them to give you the key takeaways