---
title: "Exporting Your Analytics: Tips and Tricks"
slug: "exporting-your-analytics-tips-and-tricks"
updated: 2025-05-08T22:03:46Z
published: 2025-05-08T22:03:46Z
canonical: "help.dialpad.com/exporting-your-analytics-tips-and-tricks"
---

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

# Exporting Your Analytics: Tips and Tricks

Charting data in the [Analytics menu](/v1/docs/analytics-charting-data) will allow you to [export additional reports](/v1/docs/export-your-analytics-data). This can be an incredibly helpful tool. But sometimes, the information in the exported Excel sheets get a bit... murky. Here are some common troubleshooting tips and tricks.

## Formatting the date and time column correctly when using Excel

Are you using Excel to read your exported analytics and having trouble reading the date/time column?

*![excel_1.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/excel_1.png)*

To format the date/time column in the CSV exports when using Excel do the following steps:

*On the "Home" ribbon go to "Format" and select "Format Cells"*

*![excel_2.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/excel_2.png)*

*Then choose "Date" and select the format highlighted below.*

![excel_3.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/excel_3.png)

  

*Now you will see delightfully human-readable dates and times.*

  

*![excel_4.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/excel_4.png)*

  

## Adjusting the 0 digit in Call ID or Office ID

You've exported data to Excel, but the last digit of the ID columns ("Call ID” or "Office ID") has been replaced with a 0.

What's going on?

The spreadsheet software is applying a number format to the data. Good news — you can prevent this from happening. Here's how:

1. Create a custom number format that has 16 digits.

![Screen_Shot_2021-10-21_at_13.18.28.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/screen_shot_2021-10-21_at_13.png)

![Screen_Shot_2021-10-21_at_13.17.07.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/screen_shot_2021-10-21_at_13(1).png)

1. Select the ID column and apply the new number format to it.

![spreadsheet-demo.png](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/spreadsheet-demo.png)

> [!NOTE]
> Note
> 
> The images above were taken using Google Sheets, but the process and flow is the same for Excel.