tools
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.

tools

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

19. May 2023

How to switch from notioncharts.io to GRID: a step-by-step guide

Learn how to easily transition from notioncharts.io to GRID and gain access to powerful features including an AI formula assistant...

17. May 2023

How to create a dashboard in Notion

Learn how to create a dynamic dashboard in Notion using GRID.

17. March 2023

How to use AI with INDEX MATCH, VLOOKUP and IF functions

Find out how you can unlock the power of the VLOOKUP, INDEX & MATCH, and IF functions with GRID's AI...

02. March 2023

How to create charts from your Notion database 

Ever felt like you weren’t realizing the full potential of your Notion databases? If so, you’re not alone. That’s why...

09. January 2023

How to make beautiful charts for Notion with GRID

Notion Consultant Sara Loretta shares how she uses GRID to turn Notion databases into interactive charts.

30. November 2022

Data Storytelling: The Last Mile

Create impactful visual presentations with GRID. A guest post by Paul Barnhurst

24. August 2022

How IonQ uses GRID to support strategic decision-making

Jordan Shapiro tells us how GRID helps IonQ executives make data-driven decisions.

22. August 2022

Simplify your sales process with interactive pricing calculators

Relate costs and benefits to clients in a tangible way using an interactive pricing calculator. Help your sales team accelerate...

19. May 2022

How to write a board report

Need to write a board report? We’ve got a free template & tons of tips!