Q: Columns is not recognizing a valid date format??
When I connect my Google Sheets file to Columns, it is not recognizing the date column as a valid Time series. Why is that?? The current format is "05-20-2025". The schema is only seeing it as text. According to the documentation, this is a valid format (UsDateFull: 'M/d/yyyy', 'MM/dd/yyyy').

ShawnCao
May 24, 2025A: We will use support channel to analyze your data and see why DATE is not recognized, based on what you provided, it should.
You are right, that’s a valid date, it should work. But do all values follow the correct format?
Can you share your sheet with me to test? Can send email or live chat.

Verified purchaser
Yes, I can share. Please send me your email address. Thanks
Please click "Email" from this page - https://columns.ai/contact to get in touch through email.