# šŸ™šŸ™\>25K rows in GT, or external database. So needed! **URL:** \ **Category:** Feature Requests\ **Created:** [February 11, 2021, 1:40am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594 "2021-02-11T01:40:45Z")\ **Posts on this page:** 19\ **Page:** 2
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 4:57pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/21 "2021-02-11T16:57:24Z")
@AymenM thanks for pointing me to that discussion! That thread says Glide wants to provide 100K+ rows in GT. However, everything Iā€™ve read says GT still has a 25K row limit. I would LOVE LOVE LOVE if they expanded it soon! I have a paying customer šŸ’° ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [February 11, 2021, 5:03pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/22 "2021-02-11T17:03:02Z")
Hello back, I can be wrong but based on the mentioned topic it looks like thereā€™s an unlimited amount of rows that you can create : > [@On another topic](https://community.glideapps.com/t/14194/1): > > In particular, with Glide sheets and Row owners youā€™ll be able to have hundreds or thousand of users, who each can own hundreds or thousands of rows. Hope this helps ! šŸ™‚ ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 5:09pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/23 "2021-02-11T17:09:04Z")
@AymenM Iā€™ve heard and read different things as far as what is available now. One clue is there is still the 25K counter now which counts GT rows. Maybe @david could chime in? Question is whether we can have 100K+ rows per user in GT currently, or is that still to come? ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [February 11, 2021, 5:11pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/24 "2021-02-11T17:11:10Z")
If you have the ability, try to add a csv file this will allow you to get an answer quickly. But a [@staff](https://community.glideapps.com/groups/staff) member will confirm ! ---
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [February 11, 2021, 5:18pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/25 "2021-02-11T17:18:23Z")
You cannot import CSV into Glide tables. Also, mentioning ā€˜[@staff](https://community.glideapps.com/groups/staff)ā€™ does not mention the team. > [@Errcomp](#): > > Question is whether we can have 100K+ rows per user in GT currently, or is that still to come? I am wondering about the same thingā€¦ ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 11, 2021, 5:23pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/26 "2021-02-11T17:23:19Z")
@Pablo_books, @AymenM, @Lucas_Pires, @SantiagoPerez, @Yasin_Hassanien, @DareSteps, @Darren_Murphy Thanks for contributing to the discussion and the help! Please consider an upvote if you havenā€™t already. I think this would help us all out tremendously. šŸ¤© ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [February 11, 2021, 5:43pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/27 "2021-02-11T17:43:04Z")
Iā€™d like to, but I cannot for a while šŸ™„ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/9/89a2d1b370574700ba0afcaa571fbe86faa80bd6.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2021, 5:57am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/28 "2021-02-14T05:57:16Z")
Iā€™ve tested well above 25k rows but with very simple data. I donā€™t think itā€™s a strongly enforced limit by Glide. At least not that Iā€™m aware of. I canā€™t vouch for the limits that you want to push it with almost 1M rows per year. If anything, youā€™ll have more of an issue if you are trying to sync thousands of rows of data on to each userā€™s device each time they open the app. ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 14, 2021, 4:53pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/29 "2021-02-14T16:53:22Z")
@Jeff_Hager Thats interesting. Maybe that bottleneck would be fixed along with rolling out 100K+ rows per userā€¦but we shall see šŸ™‚ ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [February 14, 2021, 5:20pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/30 "2021-02-14T17:20:38Z")
@Drearystate , do you have a method to use virtually limitless rows? I need it too, I still have to study what you sent me to understand how to use it ^^ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [February 15, 2021, 5:32pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/31 "2021-02-15T17:32:13Z")
You list your database in another workbook all together. Then you use vlookup to pull the data. you can use the importrange function directly in the vlookup or set it separately. I recently started using the importrange function directly in the vlookup to save time. It looks like this: ``` =VLOOKUP(A1,(IMPORTRANGE( "sheet url here", SHEET1!A1:B10)), 2, FALSE)) ``` You can do the same with with an arrayformula just widen the range and add the function at the beginning like this: ``` =ARRAYFORMULA(VLOOKUP(A1:A,(IMPORTRANGE("sheet url here", SHEET1!A1:B10)), 2, FALSE)) ``` I hope that helps you better. ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 15, 2021, 5:38pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/32 "2021-02-15T17:38:11Z")
@Drearystate We reached the limit of simultaneous entries on google sheets, and need to scale to even more users. I guess the technical term is ā€œcapacityā€ā€¦we need more capacity. GT actually handles that part like a champ. Now just trying to see if we can run calculations in GT like in Google Sheets šŸ§ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [February 15, 2021, 5:39pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/33 "2021-02-15T17:39:39Z")
You can now, it might take more than 1 column to do so but Glide has come a long way since I had to begin importing data to save space. You still are limited to rows though and that still pertains to Glide Sheet rows I believe. ---
**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\ **Post date:** [February 20, 2023, 9:32pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/34 "2023-02-20T21:32:43Z")
> [@Drearystate](#): > > `=VLOOKUP(A1,(IMPORTRANGE( "sheet url here", SHEET1!A1:B10)), 2, FALSE))` Curious if we can do this for Users sheetā€¦ as it would reduce the number of users to just the number of signed in usersā€¦ wild idea but have you tried that by chance? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 21, 2023, 2:31am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/35 "2023-02-21T02:31:18Z")
How would you expect that to work? I mean, what would the process flow look like? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 21, 2023, 6:06am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/36 "2023-02-21T06:06:44Z")
šŸ˜‰ ā€¦ hmmmā€¦ If I remember wellā€¦ you are my Long time ago customer @Blue_Community, just email me, and ill make it for you. ---
**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\ **Post date:** [February 21, 2023, 5:19pm UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/37 "2023-02-21T17:19:54Z")
will do buddyā€¦ thanks for reaching outā€¦ ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [May 15, 2024, 12:31am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/38 "2024-05-15T00:31:37Z")
Shipped. Big Tables supports tens of millions of rows, and we also support SQL now. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 22, 2024, 12:31am UTC](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594/39 "2024-05-22T00:31:54Z")
Closed on May 22, 2024, 12:31am UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/25k-rows-in-gt-or-external-database-so-needed/22594.md?page=1)