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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://teamhelp.sipgate.co.uk/account-management/account-crediting-billing-settings/how-to-import-call-detail-records-into-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.