Scratchpad
14. September 2022

Launching Scratchpad: GRID as an end-to-end data tool

GRID is on a mission to become the numbers tool for a new generation.

This week marks a big milestone for us. Up until now, GRID has been a companion tool for your spreadsheets - a secondary tool providing a way for users of Google Sheets and Excel to build and securely share engaging web-based narratives and user interfaces on top of data and models from traditional spreadsheet software.

A few weeks ago, we silently launched connectivity to the first data source other than spreadsheets (and CSVs) - Notion databases. Since then, we've added a way to connect directly to web files and Airtable.

Introducing: GRID Scratchpad

At the beginning of this year, I wrote a post detailing our vision for GRID's transformation from secondary to primary tool, focusing on modern teams doing daily data work. I referred to our goal as a collaborative notebook for non-data scientists. 

Today, we're taking a big step toward realizing this vision by adding what we see as a spreadsheet "scratchpad" to the GRID editor. This new feature allows for in-product entry and editing of data and formulas, without uploading or connecting a pre-existing spreadsheet or database. That's right - now you can edit data directly in GRID, quickly type or paste in the numbers you need, and use them to create interactive visualizations in literal minutes. 

scratchpad

The primary objective of Scratchpad is to provide a place to:

  • Enter small amounts of data

  • Drop in data copied from other spreadsheets, tables, or the web

  • Combine and transform data coming in from other sources

In other words, Scratchpad isn't meant to be a fully-featured editor for spreadsheet modeling, but rather a way to solve common tasks associated with ad-hoc data analysis and reporting. We want to help users accomplish these tasks quickly and easily, and come away feeling empowered.

In fact, we remain just as dedicated to providing a fantastic experience on top of traditional spreadsheets such as Google Sheets and Excel files as before. That's where serious spreadsheet editing and modeling will continue to happen.

Behind the scenes: the "back of the spreadsheet"

A surprising amount of spreadsheet work isn't as substantial as you might think. Through analysis of several corpora of real-world spreadsheets that we did early on, we found that about 80 percent of spreadsheets have fewer than 10,000 cells with content and about 40 percent have fewer than 1,000 cells. Most spreadsheets only make use of simple calculations. In fact, 43 percent of spreadsheets contain no formulas at all!

So, while the world probably doesn't see a lot of literal "back of the envelope" calculations anymore, that mode of working hasn't gone anywhere. Scratchpad - and soon even the GRID document surface itself - will be a great place for this to happen.

behind envelop

A place to combine, transform, and narrate data

Scratchpad provides a key place for transforming and combining data that comes in from other sources. We're thinking about instances where you'd:

  • Combine data from two web sources in a single chart, as in this example on Oil Prices vs. Inflation.

  • Show an aggregate view of records from a Notion database and embed it back in a Notion page, like we've done with this Golf Statistics tracker.

  • Report on data coming from Airtable bases on a single page with narrative and interactive projections. A Quarterly Sales Report is ideal.

Having used Scratchpad for a lot of my work since early summer, I can see what a truly pivotal development it is - not only for GRID as a product but also for GRID as a business. We're making confident strides toward fulfilling the vision we defined earlier this year, and I for one can't wait to see what comes next. 

This article has also been published on Medium

By Hjalmar Gislason

CEO of GRID

More blog posts

22. August 2022

Drive sales with interactive price quote calculators 

Save your sales team time & guide clients to better informed decisions.

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.

27. June 2022

Interactive GRID features for engaging teamwork  

Interactive GRID features are extremely effective in enabling collaborative analysis — especially when used in combination.

04. November 2021

Introducing Conversations: a new way to explore & explain data

We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication and collaboration in context.

23. March 2021

GRID launches empowering spreadsheet-to-web software 

We’re launching our revolutionary spreadsheet-to-web tool that will give superpowers to spreadsheet users around the world!

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

14. December 2018

The 20 Best Spreadsheet Quotes

We've deep dive into the world of spreadsheets and come across a lot of insightful, witty and distressing quotes. Here...

31. July 2019

Spreadsheets, we have a problem!

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

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