Contributor

Exporting CSV from Anaplan, incorrect date displays in Excel

When exporting information into Excel by month it brings the dates through as text, ex  “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for this? (January 2019, will export from Jan 19 to 1/19/19 fyi)

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Exporting CSV from Anaplan, incorrect date displays in Excel

Mike,

 

When data is exported to a CSV file from Anaplan, dates are actually being exported.  If these are not showing properly, I would look into your regional settings on your computer.

 

I found this on google for a Mac:  https://resrequest.helpspot.com/index.php?pg=kb.page&id=277

 

I found this on google for Windows: https://www.google.com/search?ei=XHdTXJjyOo7ktQWOlrX4Bg&q=excel+regional+settings+windows+10&oq=exce...

 

Hope this helps and let us know if you are still having this issue.

 

Rob