How close is your spreadsheet to the 10m cell Google Sheet limit? Use this add-on to show how much you’ve used.
Listing updated:May 10, 2022
Works with:
104K+
Overview
Have a lot of data, empty cells, or complex formulas in your Google Sheet? You might notice that your sheet is running slow. This Tiller Community-built add-on can help you figure out how close you are to hitting the 10 million cell limit in your Google Sheets and whether you need to clean up empty cells or reduce the size of your data set, which can cause performance slow downs with Google Sheets. 

This is especially true when you start adding additional Tiller Community-built solutions to help with debt planning, budgeting, savings goals, or tracking your net worth. Plus, multiple years of daily spending transactions and balances from all your bank accounts automated into your Google Sheets from Tiller will eventually start to increase the size of your Google Sheet. 

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”)

Size My Sheet is a solution built and supported by the Tiller Community. Tiller is the fastest, easiest way to manage your financial life with the flexibility of Google Sheets. 
 
That’s because Tiller updates Google Sheets with your latest spending, balances, and transactions from over 21,000 banks each day. No more tedious data entry, CSV files, or logging into multiple accounts. 
 
With Tiller updating your finances in one place, you can always know where your money goes, control your spending and cash flow, save more, and confidently plan your financial future.

The Tiller Community is a vibrant and inclusive space to share with and learn from other Tiller customers and spreadsheet enthusiasts. 
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Size My Sheet will ask for the permissions shown below. Learn more
Size My Sheet will need access to your Google account
This will allow Size My Sheet to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Robert Rigby
January 10, 2024
A godsend. I have important information fed from Google forms and I had no idea how quickly it would get to the limit. This is a superb tool to know when to archive
Is this review helpful?
Yes
No
Profile Picture
James Waller
February 12, 2022
Hello, I have used this Guage for years and it has helped me from losing or accessing sheets that were close to the limit. I just want to let you know that the cell limit is now 10,000,000 and if you could update the add-on to reflect this. Thanks a lot for this, James/mreighties :)
Is this review helpful?
Yes
No
Profile Picture
Michael Arndt
October 27, 2021
Very useful. I wish it could provide a cell count for each worksheet instead of just showing me the biggest one.
Is this review helpful?
Yes
No
Profile Picture
William Gillett
October 18, 2021
Great - just what I needed to track my main banking sheet. Wish there was more flexibility to track usage by tab. But this serves my purposes fine as is.
Is this review helpful?
Yes
No
Profile Picture
Brent Templeton
April 4, 2017
This is simply a great add-in, there is no way to determine how many of the 2M cell limit you have. With Sheets, a cell is used even if it does not have data in it. so deleting extra columns and rows can really help if you need to conserve.
Is this review helpful?
Yes
No
Profile Picture
Dem Oliva
October 1, 2020
How do I resolve the error message "Google Refused to Connect"? I've been using your app for years but now I can't use it. All I get is that error whenever I try to run Size my sheet
Is this review helpful?
Yes
No
Profile Picture
Stanley Levine
March 11, 2021
Wopuld have given this a 5 star rating is it would list the size of each tab and not just the largest!
Is this review helpful?
Yes
No
Profile Picture
A User of Size My Sheet
January 8, 2019
Awesome! Can you update the limit to 5M? currently the add in still shows 2M limit and the graph is based out of that. Thanks!!!
Is this review helpful?
Yes
No
Profile Picture
Mike Webb
June 22, 2017
Exactly what I was looking for. Great Add-on.
Is this review helpful?
Yes
No
Profile Picture
A User of Size My Sheet
January 31, 2018
Solved my problem!! I detected the tab that was using 99% of the 2000000 cells and that WAS HIDDEN!!!
Is this review helpful?
Yes
No
1-10 of 10
Search
Clear search
Close search
Google apps
Main menu