# Migrating data to Glide Tables and deleting the Google sheet connection

**URL:** <https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749>\
**Category:** Ask for Help\
**Created:** [May 8, 2022, 9:50am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749 "2022-05-08T09:50:20Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![EdwardChechique](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edwardchechique/32/30805_2.png) [@EdwardChechique](https://community.glideapps.com/u/EdwardChechique)\
**Post date:** [May 8, 2022, 9:50am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/1 "2022-05-08T09:50:20Z")

</div>

Hello Gliders,

Last week, Glide emailed me and said that need to move the information I have in my template ([Restaurant Menu Multilingual](https://www.glideapps.com/templates/restaurant-menu-multilingual-s2)) from Google sheets to Glide Tables.

I copied all the information to Glide Tables, but now I want to delete all the connections between the Google sheets and my app, how I can do it?

I add an Image.

Thank you!

 ![Frame 273 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00ed6797da31b2dada445be8837519df8e39c3c4.png)

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [May 8, 2022, 1:13pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/2 "2022-05-08T13:13:43Z")

</div>

Currently, there is no way to remove a Google Sheet reference. The best you can do is go to your App’s data settings and point to a different empty Google Sheet.

There is currently a feature request to convert Sheets to Glide Tables, and that would also preserve your settings to your individual screens and tabs. Vote for it here:

> [@Convert existing Sheets-based tab (data, computed columns) to Glide Table](https://community.glideapps.com/t/convert-existing-sheets-based-tab-data-computed-columns-to-glide-table/22183):
>
> Hi, As mentioned before that I started to see a good side of using Glide Tables instead of using Google Sheets in some cases, like some tables might be updated rapidly in real use. But this hunch always came a bit late; After a while of putting up so many relations & lookups & data templates, then I realized that this sheet might have less problem if I changed to Glide Table. But this means a do-over with all the table setups, not to mention all data links on the interface will be cut-off whic…

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [May 8, 2022, 1:52pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/3 "2022-05-08T13:52:15Z")

</div>

So you’ve already manually transferred all the data to glide tables, right? Now you can just create a new draft with no GSheet connection and link existing glide tables to it.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 8, 2022, 4:08pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/4 "2022-05-08T16:08:34Z")

</div>

@11183 except you lose all your computed columns when linking tables.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [May 8, 2022, 4:52pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/5 "2022-05-08T16:52:19Z")

</div>

Of course, sorry, didn’t mention that

---

<div class="post-metadata">

**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:** [May 9, 2022, 12:03am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/6 "2022-05-09T00:03:33Z")

</div>

> [@David\_Gabler](#):
>
> Currently, there is no way to remove a Google Sheet reference. The best you can do is go to your App’s data settings and point to a different empty Google Sheet.

Seems like the team is looking into the option to completely remove Google Sheets, since it directly relates to their requirement to have exclusively Glide Tables in templates.

---

<div class="post-metadata">

**Author:** ![EdwardChechique](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edwardchechique/32/30805_2.png) [@EdwardChechique](https://community.glideapps.com/u/EdwardChechique)\
**Post date:** [May 9, 2022, 7:06pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/7 "2022-05-09T19:06:21Z")

</div>

Hello all,

Thanks for your responses,

I spoke with Glide’s customer service today.  
For now, it is not possible to eliminate the connection between Google Sheets and Glide, but they will soon add this feature, so we will be able to do it.

---

<div class="post-metadata">

**Author:** ![osxzxso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/osxzxso/32/7356_2.png) [@osxzxso](https://community.glideapps.com/u/osxzxso)\
**Post date:** [August 19, 2022, 5:17am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/8 "2022-08-19T05:17:46Z")

</div>

Any update on this, for one of my templates, I just migrated my Google Sheets data to Glide Tables, and reconfigured all of the tabs and screens. But it won’t allow me to delete the Google Sheet references and break the connection in order to Submit to store.

 ![Screenshot 2022-08-19 001636](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bbb90366bcb52b0ed7875f50197abdd1c763e3e.png)

![Screenshot 2022-08-19 001708](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f465ac662a720d28e00bd3d45c9980b9ecc0140.png)

---

<div class="post-metadata">

**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 19, 2022, 11:59am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/9 "2022-08-19T11:59:10Z")

</div>

Have you tried this?

 ![Screenshot_20220819-065829-426](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3d4498d16fa0e1b43ccdd16b3459c87f55de0bb.png)

---

<div class="post-metadata">

**Author:** ![osxzxso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/osxzxso/32/7356_2.png) [@osxzxso](https://community.glideapps.com/u/osxzxso)\
**Post date:** [August 19, 2022, 3:37pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/10 "2022-08-19T15:37:32Z")

</div>

@Jeff_Hager I’m a bit confused, am I supposed to be editing the template itself (which is under the Templates category)?

 ![Screenshot 2022-08-19 103613](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cfb813352a8a058f57bb566ecab9c70ff6c51177.png)

If so, that setting is not there.

 ![Screenshot 2022-08-19 103709](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ecc6099602143e33c74bfe21bdb82607cde212b5.png)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [August 19, 2022, 3:57pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/11 "2022-08-19T15:57:28Z")

</div>

I’ve never been in the situation where I had submitted a template based on Google Sheets and the template needed to be adjusted to being based on Glide Tables (this is now the case).

Within the template, you seem to not be able to remove Google Sheets as the source, even though none of the GS spreadsheets are used. Maybe that is enough for Glide and you can leave it at that.

If it were me and if I wanted to make sure my template were 100% clean, I would rebuild on Glide Tables exclusively and re-submit the template.

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [August 19, 2022, 4:00pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/12 "2022-08-19T16:00:49Z")

</div>

I remember: you cannot publish as template which has made from template.  
Or I’m wrong?

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [August 19, 2022, 4:17pm UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/13 "2022-08-19T16:17:54Z")

</div>

I believe this is correct. You cannot create a project from an existing template, change it, and then resubmit as a template.

To submit your project as a template, you would have to

- build your project from scratch
- based on Glide Tables only
- not use any HTML/CSS
- not use any 3rd party tools or integrations (APIs, webhooks, Zapier)
- not use any of the code computed columns (external code, JavaScript, maybe Excel formulas but I am uncertain about this last one)
- make sure the template would work immediately once adopted
- and then you could submit your project as a template.

Basically, to be submitted as a template your project needs to have been developed purely and solely within the Glide ecosystem 100% with nocode (Glide builder of course, Glide Tables only).

---

<div class="post-metadata">

**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 20, 2022, 12:22am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/14 "2022-08-20T00:22:58Z")

</div>

Any ideas on this @Robert_Petitto ?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 20, 2022, 2:09am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/15 "2022-08-20T02:09:20Z")

</div>

It’s been a while since I’ve submitted a template. I’m about to redo one of my templates in Glide Tables. I’ll get back to you!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 20, 2022, 2:13am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/16 "2022-08-20T02:13:23Z")

</div>

Ya…that’s a shame. It looks like I’ll need to create the app from scratch?! Only alternative I can see is to create it in the main team folder, then transfer it back to My Templates:  
 ![CleanShot 2022-08-19 at 22.12.39@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf7efbc3622e10ef6b078421ac40172bd6fd8da5.png)

---

<div class="post-metadata">

**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 20, 2022, 2:41am UTC](https://community.glideapps.com/t/migrating-data-to-glide-tables-and-deleting-the-google-sheet-connection/41749/17 "2022-08-20T02:41:54Z")

</div>

Shame, maybe @Christian_G can help?
