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 \u002205\u002D20\u002D2025\u0022. The schema is only seeing it as text. According to the documentation, this is a valid format (UsDateFull: \u0027M/d/yyyy\u0027, \u0027MM/dd/yyyy\u0027).

You are right, that’s a valid date, it should work. But do all values follow the correct format?\u000a\u000aCan you share your sheet with me to test? Can send email or live chat.

Please click \u0022Email\u0022 from this page \u002D https://columns.ai/contact to get in touch through email.

Columns is not recognizing a valid date format? | Columns

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').

newlifecccPLUSMay 23, 2025

Founder Team