excelStats
25. October 2019

Spreadsheets as a UI pattern  -  leveraging knowledge workers' existing skills 

After a somewhat quiet decade or so, the last few years have seen a significant uptick in innovation in the productivity tool space. The success of products such as Slack and Airtable has shown that there is room for newcomers, and that entry into this market isn’t completely blocked by Microsoft (and to a lesser extent Google).

For GRID, the spreadsheet market is where we play and — mostly because of how little information we’ve put out there publicly — the most common misconception about what we’re doing is that we’re building a new spreadsheet in direct competition with Excel and Google Sheets.

(We’re not.)

There is a graveyard full of companies that have looked at this market and decided to either make a new spreadsheet, or make something that’s not a spreadsheet, but supposed to replace spreadsheets with something different/better. I believe the theories behind these products have often missed how engrained spreadsheets are in the business world, and how wide their range of usage is — including for things they were never designed to do.

What has proven more successful is to deeply understand a subset of use-cases currently solved with spreadsheets and focusing on doing them better. In fact one might claim that from the introduction of VisiCalc 40 years ago as the first successful B2B software tool for the PC market, most B2B software has been the result of cleaving off something a spreadsheet was used for and doing it better. Even today, many startups’ fiercest competition comes from home-grown spreadsheets— and many of them still loose.

But I feel that there is a paradigm emerging: Software that uses spreadsheet-like user interfaces, UX patterns and even formula language as a way for everyday spreadsheet users to quickly familiarize themselves with a new piece of software that — from the UX perspective — could just as well have gone a more“traditional” route. The benefit? A billion people are already familiar with spreadsheet software and instantly approach anything that looks like a spreadsheet with a certain set of assumptions and familiarity. Done well, this can shorten people’s learning curve dramatically and enable them to quickly become productive with something that might otherwise feel quite intimidating.

Examples of this include:

  • Spreadsheet-like-data-integration: Using spreadsheet-like interfaces to enable end-users to do data integration.

             - Examples: dashdash and ActiondeskSupermetrics does a similar job, but goes the opposite way, providing an add-in to existing spreadsheets.

  • Spreadsheet-to-API: Enabling API access     to data in existing spreadsheets.

             - Example:  sheetlabs

  • Spreadsheet-as-CMS: Using spreadsheets to edit and control web site content.

    - Example: sheet2site

  • Spreadsheet-to-app: Low-code / no-code ways for turning spreadsheets into web or mobile applications.

     - Examples: glideAppSheetOpen as AppAppizy , SpreadsheetWEBMolnifySheetSu

A few of these companies straddle a couple of categories, and each of them has a slightly different approach and target market. Some of them probably don’t even agree with my characterization of what they do!

But what they have in common is the realization that users can quickly become productive doing — often complicated tasks — if they can leverage their existing spreadsheet skills and assets.

This article has also been published on Medium.

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

20. October 2022

Harness the power of interactive charts in Notion 

Bring beautiful interactivity to your Notion projects with GRID.

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