I export data to excel but the times/dates come out wrong
    • Dark
      Light
    • PDF

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

    • Dark
      Light
    • PDF

    Article Summary

    Issue

    You export data from Insights to CSV but the times are wrong:
    en-usarticleattachments204286689InsighstimesbeforeexporttoCSV.png

    en-usarticleattachments204286699BadDataCSV.png

    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.

    en-usarticleattachments2042867092016-05-080940.png

    Format Cells -
    en-usarticleattachments2043198352016-05-080940001.png

    The result:
    en-usarticleattachments2043198252016-05-080940002.png


    Was this article helpful?