Google Sheets has a maximum of 5 million cells. However, most users don’t hit this size limit. Excel workbooks do not have a data limit.

If you do reach the Google Sheets limit, you can create a new sheet and cut/paste some of your older Transactions or Balance History rows into this new sheet to shrink the size of your active Tiller Sheet. 

Using the Size My Sheet Google Sheets Add-on to check sheet size

If you're concerned that your Google Sheet might fill up because you've been using Tiller for a while, or you're using advanced queries, reporting, and functions you can install our Size My Sheet Google Sheets Add-on to monitor your sheet's size.

Click here to visit the Add-on listing in the Google Sheets Add-on Store

Giving the add-on permission

The Size My Sheet add-on requires two permissions to run. Google Sheets add-ons don’t provide a lot of detail about these permission requests, but the access is very straightforward. The add-on itself is asking permission to view your spreadsheets (so it can size them) and to run on its own (so it’s available in your menu bar when you need it).

The add-on does not store any data about the content of your spreadsheet, nor does it share any of your spreadsheet data with Tiller. Google tells us how many people install this add-on and the number of weekly users, and that’s the limit of the information we see about how or where it’s used. We’ve also made the source code available on GitHub.

Did this answer your question?