I’m trying to import a spreadsheet with more than a million rows. How do I handle this while using the Appsheet interface? Ideas?

For an app this size, you really need to migrate to a real SQL server. I expect Google Sheets / Excel would run very slow.

fmahmad88: import a spreadsheet with more than a million rows Waw… are you using google sheet?

Yes, lol. I’ve been using a combination of Excel and Google sheets. I heard someone talk about MySQL so curious how people would handle massive databases with streamlined front end. Ideas?

Even on a database 1 million rows will slightly chug unless your table is still small in overall size. Performing any virtual columns beyond the most basic on this table will eat your performance as well.

This may be an old topic and I agree with huge datasets to be using database servers. But there are some exceptions. Hope you can vote for my feature request. Combining Multiple Tables based on Google Sheet as one list/table (Append) Use Case :> A table based on a Google Sheet with less than 15…

Interesting to hear that AppSheet limits GoogleSheets to 100,000 rows. How many columns do you have in your database? My understanding was GoogleSheet was limited to 5,000,000 cells (no row limit). Limitations of Google Sheets (Row/Column/File Size) - Spreadsheet Point I am building an App that wil…

I have 9 columns in my Google Sheet. I’m definitely not anywhere near the 5M cells limit. I’ve also deleted any unused columns and rows. What’s weird is that if I split the sheet into two, I am able import both sheets separately. I just can’t import them together as one sheet. So it can’t possibl…

Agree, it does sound like an Appsheet restriction. I’m wondering if Appsheet does this on purpose to ensure the performance of the app is maintained (especially during sync). I’ve got the same problem where splitting into different worksheets makes it difficult for some users who need access to all …

What I dont understand is why appsheet will not allow me to connect to the one sheet with all the rows, while it allows me to connect two separate sheets, which I assume, will both be part of the sync and shouldnt have any difference in performance. Ive tried both tabs and workbook approach. But wh…

Guess what I just found out. Even if I only have data on 1,000 rows, as long as my Googlesheet have more than 100K rows, even when blank, APPSHEET throws an error. [3X_3_9_3908767086e9064323804bf2682daa61b493b54b.png]

Yep I think you’ve proven it’s an Appsheet restriction. Interesting because a few other posts I read pointed towards a database size limit e.g. MB. What is the performance of your app sync and load times when you have 100,000 rows?

Outgrown 100,000 rows in spreadsheet. How to scale up?

AppSheet AppSheet Q&A

JPAlpano March 23, 2021, 1:55am 16

I haven’t been able to do that. Hence the feature request I submitted.

Topic		Replies	Views
I’ve apparently reached a 100,000 row limit w... AppSheet Q&A	4	19	March 19, 2021
Large Google Sheets AppSheet Q&A ux	2	19	March 19, 2021
[Sheets] exceeds maximum allowed row count of 100k AppSheet Q&A databases	5	85	March 25, 2022

Outgrown 100,000 rows in spreadsheet. How to scale up?

AI Suggested topics