
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 15, 2025 11:39 AM
Hi, I'm facing an Issue with importing data into Airtable.
I have date prepared in Google Sheets which I'm trying to import in 4 diffrent ways: just copying the range (data table) and pasting it, exporting the .csv file and trying to import it, exporting the .xlsx file and trying to import it and also via Google Sheet connection. I have tried diffrent types of date formats in Airtable.
In all cases importing dates appear one day before the date, so that once I have the date (screenshot from Google sheets):
TestDate |
2025-01-15 |
while importing it appears to be (screenshot from Airtable):  
Has anyone faced such issue?
Thanks in advance,
Best regards,
Patryk
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 15, 2025 12:52 PM
Usually copy/pasting dates works fine for me, but my expectation when there's a 1 day difference error is always a timezone issue. Does your Google Sheet data include any time information, even generic time info like everything is just set to 12:00AM? You might also export your Google Sheet as a CSV, and then take a look at the formatting in Excel to standardize.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 15, 2025 05:57 PM - edited ‎Jan 15, 2025 06:02 PM
I've had similar issues with Google Sheets - you can standardize your dates in google sheets under format
if that doesn't solve the issue - you could try importing the date into a plain text field and using a DateParse formula to clean it up
DATETIME_PARSE({Date _ Plain},'MM/DD/YY')
info@consultasolutionist.com

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 05:36 AM
Thank you @DisraeliGears01 @ATSolutionist for you replies and your help. I have checked and the date in .csv format at it does not include time zone, also have checked the date format in Google Sheets:
What I have found out is that while importing in the pop-up importing window it shows wrong date (1 day before) although after importing it shows correct ones. First screenshot shows the dates wthile importing and the other one after import:
Already have send the issue to Airtable team, as this seems to be a bug.
Best regards,
Patryk
