31. July 2019

Spreadsheets, we have a problem!

In previous posts, we’ve talked a lot about how spreadsheets empower domain experts to solve many of their own IT needs:

1. Spreadsheets run the world

2. Excel — a Domain Specific Language for Finance?

3. How can I get things done NOW (without talking to IT)?

However, you don’t have to spend a lot of time around spreadsheets — or in business in general — to realize some of spreadsheets’ obvious shortcomings.

GRID is built to allow spreadsheet users to make even more of their spreadsheet skills and assets by overcoming some of these weaknesses.

But what are they?

Governance and administration

The main reasons IT people, auditors and to some extent corporate management are often not too keen on spreadsheet-based solutions — and what may have coined terms such as “Excel hell” and “Frankensheets” — probably have to do with governance and administration:

  • Access control is difficult, and very binary: Either you give someone the entire sheet and they can do pretty much anything with it, or you give them a very limited — often static — version of the sheet and its value is greatly reduced. There are ways to be more granular about this, but very few people use them.

  • There are no audit trails. Who changed what, when and why?

  • Version control is mostly in form of naming conventions including dates, employees’ initials and status of the document. Ever seen a file with a name like: Budget2019-rev2-HGcomments.xlsx?

  • Important spreadsheets may not be a part of the company’s official document store, nor even backed up as they live on employees local computers or private cloud accounts (the latter most often on Google Sheets because they needed the collaboration features, but GSuite is not officially approved by the CIO).

In short, the organization has very little insight into or control over the “spreadsheet fabric” that plays an incredibly important role in almost every organization. Often far bigger than companies realize themselves.

Usability and user interface

Some of the governance and administration problems described above may be an annoyance to business users, but mainly they are a thorn in the eye of IT and management. However, there is another set of issues that end users feel more directly on their skin, and they all have to do with the fact that what’s made in a spreadsheet, stays in a spreadsheet.

This has several implications:

  • The way to distribute data, analysis or a model pulled together in a spreadsheet is sharing the spreadsheet itself. If it’s made in Excel, the recipient needs to open it in Excel (still mostly local, but usage of Excel Online is gradually on the rise), if it’s made in Google Sheets the recipient needs to open it in Google Sheets.

  • Mobile spreadsheet experience is very limited, to say the least. If you receive a spreadsheet file attached to an email you may be able to look at approximately 10 rows by 5 columns on your mobile phone, but you get no oversight and cannot interact with it. Even opening a cloud based spreadsheet in one of the native mobile spreadsheet applications is painful and far from the user experience of desktop spreadsheets, let alone the everyday mobile applications we’ve all gotten used to. The spreadsheet “grid” metaphor simply doesn’t lend itself well for mobile.

  • Spreadsheets are very limited in terms presentation and interaction. No matter how good you are at changing background colors, placing images and configuring your fonts, the layout never looks good. And building interaction beyond basic typing into cells is hard and may require macros or other tricks that will cause issues when distributing the spreadsheet.

Errors, risk and quality assurance

Despite what has been detailed here, the issues that perhaps get the most attention when it comes to spreadsheets have to do with errors, quality assurance and the associated risk.

These are certainly worthy of attention, but personally I think they are in many ways a by-product of how important much of the work that happens in spreadsheets is. It’s not like there is strict quality assurance around our emails, slide decks or text documents either! It’s more that those errors are (usually) not as consequential. It turns out that there’s a qualitative difference between errors in “hard” data and logic on the one hand, and the “soft” written word on the other.

Don’t get me wrong, these are important issues, and spreadsheet software can certainly be improved to help avoid them, but the problem has more to do with people (training, etc) and processes than the spreadsheet as a tool.

In other words: Spreadsheets are where they are because they are very powerful tools. When people get their hands on powerful tools they become more efficient and productive, but don’t expect perfect outcome without proper guidance and safety procedures.

This article has also been published on Medium.

More blog posts

19. May 2022

How to write a board report

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

03. March 2022

We can all be numbers people!

Our CEO Hjalmar believes we can all be numbers people. Here’s how he sees GRID making everyday data work easier.

23. March 2021

GRID launches empowering spreadsheet-to-web software 

It’s launch time, and we couldn’t be more thrilled. Something special happens when a team this passionate unites behind a...

09. March 2022

Empowering homebuyers with smart GRID tools

Win the House You Love helps American homebuyers make confident financing decisions 🏠

07. January 2022

What's next for GRID?

In 2022, we're transforming GRID to become the primary tool of choice for modern teams working with numbers.

11. March 2021

Easy, no-code calculators grow your business

Creating an embedded calculator based on your spreadsheet data is a simple way to build a powerful, customized web tool.

04. November 2021

Introducing Conversations: a new way to explore & explain data

Now we’re really talking. We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication...

27. October 2021

Interactive GRID features that boost user engagement

GRID was built for interactive exploration. When you consider ways to attract and engage new clients on your website, GRID...

30. September 2021

Build a price quote calculator in 5 easy steps 

Embed interactive features like calculators on a website, and voilà! They become super-engaging conversion rate boosters 🚀