# How do I import itemized call records into Excel?

You can download your data from the itemized bill at any time for further processing in Excel. You can learn how this works in this article

{% stepper %}
{% step %}
**Export CSV file**

Save the **CSV file** via the button **CSV export** to your hard drive. Then open Microsoft Excel and click the tab **Data**. Now select **From Text** on the left side of the screen and then **Import data from a text file**.

![](/files/e90e1241991d9bc49b1cf06d816fbec1aa2202fd)
{% endstep %}

{% step %}
**Import file**

Then select the saved itemized bill file and confirm the selection with **Import**.

![](/files/ac7cb5bf49c4fc0ed76ad10aba67e76eaa6d51c4)
{% endstep %}

{% step %}
**Set encoding**

To ensure that special characters and umlauts are displayed correctly, please set the **File origin** on **65001 : Unicode (UTF-8)** and then click **Continue** to the next step. Then activate the option **Delimiter: Semicolon**so that the values are correctly placed in individual columns. To do this, enter a semicolon under **Delimiter options** Semicolon. and then save the changes.

If you use a Windows operating system, you will find the settings under: Data → Get Data → From Text (Legacy) → Select CSV file → Delimited → File origin (Unicode UTF-8) → Next → Delimiter semicolon. Newer versions can also import the file as CSV with Power Query.
{% endstep %}

{% step %}
**Adjust data format**

{% hint style="warning" %}
**Important:** Click the row **Caller** and then select the data format **Text**. Repeat this step for the columns **a phone number** and **Costs**.
{% endhint %}

![](/files/ff748fc1931853ef9d27183d17bcaa4f39fcd7c2)
{% endstep %}

{% step %}
**Finish import**

After you click **Finish** the imported data from your itemized bill will be displayed correctly with the corresponding data.

![](/files/318b4623f3374a37a2e3b20c5e563b07905c8ecf)
{% endstep %}
{% endstepper %}


---

# 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://help.sipgate.de/cloud-telefonanlage/en/account-management/vertrage-rechnungen-und-preise/wie-importiere-ich-die-einzelverbindungsnachweise-in-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.