# Substitute a Google Sheet with a Glide Table **URL:** \ **Category:** Ask for Help\ **Created:** [October 7, 2020, 9:38am UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869 "2020-10-07T09:38:26Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)\ **Post date:** [October 7, 2020, 9:38am UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/1 "2020-10-07T09:38:26Z")
Suppose I create a Glide Table as an identical copy of a Google Sheet - the same name, the same column names etc. If I delete the Google Sheet, and stick with the newly created Glide Table , will everything work correctly - controls, filters, conditions etc?? Thank you. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 7, 2020, 10:20am UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/2 "2020-10-07T10:20:40Z")
It must be noted before going into this that you can not simply create an identical copy with a push of a button yet. You have to manually enter every row of your Google Sheet. Assuming you don’t use any functions in GSheets that Glide hasn’t offered yet, everything else will be fine. ---
**Author:** ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)\ **Post date:** [October 7, 2020, 10:23am UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/3 "2020-10-07T10:23:59Z")
Not with a push of a button! 🙂 Don’t use any functions in the sheet but a whole lot of filters and conditions in the app. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 7, 2020, 10:35am UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/4 "2020-10-07T10:35:51Z")
Can’t wait until they support importing CSV so I can start migrating to Glide Tables, as of now it’s borderline impossible if you have a big dataset. > [@Glide table - full app building summary](https://community.glideapps.com/t/glide-table-full-app-building-summary/16695/): > > Hi Gliders, So, for the launch of the new glide tables, I’ve decided to take a challenge and build a complete full complex app based on glide abilities only, i.e. not using the GS abilities at all and in fact, if possible I could have built the app without connecting a GS altogether. According to the glide team this will be possible in the future. The app I decided to build was an app that manages, tracks and measures the working time for customer per customer and project. I chose this due to … You can check the excellent thread above bi Yinon to understand more about the feature, as of now. ---
**Author:** ![ChaseFlorell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chaseflorell/32/30932_2.png) [@ChaseFlorell](https://community.glideapps.com/u/ChaseFlorell)\ **Post date:** [August 27, 2021, 5:40pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/5 "2021-08-27T17:40:56Z")
This thread was posted nearly a year ago, I’m wondering if any further details have been released by Glide as to how easy it will be to migrate from a GSheet to a Glide Table? I launched a simple Glide App on Wednesday, and as of today I have 18,000 users… each taking up a row, and I’m getting super close to my 25,000 limit (yes I know there’s no hard enforcement). I’m concerned about performance if it get’s too much bigger, and in hindsight, I should have used a Glide Table from the beginning. Is it yet possible to migrate my GSheet to a Glide Table, and retain all of my custom column definitions, relationships, and data? ---
**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:** [August 27, 2021, 5:54pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/6 "2021-08-27T17:54:38Z")
There’s not an easy way to migrate. Some people have set up inline lists with custom actions that will add a row to a different table and then set a boolean in the original sheet and then filter that row from the list after the boolean is set. This would allow you to tap on each row to have it added to another table. The only problem is that having 18,000 rows means a lot of tapping. You could instead build a flow or action that would add the row to a new table whenever the user performs an action, so essentially your users are doing all of the work for you. It may take a few days and it all depends on the user actually using the app and performing a certain action. Neither are ideal, but it’s really the only option. The only problems with the above method would be if something changes in that user table. It would be hard to keep two tables synced up while you are migrating unless you prevent access temporarily. Short story, no there is no quick native method to migrate from a sheet to a table, but it is possible with some extra work using the above methods. ---
**Author:** ![ChaseFlorell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chaseflorell/32/30932_2.png) [@ChaseFlorell](https://community.glideapps.com/u/ChaseFlorell)\ **Post date:** [August 27, 2021, 6:02pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/7 "2021-08-27T18:02:40Z")
I tried adding Glide Tables last night for new functionality, but as soon as I added the table, it immediately disappeared. ---
**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:** [August 27, 2021, 6:06pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/8 "2021-08-27T18:06:45Z")
Have you refreshed the browser after adding the table? That shouldn’t happen. I added tables to an app a couple of days ago without any issues. ---
**Author:** ![ChaseFlorell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chaseflorell/32/30932_2.png) [@ChaseFlorell](https://community.glideapps.com/u/ChaseFlorell)\ **Post date:** [August 27, 2021, 6:07pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/9 "2021-08-27T18:07:36Z")
I’ll try again, maybe there was a glitch in the matrix. What kind of limits do we have with Glide Tables over GSheets? How’s the performance? ---
**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:** [August 27, 2021, 6:14pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/10 "2021-08-27T18:14:23Z")
Obviously you won’t have any google sheet specific functionality in a Glide Table. Other than that, there’s really no difference. As far as I see it, google sheets are still synced and stored on glide as a sort of glide table. The only thing you are eliminating is the extra step and overhead of the glide server having to sync that data between itself and google. The app is still communicating only with the glide servers and updating data on the glide servers. The the glide server then syncs it’s version of the data with the google version of the data. It’s that sync between glide and google that can start to bottleneck if you have a lot of data. As far as I’m concerned, the published app has zero knowledge that there is even a google sheet ever involved. ---
**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:** [August 27, 2021, 7:51pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/11 "2021-08-27T19:51:03Z")
will this help? [Is Data from Glide Tables sync to Google sheets? - #7 by Uzo](https://community.glideapps.com/t/is-data-from-glide-tables-sync-to-google-sheets/23403/7) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [August 27, 2021, 8:03pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/12 "2021-08-27T20:03:35Z")
You might wanna see this [post](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008) by @Krivo. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 27, 2021, 10:26pm UTC](https://community.glideapps.com/t/substitute-a-google-sheet-with-a-glide-table/16869/13 "2021-08-27T22:26:44Z")
Said it before and will say it again here, that post from Krivo saved me a lot of time. Best choice until we have a native way to upload CSVs.