---
title: "Times/dates incorrect in Excel data export"
slug: "i-export-data-to-excel-but-the-times-dates-come-out-wrong"
updated: 2025-09-08T12:38:37Z
published: 2025-09-08T12:38:37Z
canonical: "support.controlup.com/i-export-data-to-excel-but-the-times-dates-come-out-wrong"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.controlup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Times/dates incorrect in Excel data export

## Issue
You export data from Insights to CSV but the times are wrong:
![logon and logoff timestamps](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/en-usarticleattachments204286689InsighstimesbeforeexporttoCSV.png)

![logon and logoff timestamps wrong](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/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.
:::(Info) (**Note:**)
The times/dates are UTC, so make sure to change and add or subtract the hours according to your location.
:::
![Format Cells option selected](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/en-usarticleattachments2042867092016-05-080940.png)

Format Cells:  
![Format Cells popup](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/en-usarticleattachments2043198352016-05-080940001.png)

Result:
![logon and logoff timestamps](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/en-usarticleattachments2043198252016-05-080940002.png)