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

Hjalmar Gislason

CEO of GRID

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