Maximum number of people who can simultaneously view a public Google Sheet

google sheets

I want to publicly share a link to a Google Sheet for viewing only (not editing). Is there a maximum number of people who will be able to view the sheet simultaneously?

This is a Google document on my personal Google Drive that will be shared via a "share link" that allows anyone with the link to view, but not edit it. The data in the sheet is complete and only occasionally will I edit it for changes. It is expected that a few thousand people will be viewing it.

I am aware (as Rubén point out) that: "Up to 100 people with view, edit, or comment permissions can work on a Google Sheet … at the same time."

But only I may be working on the sheet. If 100 people are only viewing it, how would Google even know this? What is to stop 100 more people from going to the same link? It does not seem likely that constant pings are being sent back to Google when a Sheet is on someone's screen.

Viewers of my Google Sheet will only be browsing and scrolling the page. When they first come to the page, they will likely choose a tab for the sheet they need.

In that quote above from Google support, is also: "When more than 100 people are accessing a file, only the owner and some users with editing permissions can edit the file."

So this seems to indicate that YES, more than 100 people can view it, but editing is then limited to just a few.

Best Answer

Yes, there is a limit. From Share files from Google Drive

Share & collaborate on a file with more than 100 people

Up to 100 people with view, edit, or comment permissions can work on a Google Docs, Sheets, or Slides file at the same time. When more than 100 people are accessing a file, only the owner and some users with editing permissions can edit the file.


Sidenotes:

  1. When someone is viewing a Google Workspace (formerly G Suite) Editor document, the user profile photo or an anonymous animal is shown close to the top-right corner. The relevance of this in this context is that someway Google is showing how many users are viewing the document no matter if they are the document owner, editor, commenter or viewer.

    1. In this context document refers to a spreadsheet, document, presentation, drawing, form or script openend using a Goole Worspace Editor.
  2. From the question:

I am aware (as Rubén point out) that: "Up to 100 people with view, edit, or comment permissions can work on a Google Sheet ... at the same time."

But only I may be working on the sheet. If 100 people are only viewing it, how would Google even know this? What is to stop 100 more people from going to the same link? It does not seem likely that constant pings are being sent back to Google when a Sheet is on someone's screen.

While a document from the user point of view is a single file, from the computer point of view it's composed of several computer files. The following screenshot shows on the left a new spreadsheet and on the right the Chrome Developers Tools showing the Sources tab, which is displaying a tree structure of the source files and the HTML from the edit file. Some of these computer files include code that allows the Google computers to interact with each user computer to track on real time how many users have open the spreasheet at certain moment.

  1. Chrome Developers Tools can be opened from the Chrome menu or by pressing F12 . It includes several tools that can be used to see what computer files were downloaded, the newtwork traffic, the structure of the content displayed, called Document Object Model (DOM), among other things. Other web browers have similar features.

From the question

This is a Google document on my personal Google Drive that will be shared via a "share link" that allows anyone with the link to view, but not edit it. The data in the sheet is complete and only occasionally will I edit it for changes. It is expected that a few thousand people will be viewing it

Assuming that your spreadsheet reach more than 100 simultaneos viewers then it's very likely that some of them will get a message saying something like

The resource is not available now. Try again later

Alternatives

  • Publish your spreadsheet to the web
  • Embed your spreasdheet in a web page (it could be a Google Site)
  • Instead of one, use multiple spreadsheets. You could use IMPORTRANGE, Google Apps Script or the Sheets API to propagate the updates from a "master" spreadsheet to the others. The tool be used will depend on your personal preferences, skills as well on the types of changes made.
  • Publish the spreadsheet data to a web page in a website prepared to handle such traffic.

Resources