I export data to excel but the times/dates come out wrong

The Issue:


You export data from Insights to CSV but the times are wrong:



The Reason:


Data is exported as RAW data to CSV files and excel displays it as RAW. 


The Solution:


Set the dates in your CSV file by right clicking the column and choosing Format Cells... and then using the Custom or Date category.

Note: the times/dates are UTC, so make sure to change and add or subtract the hours according to your location.



Format Cells - 


The result - 






Powered by Zendesk