AppSheet is meant for mobile apps that are designed to work seamlessly despite intermittent connectivity or completely offline. As a result, all data used by the app must be cached locally on the mobile device. This is an important factor to consider when designing your app.
Ideally, you should make your data set as small as possible to achieve the desired functionality.
Do not build an AppSheet app against a huge data set. What is "huge"? For an AppSheet app, the compressed data size limit is 5MB or 10MB (depending on the device) for all the data in one app. It is difficult to translate this accurately into a specific number of rows or columns because compressed data size depends on how much repetition there is in the data. For example, a large spreadsheet with a lot of empty cells will probably compress better than a smaller spreadsheet with no empty cells. In general, the fewer cells in the sheet, the better.
In the future, we may increase the 5MB/10MB limit.
"External" data like images and documents are not included in this data size limit. You can definitely have applications with many rows and an image in every row. Images and documents are not cached locally on the device by default. If you do enable the option to cache images for offline access, they are stored in a different location on the device that does not have the same size limitations.
Limits on the Spreadsheet
Each spreadsheet provider has their own limitations based on performance, file size, number of formulas and calculations. Please keep this in mind as you build your app. If you've ever worked in an Excel spreadsheet that uses all the processors in your PC and takes over a minute to refresh because of formulas, then you should expect a similar behavior in your app if it's connected to that spreadsheet.
If you want to know the limitations by provider, please check the links below:
- Google Drive: Files you can store in Google Drive
- Excel and Office 365: Excel specifications and limits
- Smartsheet: Sheet and file size limitations
- Box: What is the maximum file size I can upload? *
- Dropbox: Is there a limit or maximum to how big my files can be? *
*Excel limitations apply across all cloud providers when you use an Excel file to build your app.
In practice today, this is not a meaningful limit, because system performance degrades well before you reach the limit. This happens for three reasons:
- Slow iterative development-- the data set is checked repeatedly during app development to ensure that the app is consistent with the data
- Long sync times-- when data is synchronized between the device and the backend, the delay depends on the size of the data set.
- Sluggish app behavior-- large data sets can make the app itself sluggish in its interactions like scrolling, search, etc.
Always check if your sheets have empty rows in them. In particular, some sheets have hundreds of empty rows at the bottom. Removing these rows will improve performance.
If you use multiple sheets in your app, consider making them worksheets within the same spreadsheet file.
If your spreadsheet files have many extra worksheets that are not being used by the app at all, try to remove them. Removing extra worksheets will improve performance.
In some circumstances though, the underlying dataset is large and just cannot be changed. If so, you can use a Security Filter to limit the data sent to the client device.
It is often the case that even if an app requires large data sets, much of the data is read-only. In this situation, you can improve some aspects of app performance by separating the read-only data sets into a separate table or tables from those that are writeable/updateable.