Report Export - XLSX and CSV Date format


My Excel (version 2013 part of Office 365 Home Premium) doesn’t like your text date format and it can’t convert it into a date.

i.e. it cant read the “Sep 7, 2018” as a date.

I have to convert via a Google Sheet and then paste the column back into Excel.

Granted Excel is the culprit here but you need to accommodate if you’re offering an Excel export option.


Thanks for the feedback, we’ll look into changing it to YYYY-MM-DD.