How spreadsheets are used at work

At Spreadsheet.com we believe the spreadsheet is still in its early days as a medium for collaborative work, with potential to evolve into one of the next great enterprise software platforms.

Over our collective decades of experience in the software industry, we’ve developed a deep conviction about the staying power of spreadsheets and the massive opportunity that awaits a next-generation spreadsheet purpose-built for collaborative work. Ultimately this conviction led to the creation of our product and company.

Yet strong as our convictions are, until recently they were based primarily on anecdotal evidence — our personal observations and experiences combined with those of hundreds of people we talked to. In order to better quantify the magnitude of the Spreadsheet.com opportunity, we needed more than anecdotal evidence.

2019 Spreadsheet.com spreadsheet usage survey

That’s why we recently created a survey to collect data on how people use spreadsheets at work. In November we sent this survey to over 8,000 people who registered for early access to Spreadsheet.com, and received more than 1,150 responses.

While these responses are biased since they came from people known to be interested in Spreadsheet.com, we believe they are broadly representative of general spreadsheet usage and provide a qualitatively useful view of user needs that are currently not well served.

In short, here’s what we found:

  1. Over 90% of respondents use spreadsheets for work on a daily basis, which aligns with earlier academic research, discussed below, showing as much as 90% of business workers using spreadsheets on a daily basis, often for several hours per day.
People choose spreadsheets over other tools because they are more flexible, better known by teammates, and easier to use.

2019 Spreadsheet.com early access emails

In addition to our survey results, we received over 500 emails in November from early access registrants, with detailed use case explanations describing how they want to use Spreadsheet.com. We consolidated these emails, in a spreadsheet of course, and looked for patterns. Here’s what we found:

  • Pattern 1 — Want more from spreadsheets: Teams using traditional spreadsheets (Excel or Google Sheets) for collaborating on many things, ranging from project plans and task lists, to lists of contacts, customers, employees, budgets, and much more. Spreadsheets work because they’re flexible, familiar, and easy to use — but they’re not enough. These teams want more from their spreadsheets without sacrificing what already works.

Dartmouth University Spreadsheet Engineering Research Project (SERP)

Before we decided to run our own survey, we looked for other spreadsheet usage surveys and found surprisingly few. One that stood out was created as part of Dartmouth University’s Spreadsheet Engineering Research Project (SERP). This survey was run in 2007, just one year after Google Sheets was launched, and several years before Microsoft launched Excel online — in effect, before the spreadsheet was brought online at any meaningful scale.

The SERP survey received nearly 1,600 responses and Dartmouth researchers wrote three insightful papers about the results, available here. In short, the highlights for us from this study were:

  1. The broad use of spreadsheets was high: “Slightly over 90% of the sample indicated that at least some of their time at work was devoted to creating spreadsheets.”

Conclusions

Based on survey results, early access emails, and years of anecdotal evidence, we can confidently say that spreadsheets remain broadly and frequently used in virtually every industry, business function, and region of the world, enabling teams to collaborate on many different kinds of work. Their flexibility, familiarity, and ease of use give them tremendous staying power, despite a lack of significant collaboration features and the increasing number of products designed to replace them for specific use cases.

The simplest way to categorize spreadsheet usage is with two broad and dichotomous use cases:

  • Analytics: Using spreadsheets for numerical modeling, such as budgets, financial plans, and analysis of financial or numerical data.

Traditional spreadsheets such as Excel and Google Sheets are excellent tools for analytics, which is what they’ve been designed for since their creation. By contrast, these products are not designed to be used as shared databases and project management tools for managing collaborative work. Yet based on our research, we believe hundreds of millions of people use them this way today — as much as, maybe even more than, for analytics.

This is why we believe the world needs a more capable spreadsheet for collaborative work. One that maintains fidelity and backward compatibility with traditional spreadsheets so people don’t have to sacrifice flexibility, familiarity, and ease of use in order to gain new capabilities. One that reimagines the spreadsheet for a new era of collaboration.

The all-in-one spreadsheet. One familiar tool that brings people, projects, and data together.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store