25. November 2019

Spreadsheets lack people skills 

Spreadsheets are frequently shared or their findings reported on but the manner in which this is commonly done is counter-productive and kills the spreadsheet's valuable features.­­

Spreadsheets are these amazing productivity tools that enable regular knowledge workers to get all sorts of stuff done without having to rely on IT, BI or other specialists: Small databases, numerical models, even standing up and driving simple business processes. It is frankly amazing that there is such a versatile, powerful tool that approximately 1 in 5 adults on the planet know how to use! But a spreadsheet is rarely built to be used only by its’ author. Spreadsheets are frequently shared or their findings reported on.

Distributing spreadsheets

The most common distribution model for spreadsheets — by far— is as an attachment to an email. However, the author usually needs to prepare the workbook in various ways first:

- Build a narrative around it, that often goes into the body of the email
- Carefully detract data that is not to be shared
- Format the output so that it is easier to consume
- Build in guidance so that the recipients know which inputs they are expected and allowed to change and play around with

And even with careful preparation, there is, nevertheless, a certain loss of control by the author. They can’t stop the recipients from distributing the spreadsheet further; people tamper with things they weren’t supposed to, they frequently change things and send them back which leads to a multitude of versions with no trail of changes and no clear master copy.

Being on the receiving end also has its challenges:

- Spreadsheets are particularly hard to discern and use on mobile devices
- The narrative, whether in an email or orally presented, is out of context when looking at the numbers
- There is very little guidance as to how to read or interact with the model

That being said, we haven’t even mentioned the aesthetics that probably affect both the author and the recipients: regardless of how good the author is at choosing cell background colors and fonts, making a truly *beautiful* spreadsheet is beyond the skill set of most of us.

One might think that sharing online spreadsheets — such as Google Sheets and Excel Online — addressed some of these problems, but in reality, they hardly do. They use very much the same paradigm as their predecessors have on the PC for 40 years, except now in the browser.Collaboration on the authoring side is really online spreadsheets’ killer feature.

 (Side note: online spreadsheets with multiple authors are usually data collection efforts. It is very rare to see a spreadsheet with a numerical model that has multiple authors.)

Let’s make it a report

In many cases, the challenges with sharing and communicating directly with spreadsheets mean that authors resort to distribution through other types of documents such as slide decks, word processing documents made into PDFs or emails with pasted charts and tables.

This — in turn — comes with a new set of challenges, often requiring a lot of manual labor to maintain these artifacts and the obvious loss of the most distinguishing feature of a spreadsheet: that it is not a static thing but a beautiful, living numerical model. Interaction, exploration and drill-down are all gone when a spreadsheet is turned into a static report.

PDFs and PowerPoint files is where spreadsheets go to die. RIP ⚰️ 

If only there was a better way…

GRID-gif

Coincidentally… :)

At GRID we are building a solution that makes communicating with data and numbers just as easy as with the written word, leveraging people’s spreadsheet skills to allow them to build modern, interactive web documents directly on top of existing spreadsheet files.

Go ahead and sign up to be part of the GRID beta family and give those spreadsheets wings!

This article has also been published on Medium.

More blog posts

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

21. October 2017

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

The world has a love/hate relationship with spreadsheets.

27. October 2017

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

This is part 2 of 3 in a series of posts about the nature and history of spreadsheets.

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

16. October 2018

The 3 types of spreadsheets

We have been taking quite a deep dive into the world of spreadsheets lately. We have analyzed tens of thousands of...

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.

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

08. February 2019

Excel — a Domain Specific Language for Finance?

One of my biggest inspirations when doing background research before starting GRID was Felienne Hermans. I met Felienne first at Strata in London...

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