> For the complete documentation index, see [llms.txt](https://teamhelp.sipgate.co.uk/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://teamhelp.sipgate.co.uk/account-management/account-crediting-billing-settings/how-to-import-call-detail-records-into-excel.md).

# How to import call detail records into excel

You can easily download your Call Detail Records (CDRs) in CSV format for further processing in Excel. Here's how to do it:

* Save the CSV file to your hard drive by clicking the **CSV Export** button.
* Open Microsoft Excel and go to the **Data** tab. On the left-hand side, select **From Text**, then choose **Import Data from a Text File**.
* Next, select the saved CDR file and confirm your choice by clicking **Import**.
* To ensure special characters and umlauts are displayed correctly, set the file origin to **65001: Unicode (UTF-8)** in the next step, then click **Next**.
* Choose the **Semicolon** delimiter option so the values are properly placed into separate columns. Enter **Semicolon** under **Delimiter Options** and save the changes.

If you're using a Windows operating system, follow these steps: Data ➔ Get Data ➔ From Text (Legacy) ➔ Select CSV File ➔ Add Delimiters ➔ File Origin (Unicode UTF-8) ➔ Next ➔ Semicolon Delimiter. Newer versions may allow importing the file as CSV with PowerQuery.

**Important:** Click on the **Caller** row and set the data format to **Text**. Repeat this step for the **Phone Number** and **Cost** columns.

Once you click **Finish**, your imported CDR data will be correctly displayed with the corresponding information.