• Skip to primary navigation
  • Skip to main content
The Data Lab

The Data Lab

  • Business Support
        • Business Support

          We’ll help you harness the power of data so you can innovate and grow your business.

          Visit our Business Support page

        • Accessing Talent
          • Data Talent
          • Placements
        • Funding
        • Small Business Support
        • Digital Strategy
        • Academic Project Funding
        • The Data Lab Community
  • Professional Development
        • Professional Development

          We’ll help you harness the power of data so you can innovate at work and also advance your career.

          Visit our Professional Development page

        • Workshops
        • Online Courses
        • Data Skills for Work Programme
        • The Data Lab Community
  • Students
        • Students

          We’ll help you learn about the power of data and gain real-world experience and career-focused qualifications.

          Visit our Students page

        • The Data Lab Academy
        • PhD
        • TDL Academy Placements
        • Scholarships
        • The Data Lab Community
  • Partner With Us
        • Partner With Us

          We work in partnership with companies to help them gain maximum benefit from the strategic use of data.

          Visit our Partner With Us page

        • Collaborate With Specialists
        • Partnership Opportunities
  • About Us
        • About Us

          We discover opportunities, connect people and ideas, develop knowledge and expertise and bring game-changing data projects to fruition.

          About Us

        • Our Team
        • Careers With Us
        • Join our board
        • Academic Opportunities
        • The Data Lab Community
        • Case Studies
        • News & Podcasts
        • DataFest
        • Scottish AI Alliance
        • Contact us

Why Excel spreadsheets are bad for business: data errors & solutions

Data Science / Analytics, Digital Technology, News, TORCH news 01/02/2021

why excel spreadsheets are bad for business

Our TORCH team explain why Excel spreadsheets are bad for business (alongside other spreadsheet tools), why people continue to use them, and how to tap into affordable alternatives …

Spreadsheets became a business staple in the 1980s; a familiar tool that the majority of individuals feel relatively comfortable using to this day.

Type ‘Spreadsheets for businesses’ into Google and it’ll deliver page after page of management templates that are guaranteed to help, “streamline the speed and utility of your business”. These free tools and guides promise to enable businesses to organise and categorise their data into a logical format – thus, supporting in their growth.

However, as more and more organisations begin to understand the value that data can bring to their business (and the relative ease at which it can be collected), it’s become apparent that these tried and trusted tools are no longer up to the job. In a recent article discussing the best tools for data analytics, Forbes noted, “The biggest barriers to benefiting from advanced analytics are certainly now organisational, rather than technological.”

Why do companies use spreadsheets?

After decades in the marketplace, it comes as no surprise that organisations are still relying heavily on systems that may no longer be right for them:

  • Convenience and cost: Both factors play a large role in the dependence upon spreadsheets; most people already have the software on their PCs/laptops, meaning there is no need to factor in extra costing. Additionally, generations have been raised on Microsoft platforms, where Excel is familiar and most people already feel relatively confident.
  • Multiple uses: As well as the overall user-friendly feeling, spreadsheets offer versatility and flexibility. They allow individuals to perform hundreds of simple (and very complex) things with the same tool/software.
  • Existing skill sets: Businesses are often limited to the skills base that they have internally/around them. If they are working with an external account, for example, who provides them with a big spreadsheet, this will inherently become their norm. Qualified internal teams may choose/only have the funds or authority to operate within these platforms.
  • Urgency: Internal technical teams are often keen to make fixes to business processes, data-set, etc. Spreadsheets provide a quick solution.

So, why are Excel spreadsheets bad for business?

The ‘spreadsheet are bad for business’ discussion is not limited to Microsoft Excel. There are a great deal of alternatives. Competitors include the likes of Google Sheets, Numbers (Apple), Zoho, LibreOffice, etc.

Regardless of the system, users will encounter problems across all spreadsheet platforms when it comes to managing data sets.

The disadvantages of spreadsheets: Why Excel and spreadsheets should NOT be used as a database …

Vulnerable to Fraud

Spreadsheet systems were never intended to be enterprise-level tools and, as a result, the possibilities for fraud are plentiful. Concealed code, hidden rows or columns, and fallacious inputs are all too easy to disguise.

Multiple Versions of Files

Once spreadsheet documents are shared and individuals begin editing for their own purpose, it’s difficult to identify who has the ‘latest’/’correct’ version.

Prevents Quick Decision Making

Tracking changes accurately is very difficult, especially as the number of users grows. Tracing who changed what (and when) can often become impossible.

Human Errors & Data Quality Management Challenges

Spreadsheets platforms will accept most of what a user types, allowing for spelling mistakes and incorrect data input. Unless there is someone assigned to make thorough checks (which is costly & time consuming), these errors can lead to significant business failures.

Hard to consolidate

So tiresome, in fact, that many organisations offer full tutorials on ways to overcome this. Merging content usually requires the end user to collect and summarise data from each file before combining them.

They Don’t Link to External Data Source

Not only do spreadsheets struggle with external links, there is potential for data links to be used to access and share confidential information without your permission.

Size Limitations

There is a limit in the number of rows a spreadsheet can store, meaning that organisations must eventually work over multiple files (creating more room for error). It was this precise problem that caused an issue with large numbers of COVID tests not being recorded and reported in England in 2020.

Still need convincing? A 2019 article by Oracle provides harrowing examples of how spreadsheets have made for some infamous, costly mistakes. The disclosed losses in the article total over 10 billion dollars!

Why is Excel bad for data analysis?

In addition to the points listed above, sharing an Excel spreadsheet is a highly tedious affair. Spreadsheets create ample opportunities for accidental data loss, which makes it impossible to share crucial data and information. Most importantly, the data sets can’t be shared in real-time, which happen to be a severe disadvantage.

Furthermore, when compared to the newer, advanced tools such as PowerBI, Qlik Sense, etc. spreadsheets are particularly poor for data visualisation and generating business insights.

The alternatives to Excel for large data sets: Which data toolset is right for you?

There are literally hundreds of data technology options now available to businesses, but identifying which one is right for you and your goals can be overwhelming.

At The Data Lab, our TORCH Business Advisory Experts regularly encounter organisations struggling to move forward with their plans due to spreadsheet limitations. It’s their job to identify the factors holding businesses back and make unbiased recommendations and introductions accordingly.  Learn more in our TORCH Case Studies.

If you need help understanding the business intelligence solutions available; or if you’d like impartial support with a new data project, then why not email our friendly team – and let’s see if your problem can be solved with data. Contact TORCH.

Innovate • Support • Grow • Respect

Get in touch

t: +44 (0) 131 651 4905

info@thedatalab.com

Follow us on social

  • Twitter
  • YouTube
  • Instagram
  • LinkedIn

The Data Lab is part of the University of Edinburgh, a charitable body registered in Scotland with registration number SC005336.

  • Website Accessibility
  • Privacy Policy
  • Terms & Conditions

© 2023 The Data Lab

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsReject AllAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-advertisement1 yearSet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
CookieLawInfoConsent1 yearRecords the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
_ga2 yearsThe _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.
_ga_DPXX4XJSJ82 yearsThis cookie is installed by Google Analytics.
_gat_gtag_UA_54851888_11 minuteSet by Google to distinguish users.
_gat_UA-54851888-11 minuteA variation of the _gat cookie set by Google Analytics and Google Tag Manager to allow website owners to track visitor behaviour and measure site performance. The pattern element in the name contains the unique identity number of the account or website it relates to.
_gcl_au3 monthsProvided by Google Tag Manager to experiment advertisement efficiency of websites using their services.
_gid1 dayInstalled by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.
CONSENT2 yearsYouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
personalization_id2 yearsTwitter sets this cookie to integrate and share features for social media and also store information about how the user uses the website, for tracking and targeting.
VISITOR_INFO1_LIVE5 months 27 daysA cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSCsessionYSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devicesneverYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-idneverYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
cl-bypass-cache1 hourNo description
muc_ads2 yearsNo description
SAVE & ACCEPT
Powered by CookieYes Logo