# How to disable time offset on import? **URL:** \ **Category:** Ask for Help\ **Created:** [June 14, 2023, 3:03pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754 "2023-06-14T15:03:44Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Aleksandr\_Sergeev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksandr_sergeev/32/60402_2.png) [@Aleksandr\_Sergeev](https://community.glideapps.com/u/Aleksandr_Sergeev)\ **Post date:** [June 14, 2023, 3:03pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/1 "2023-06-14T15:03:44Z")
Hello. I have a problem with the Glide database. When I import data into the Glide database from Excel, the time in the datetime column is shifted 3 hours back. How to turn it off? I need my exact numbers! The tick of time zones does not help. Thanks in advance for the hint. ---
**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:** [June 14, 2023, 3:05pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/2 "2023-06-14T15:05:36Z")
What does the raw data look like in the Excel sheet, without any formatting in the date column? ---
**Author:** ![Aleksandr\_Sergeev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksandr_sergeev/32/60402_2.png) [@Aleksandr\_Sergeev](https://community.glideapps.com/u/Aleksandr_Sergeev)\ **Post date:** [June 14, 2023, 4:00pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/3 "2023-06-14T16:00:31Z")
Hello! Thanks for answering. 1. screenshot from excel (no formatting) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6489b9bfb1e7b986156c2c8c800051c7a013011.png) 2. screenshot from Glide after importing from Excel ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/812d00f2db855dedefca19fed46612b5c7e2596a.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:** [June 14, 2023, 7:22pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/5 "2023-06-14T19:22:26Z")
I’m not sure what could be happening. I’m guessing it’s basing something off of GMT time if you happen to be 3 hours away from GMT. But, the fact that the minutes are off too seems odd. ---
**Author:** ![Aleksandr\_Sergeev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksandr_sergeev/32/60402_2.png) [@Aleksandr\_Sergeev](https://community.glideapps.com/u/Aleksandr_Sergeev)\ **Post date:** [June 14, 2023, 7:39pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/6 "2023-06-14T19:39:11Z")
When will Glide be able to fix this? My project is suffering. ---
**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:** [June 14, 2023, 11:36pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/7 "2023-06-14T23:36:23Z")
So by importing, you mean that you have imported this to a Glide Table? Did you use a xlsx file or a csv file? ---
**Author:** ![Aleksandr\_Sergeev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksandr_sergeev/32/60402_2.png) [@Aleksandr\_Sergeev](https://community.glideapps.com/u/Aleksandr_Sergeev)\ **Post date:** [June 15, 2023, 3:05pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/8 "2023-06-15T15:05:37Z")
> [@ThinhDinh](#): > > xlsx Yes, I have imported the xlsx file into Glide’s internal database. I do this several times a day. I’m developing a simple claim service. The API has not yet been connected. ---
**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:** [June 15, 2023, 10:55pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/9 "2023-06-15T22:55:17Z")
> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2): > > Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link: I would try submitting a ticket to see if Glide has something to say about it. Is your Glide Table’s datetime column using “respect time zones”? If yes, what happens when you turn that off? ---
**Author:** ![Aleksandr\_Sergeev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksandr_sergeev/32/60402_2.png) [@Aleksandr\_Sergeev](https://community.glideapps.com/u/Aleksandr_Sergeev)\ **Post date:** [June 16, 2023, 11:46am UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/11 "2023-06-16T11:46:43Z")
The tick from time zones is not active BUT I tried it in different ways, to no avail. ---
**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:** [June 16, 2023, 2:07pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/12 "2023-06-16T14:07:31Z")
Well I have nothing more to say. Please submit a ticket so the Glide team can dive deeper into the problem. Thank you. ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [May 19, 2024, 11:40pm UTC](https://community.glideapps.com/t/how-to-disable-time-offset-on-import/62754/13 "2024-05-19T23:40:10Z")
I’ve run into this too - very frustrating! I’m using Google Sheets, not Excel. One workaround I’ve found is to import the date column to a text column in Glide Tables, then edit the column to turn it into a Date & Time column. This prevents the unwanted time zone correction.