# Change Data Source **URL:** \ **Category:** Ask for Help\ **Created:** [November 11, 2021, 3:59pm UTC](https://community.glideapps.com/t/change-data-source/34400 "2021-11-11T15:59:02Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Alex\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_sloan/32/34354_2.png) [@Alex\_Sloan](https://community.glideapps.com/u/Alex_Sloan)\ **Post date:** [November 11, 2021, 3:59pm UTC](https://community.glideapps.com/t/change-data-source/34400/1 "2021-11-11T15:59:02Z")
Hi there. I have a fairly complex google sheet that I use for budget and financial tracking. I’d like to use the “Personal Budget Tracker” template, but when I copy the template I don’t see where to change the data source to an existing google sheet. Does anyone know how to change the source? ---
**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:** [November 11, 2021, 4:02pm UTC](https://community.glideapps.com/t/change-data-source/34400/2 "2021-11-11T16:02:10Z")
Hola @Alex_Sloan Welcome to the community!! Take a look at the picture ![Screen Shot 2021-11-11 at 10.00.37 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e5c7b241af49e5f5755662d820af1149dfffb42.png) ---
**Author:** ![Darren\_Alderman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_alderman/32/66660_2.png) [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)\ **Post date:** [November 15, 2021, 3:55pm UTC](https://community.glideapps.com/t/change-data-source/34400/3 "2021-11-15T15:55:25Z")
I didn’t know you could do this… 😍 ---
**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:** [November 15, 2021, 4:06pm UTC](https://community.glideapps.com/t/change-data-source/34400/4 "2021-11-15T16:06:01Z")
You should take care when doing that, as your spreadsheet most likely won’t be directly compatible with the template, and as a result a lot of the template functionality will most likely break. I’d recommend first studying the spreadsheet that came with the template and compare it to your own. The two key things to look at are the sheet names and column names. Glide components are directly mapped to sheet/column names, and if they disappear then the components will break. ---
**Author:** ![RonDePasquale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rondepasquale/32/53977_2.png) [@RonDePasquale](https://community.glideapps.com/u/RonDePasquale)\ **Post date:** [October 11, 2022, 9:39pm UTC](https://community.glideapps.com/t/change-data-source/34400/5 "2022-10-11T21:39:22Z")
If you do this with a different sheet that has exactly the same schema, will you need to recreate all the screens, automations, etc? Or will it just use the same field names and such from the new sheet? I’m using AirTable right now and it doesn’t look like there is a way to copy an app and have the copy use a new base. I like Glide Tables but prefer outside data sources for automations and automatic backups of the data with change logs. ---
**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:** [October 11, 2022, 9:52pm UTC](https://community.glideapps.com/t/change-data-source/34400/6 "2022-10-11T21:52:51Z")
I’m not sure about Airtable, since I don’t use it. I think the ability to change out a data source is exclusive to google sheets, but if you do try it, I would suggest duplicating your app first, and try it on that duplicate to make sure it works. I believe if everything matches up, it should retain all of the screens and actions. ---
**Author:** ![Redgate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redgate/32/58869_2.png) [@Redgate](https://community.glideapps.com/u/Redgate)\ **Post date:** [May 10, 2023, 10:09am UTC](https://community.glideapps.com/t/change-data-source/34400/7 "2023-05-10T10:09:29Z")
…Has this option since been removed ? I’m looking to replace the data source (and excel sheet) but I dont see that option. I appreciate the issues with schema etc - so I wondered if they had to abandon this ? Thanks, Jason. ---
**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 10, 2023, 11:39pm UTC](https://community.glideapps.com/t/change-data-source/34400/8 "2023-05-10T23:39:19Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b991e5508d570583d33b2c877c934cac1e43a64a.png) Are these options available for you when you navigate to Settings \> Data? ---
**Author:** ![Redgate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redgate/32/58869_2.png) [@Redgate](https://community.glideapps.com/u/Redgate)\ **Post date:** [May 11, 2023, 1:29pm UTC](https://community.glideapps.com/t/change-data-source/34400/9 "2023-05-11T13:29:27Z")
thanks for coming back ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/6234bfe112d25f8ac41c02fc4b1d0df5f671bc36.jpeg) I have excel hosted on one drive. this is what it I see ---
**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 12, 2023, 12:06am UTC](https://community.glideapps.com/t/change-data-source/34400/10 "2023-05-12T00:06:16Z")
Yeah that’s a different data source (Google Sheets vs Excel). I don’t have any personal projects with Excel, do you have any insights on this @eltintero ? ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [May 12, 2023, 12:20am UTC](https://community.glideapps.com/t/change-data-source/34400/11 "2023-05-12T00:20:04Z")
Negative. Can’t be done with excel. Actually had the same issue recently and confirmed this with engineering