Help & Support
Send Feedback
Size My Sheet
How close is your spreadsheet to the 5m cell Google Sheet limit? Use this add-on to show how much you’ve used.
172 users
Works with
Install
Overview
Have a lot of data in your Google Sheet? Use a lot of Pivot Tables and QUERY functions to slice and dice it? You've probably hit the 5M cell limit in Google Sheets. Use this simple sidebar utility to see just how close you are to hitting that 5 million cell limit in real time.

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”)
Reviews
Luis Diego Castillo
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!!!
Submit reply
Cancel
Tim Johns
January 30, 2019
Hello Luis - you bet; we just submitted, and hope to see the update published in the next few days.
Douddysilva's account
March 27, 2018
just fab!!
Submit reply
Cancel
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!!!
Submit reply
Cancel
A User of Size My Sheet
June 22, 2017
Exactly what I was looking for. Great Add-on.
Submit reply
Cancel
A User of Size My Sheet
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.
Submit reply
Cancel
1-5 of 5
Additional information
Search
Clear search
Close search
Google apps
Main menu