I export data to excel but the times/dates come out wrong
- Print
- DarkLight
- PDF
I export data to excel but the times/dates come out wrong
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Issue
You export data from Insights to CSV but the times are wrong:
Reason
Data is exported as RAW data to CSV files and excel displays it as RAW.
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?