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 - 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk