31. March 2019

The business world’s love/hate relationship with spreadsheets

Spreadsheets are knowledge workers’ answer to the question: “How can I get this done NOW?”, where “this” can be anything from creating a small database to modeling and analysis to standing up a new business process (see “The three types of spreadsheets”).

Business people need to get stuff done, and they don’t have the time to stand up a project involving the IT department or go search for purpose-built software that meets their needs.

It is a testament to the power of spreadsheets that they are accessible and versatile enough for “normal” business people to solve many — if not most — of their custom IT needs without any formal training in software development, data modeling or other things normally a pre-requisite to building software.

However, these software creations also have many short-comings, including:

  1. Management: Spreadsheets are typically shared in their entirety — still mostly as Excel files via email. This leads to version proliferation, but also makes access control difficult. There are no audit trails, and it is hard for anyone to gain an overview of all the different — and often mission critical — ways spreadsheets are used in their organizations.

  2. User interface: The user interface for any spreadsheet is spreadsheet software. In short: Anything created in Excel needs to be opened in Excel. Control over the look and feel of the interface is limited and difficult — and mobile support is slim to none.

  3. Opaque and error-prone: Spreadsheet models are opaque and hard to gain an understanding of for anyone other than the author of the document. Also, as a lot of these solutions are created by people that are not used to develop software, quality control is usually limited and errors easily go undetected.

These three reasons — and several smaller ones — are the reason spreadsheets have gotten a bad reputation in some circles, IT in particular.

The solution — however — is not to eliminate spreadsheets (good luck anyways!), but to give spreadsheet users new tools and “superpowers” to overcome these issues. That way, knowledge workers can keep solving their domain-specific needs themselves and maintain their high level of productivity without IT breathing down the back of their neck.

This article has also been published on Medium.

Written by Hjalmar Gislason

More blog posts

11. February 2020

A notebook for Excel and Google Sheets

Computational notebooks have taken the DataScience world by storm over the last few years - and for a good reason.

14. December 2018

The 20 Best Spreadsheet Quotes

In GRID’s deep dive into the world of spreadsheets, we’ve come across a lot of insightful, witty and sometimes somewhat distressing quotes....

03. November 2017

3 things you don’t understand about spreadsheets (part 3)

This is the third and final part of a series of blog posts on the origin and nature of sspreadsheets.

12. February 2021

Facewatch drives sales with client reports

GRID-powered client reports help Facewatch generate sales.

21. October 2017

3 things you don’t understand about spreadsheets (Part 1)

The world has a love/hate relationship with spreadsheets.

06. March 2018

Your biggest competitor is a spreadsheet

If you are in the software industry, odds are that your biggest competitor is a custom spreadsheet created by your...

28. August 2018

Excel vs. Google Sheets usage — nature and numbers

One of the most common questions I get is if Excel is still important, implying that “everybody” must be using...

15. September 2018

What’s your level? Six levels of spreadsheet user sophistication

In preparing everything from the product features and UI to the go-to-market plan and messaging for GRID, we have realized that...

07. May 2019

The Case for Modern Productivity Tools

Several startups are realizing the power of spreadsheets and the spreadsheet “metaphor” as an end-user development approach: A way to...