How many Excel tabs can Appsheet handle?

Hi, Im essentially trying to build a super app, meaning all functions of my company in one app.

Meaning, there are currently 15 tabs in my Excel sheet.

Question: How many can AppSheet handle?

Will this affect performance?

Do you have any advice to handle the amount of data?

Cheers

Hi @finkployd

As far as I know, there is no limit about the amount of tabs AppSheet can handle.

However, max rows limit is 100k/table.

I suggest using Security filter in order to restrain the amonut of data load on device.

Also, if you are planning about using SQL databases, you may want to consider using SQL Views as tables for AppSheet.

About affecting performance, there are various factors: size is one of these, calculation is another part. Please find more information here:

App performance: Core concepts - AppSheet Help

Security filters: The Essentials - AppSheet Help

Scale using security filters - AppSheet Help

2 Likes

Thank you Sir

So I can add as many tab sheets as I want correct?

As long as I find ways to improve the amount of data needed to be viewed in a single session for the users?

1 Like

Correct :+1:

1 Like

I am currently at 32 Sheets , Can’t be any smoother its all good no negative impact (for now) .

1 Like

Thats great to hear.

How do u manage all these sheets.

Have u ever forgotten when u wanna make any changes that it affected a lot
of your formulas, related behaviours or expressions?

Im only at 15 and i cant keep track lol

It is a challenge when it comes to that, but with proper documenations in every view / slice / action / help keep things on track , but indeed it happens that you wonder what have you done here and there and why its this way and what does this do for example…

2 Likes

Where does this limit apply? Is it related to Excel? Is it in AppSheet regardless of a table’s data source?

I read that various times, but I’m unable to find where.

I found this:

Limits on tables per application - AppSheet Help

(I think it’s old, I have apps that goes way further)

Limits on data size - AppSheet Help

2 Likes

I’m around 50 and working great.
If performance is your concern, avoid bad virtual column expressions.

Solved: Re: Improving performance by getting rid of unnece… - Google Cloud Community

Solved: Re: Improving performance by getting rid of unnece… - Google Cloud Community

2 Likes

Yes, I recall now too that others have posted comments on that point and even screenshots of an AppSheet error referencing a 100K row maximum. The most recent of those screenshots that I find is from 3/2021 and the most recent comment from 3/2022. I did some rudimentary testing in 8/2022 and didn’t encounter any error except when newly adding a table with >100K rows to an app.

@lizlynch , if AppSheet either does or does not enforce a row count limit when adding a table to an app or when adding a row from an app to an existing table, it would be helpful to explicitly document that in Limits on data size - AppSheet Help.

2 Likes

This is related to GSheets if I recall correctly, not Excel