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