> 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

How to download and import sipgate Call Detail Records (CDR) in CSV format into Microsoft Excel with proper formatting.

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.