28. August 2018

Excel vs. Google Sheets usage — nature and numbers

Lately, I have been thinking quite a lot about spreadsheets, their natureorigin and ubiquity. This has led to many interesting conversations both online and off-.

One of the most common questions I get is if Excel is still important, implying that “everybody” must be using Google Sheets by now. This happens to be something I’ve dug into quite a bit. Below are my findings.

Spreadsheets by the numbers

Numbers about spreadsheet usage are surprisingly hard to come by. The reason — at least partially — is that spreadsheets are not covered separately by industry analysts, but fall under the larger “office suites” or “productivity suites” umbrella.

On that front, Microsoft dominates revenue-wise, taking in $13.8B in 2016 compared with G Suite’s $1.3B. Others’ market share is negligible.

But revenue isn’t everything. What about user numbers?

Microsoft claims no less than 1.2 billion users of Microsoft Office, but even if those all theoretically “have” Excel, that doesn’t mean that they use it. In a brilliant talk at CSVconf a couple of years ago, Jenny Brian estimated that about 2/3 of Excel’s install base ever use it. That would land us at an impressive 800 million users for Microsoft Excel.

Google does not disclose the total number of G Suite users, but early this year they announced passing 4 million paying G Suite customers. On average, there will be a number of users behind each customer account, ranging from 1–2 users in a startup to Colgate Palmolive’s 250,000 users. So, behind the 4 million customer number the users clearly count in the tens of millions, perhaps as much as 100 million. Then there are the free users. Late last year, Google’s educational program alone accounted for 70 million users of G Suite, and it’s safe to assume that at least as many users are using the free non-educational version. While involving a good amount of guesswork, this brings the order of magnitude of users that “have” Google Sheets to around the 250 million users mark. Applying Jenny’s 2/3 estimate here would land us around 160–180 million Google Sheets users. Still impressive, but less than a quarter of Excel’s base.

The demographics

Based on various literature and my conversations with a broad range of spreadsheets users, there is a clear demographical difference between Google Sheets and Microsoft Excel.

Young people use Google Sheets. Ask a college kid and they are much more likely to use Sheets than Excel. The exceptions are mostly in subjects such as finance and engineering where Excel’s superior capabilities still make it a favorite (see more below).

Young companies are also more likely to use Google Sheets than Microsoft Excel. If a company was started in the last 10 years, they are likely to be “born in the cloud”, and favor cloud-based (and historically largely free) services like Google Sheets over (historically) client-side software like Excel.

But … when a young person joins an established organization they get the Microsoft Office suite thrown at them immediately, and get dragged into the Excel world quickly. This probably means that Excel’s market share is falling significantly slower than might be indicated by Sheets’ dominance in the education system.

To be fair, there is also a significant overlap between Sheets and Excel users. In the corporate world, this is particularly noticeable with employees at established companies that have realized the superior collaboration capabilities of Google Sheets, and will make use of it when the nature of a project calls for it. This is often (read: usually) without the knowledge or permission of their corporate IT departments, also known as “shadow IT”.

The “pros” use Excel

The last, but not least important aspect of Sheets vs. Excel is that all serious spreadsheet nerds use Excel. On Windows. To them Excel for Mac is vastly inferior. The reasons being a lack of data connections and the absence of PowerPivot on the Mac side among other things.

These users see Google Sheets as a mere toy: Sluggish, and lacking many basic capabilities. The “pros” (I’ll write more about spreadsheet user levels soon) may admit to occasionally using Office 365 Online or Google Sheets to publish some of their simpler findings, but apart from that they live and breathe in the Windows Excel client.

— — —

So, yes — while Google Sheets is definitely still gaining a lot of steam, Excel is still the 800 pound gorilla in the spreadsheet market, and will remain so in the foreseeable future.


This article has also been published on Medium.

Written by Hjalmar Gislason

More blog posts

27. June 2022

Interactive GRID features for engaging teamwork  

GRID was built for interactive exploration. So when you consider ways to engage your team or better communicate spreadsheet data...

19. May 2022

How to write a board report

Need to write a board report? We’ve got a free template & tons of tips!

03. March 2022

We can all be numbers people!

Our CEO Hjalmar believes we can all be numbers people. Here’s how he sees GRID making everyday data work easier.

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

09. March 2022

Empowering homebuyers with smart GRID tools

Win the House You Love helps American homebuyers make confident financing decisions 🏠

07. January 2022

What's next for GRID?

In 2022, we're transforming GRID to become the primary tool of choice for modern teams working with numbers.

04. November 2021

Introducing Conversations: a new way to explore & explain data

Now we’re really talking. We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication...

30. September 2021

Build a price quote calculator in 5 easy steps 

Embed interactive features like calculators on a website, and voilà! They become super-engaging conversion rate boosters 🚀

21. October 2017

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

The world has a love/hate relationship with spreadsheets.