Docs: Size My Sheet add-on

Spreadsheets gSheets Templates
1

The Size My Sheet add-on allows you to see how close you are to hitting Google Sheets’ 10 million cell limit.

Install the add-on at https://workspace.google.com/marketplace/app/size_my_sheet/391759237464

After install you can launch the add-on via the Extensions menu to view a gauge in the sidebar.

The Size My Sheet add-on also allows you to insert a function within your sheet to retrieve the number of cells used or the percent used of the cell maximum that Google has set. It’s useful if you’d like to see these numbers in cells on the sheet rather than using the gauge in the sidebar.

To use this feature simply type one of the functions below into an empty cell of a Google Sheet with the Size My Sheet add-on installed.

Retrieve the number of cells used:
=tillerCellsUsed()

Retrieve the percentage used:
=tillerCellsUsed(“Percent”)

What slows down downloading transactions for Google sheets?
3

Dear Heather,
Thank you so much for your developments, it is important and necessary. Rarely, but usually so unexpectedly happens - oops and not enough space.
Thanks to your development it is now possible to conveniently manage the size of tables.
Google changes dimites from time to time, do you keep track of these fluctuations?

BR,
Oleg

4

Welcome @oleg.romanov - we don’t keep track of when Google changes the limit, no.

5

As an enhancement, can we get the number of cells for each sheet? Right now we get the total and the amount of cells in the largest sheet. If that capability is only done in the function (to save GUI work), that’s fine. Thanks!

6

@ChrisMildebrandt try the sheet that @Mark.S linked in this post. Improving Performance Example I’m using it currently to slim down my sheet going into the new year.

3 Likes
7

Thanks, that’s a great script to have around.

2 Likes
8

Thanks @bentyre1 for sharing that here.:+1:t5:

1 Like