> For the complete documentation index, see [llms.txt](https://help.sipgate.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.sipgate.de/cloud-telefonanlage/en/account-management/vertrage-rechnungen-und-preise/wie-importiere-ich-die-einzelverbindungsnachweise-in-excel.md).

# How do I import the itemized call records into Excel?

You can download your data from the itemized billing statement at any time for further processing in Excel. You can find out 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 on the left side of the screen **From Text** and then **Import data from a text file**.

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

{% step %}
**Import file**

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

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

{% step %}
**Set encoding**

So that special characters and umlauts are displayed correctly, in the next step 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 arranged in separate columns. To do this, enter under **Separator options** semicolon. and then save the changes.

If you use a Windows operating system, you can find the settings under: Data → Get Data → From Text (Legacy) → Select CSV file → Delimited → File Origin (Unicode UTF-8) → Next → Semicolon delimiter. 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 %}
**Complete import**

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

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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` 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>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.