Google Sheet Database

[AntoineM]

Hi

I am new to using App Sheets and I am curious about the maximum database size that can be supported using Sheets. Can you provide some information on this?

I am continuously updating the database as I work. My primary worksheet currently contains approximately 4500 records and is connected to around 15 other worksheets.

[WillowMobileSys]

Maximum size is measured by number of cells in a sheet which is calculated by (# columns * # rows).  The current maximum cells is 10 million.  So if a sheet has an average of 30 columns, it can have 333,000+ rows;  at 50 columns...200,000 rows.

Keep the tables compact.  If you grow to more than 40 columns, its probably time to review if the table should be split.

Another important tool to help with data size is to purge or archive regularly the data that is not needed for daily app use - i.e. historical data that might be looked at only once in a great while.