Excel Integration incorrect date format

  • 12 January 2022
  • 6 replies

I’ve never had issues integrating into excel, but I now the date format is coming in like this and I can’t figure out how to fix it. Please help!


Best answer by john.desborough 14 January 2022, 04:55

View original

6 replies

Userlevel 7
Badge +5

Hi @BeckyCHP Thanks for stopping by! I believe this is expected behavior, though is this the date of the form submission or the date from the date field? 

Hi Liz,

Thank you for the response! It’s a date from the date field. We’ve been using typeform for over a year and I’ve never seen the dates come into excel in that format. It’s always been in this format 1/1/21 and that’s what we really need.

Userlevel 7
Badge +6

@BeckyCHP - it looks the ISO-8601 date representation that Excel announced that they would use about this time last year.. especially in Power Automate flows 

there’s a good blog post on this here at this link

One thing to note is that date fields are collected with a time stamp of midnight (hence the T00:00:00Z) which is UTC time 

you will have to update how  you deal with the date in Excel through formatting.. 





Thank you, I will check out the blog. That’s so strange that this is the first time we’ve run into this and we have multiple forms we’ve been using over the past year.

Userlevel 7
Badge +6

i noticed this on a form after an update by Windows this week… go figure.. lol

not sure myself but.. 

Userlevel 7
Badge +5

Ah, I didn’t know they announced that, @john.desborough . Thank you!