--- 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 --- > ## 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.