# Help needed to change the Database **URL:** \ **Category:** Ask for Help\ **Created:** [May 7, 2024, 4:45pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161 "2024-05-07T16:45:40Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 7, 2024, 4:45pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/1 "2024-05-07T16:45:40Z")
Hi Everyone, I was wondering to get help regarding the database, I wanted to change the DB from excel to glide tables, however the system does not allow me to do so, is there anyway to do it? I have changed individual tables however Users table does not get supported with this action. Thanks ---
**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:** [May 7, 2024, 4:48pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/2 "2024-05-07T16:48:00Z")
I’ve never used Excel with Glide, but I have read that if you duplicate an App that uses Excel as a data source, then all tables are automatically converted to native tables. So give that a try. When duplicating, I’d guess that you’ll probably need to choose the “Copy the sheet” option. ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 7, 2024, 5:15pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/3 "2024-05-07T17:15:00Z")
Yeah, but in such a case the master file still remains the excel. ---
**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:** [May 7, 2024, 5:32pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/4 "2024-05-07T17:32:01Z")
> [@Darren\_Murphy](#): > > duplicate an App that uses Excel as a data source, then all tables are automatically converted to native tables. @Abhinav_Hans Key point right here. Excel is a bit unique. If you duplicate an app and data that uses Excel as a data source, it creates copies of the tables as Glide tables. At least that’s been the case in the past. Have you tried it? ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 7, 2024, 7:03pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/5 "2024-05-07T19:03:59Z")
Yes, I have tried the same but the main DB file still remains the same as excel rest all are changed to glide tables, due to which I need to make users table in excel sheet. ---
**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:** [May 7, 2024, 7:48pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/6 "2024-05-07T19:48:04Z")
Hmm, @David_Gabler would you have any thoughts on this since you have experience with Excel? ---
**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 7, 2024, 8:17pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/7 "2024-05-07T20:17:18Z")
> [@Abhinav\_Hans](#): > > main DB file still remains the same as excel In my experience, if you duplicate the app, and copy the table it becomes a glide table not excel. I will have to try it again when I at my computer, it’s been a while. ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 7, 2024, 8:49pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/8 "2024-05-07T20:49:58Z")
Thanks guys, much appreciated. ---
**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, 2024, 4:52pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/9 "2024-05-08T16:52:35Z")
Well, here I am at a standstill, because the only App I have using an Excel is a “Classic App”, and they can no longer be duplicated. So if your App is Classic, you cannot duplicate it anyway. ---
**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, 2024, 4:56pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/10 "2024-05-08T16:56:34Z")
Well, I chose the option “create new app from source” and chose “keep the same sheet” so I would end up with an new App using Excel. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ecbc546c49decfc6dd252986bed91cecb24e2424.png) Then I duplicated that App, and all the tables became Native Tables. So, yes it still works like that. I wish we could just have a “Duplicate Table in Native Format” selection on a right click. It should be noted also that none of the features of the Classic App are duplicated, and you will have to rebuild. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf322de976e2ce9c3fb42512cf1a991384a18d61.png) ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 9, 2024, 1:50pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/11 "2024-05-09T13:50:22Z")
oh thank you so much David, I have one doubt in this, my app is entirely in glide table, only the user DB is excel and master sheet, will this trick works for such a case as well. ---
**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 9, 2024, 2:26pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/12 "2024-05-09T14:26:41Z")
If your app is a classic app I wouldn’t. If it’s a new app then yes it will work flawlessly. ---
**Author:** ![Abhinav\_Hans](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Abhinav\_Hans](https://community.glideapps.com/u/Abhinav_Hans)\ **Post date:** [May 9, 2024, 2:29pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/13 "2024-05-09T14:29:30Z")
okay that makes sense, thank you David for the help. ---
**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 16, 2024, 2:30pm UTC](https://community.glideapps.com/t/help-needed-to-change-the-database/73161/14 "2024-05-16T14:30:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.