---
title: "Format Call Detail Records (CDR) for Europe Format in Analytics for 8x8 Work"
slug: "format-call-detail-records-cdr-for-europe-format-in-analytics-for-8x8-work"
updated: 2026-05-17T17:33:42Z
published: 2026-05-21T21:26:29Z
canonical: "help.8x8.com/format-call-detail-records-cdr-for-europe-format-in-analytics-for-8x8-work"
stale: true
---

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

# Format Call Detail Records (CDR) for Europe Format in Analytics for 8x8 Work

## Objective

Format the date ranges from M/D/Y To D/M/Y from Analytics for 8x8 Work in an Excel spreadsheet.

## Applies To

- Analytics for 8x8 Work

## Procedure

1. Log in to Analytics for 8x8 Work.
2. From the left panel highlight Call Report, then select Call Detail Records.
3. Set the time and date range required.
4. Set the View to Call Legs simplified. If this is not selected then the report will not include calls that will pass through the ring group as it will only focus on the destination.
5. Select Download.
6. Open the downloaded Excel spreadsheet.
7. Select the top of the column with the Date data you want to change. ![clipboard_e2d5ab9796ba7bd554eb654a018679448.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1488)
8. Copy this data.
9. Open a new tab. ![clipboard_ea92f59b91526aa955bd3a6bf41c55d7a.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1494)
10. Paste the Data in the first column (A). ![clipboard_e8000b4daf2f581b335163f03cb1b448e.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1492)
11. Highlight Column A.
12. Select **Data** and then **Text to Columns**. This opens a new window. ![clipboard_e29fd9aec300379d3b2875c6f34f2d60c.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1491)
13. Select **Delimited** and then **Next**. ![clipboard_ef8ee5f97b86a13d0db8c58ab978c4f0a.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1493)
14. Under *Delimiters* only select **Space** and then **Next**. ![clipboard_e499a92cc88e8ae76e3679739f4387124.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1489)
15. Under *Column Data Format* only select **Date** and from the dropdown change from **D/M/Y** to **M/D/Y**. (This is to get it to swap what it currently thinks is D/M/Y.)
16. Select **Finish**. ![clipboard_e1db468ce0a47383dfd6ff0528eb3f8c4.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1490)
17. Here you can see the old and new data formats. ![clipboard_ee46907da36196636850af489a6fcfe93.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1496)
18. Select the top of column A.
19. Copy this data.
20. Open the original tab. ![clipboard_e9539334125d0cb5d0e66b31468d94e95.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1487)
21. Select the top of the column with the Date data you what to change.
22. Paste the new data. ![clipboard_e00b1d39cee2a21fa213fb6017b1fd9f6.png](https://cdn.us.document360.io/e3a59e39-abd3-4423-964c-0a4008dc5673/Images/Documentation/1495)