Appsheet Backend Excel File Size Limit

[KEERTHIKA]

Hi All,

I have my appsheet backend as excel stored in my onedrive. My file size have reached a file size limit of 5 mb. Hence my appsheet is not allowing me to enter data in to the app. Is there any way I can increase the file size limit without deleting my previous data in the backend.

[dbaum]

If your file comprises multiple sheets, try splitting it into multiple files.

[KEERTHIKA]

Actually my spreadsheet has only one sheet my data entries in a day is more. For example, From Jan 2023 to Mar 2023 the sheet has reached 7000 rows hence my file size is showing more than 5 MB. So any way I can sort this out

[dbaum]

The error in your photo says the payload size limit is imposed by Excel, not AppSheet. So, you need to find some way to reduce the volume of data that AppSheet requests from Excel. One appropriate technique might be to use a security filter for the table. Another might be to split your data across tables--e.g., maybe a main table comprising full data only for recent rows, an index table comprising minimal data for all rows, and an archive table comprising full data for older rows, and then use techniques in that app to limit the rows loaded from the archive table, such as automations to move rows between the main table and archive table or, again, a security filter like a constrained date range that the user can adjust.

You could also investigate whether a different data source host has a more lenient payload size maximum.

[KEERTHIKA]

Hi can you show me an example if possible

[Marc_Dillon]

Switch to Google Sheets.

[KEERTHIKA]

It will not have that issue?

[Marc_Dillon]

Doubt it.

Using Excel with Appsheet instead of GSheet is like shooting yourself in the foot.

[KEERTHIKA]

Let me try with google sheets also