> 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?

Step-by-step instructions for importing sipgate itemized call records as a CSV file into Microsoft 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** using 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**.

![](https://4045603198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fg0qj71PeONPljdPedXLf%2Fuploads%2Fgit-blob-e3622a070ac1ecdad39d3d3fe3a48ad12e3bec70%2FDaten%20importieren.png?alt=media)
{% endstep %}

{% step %}
**Import file**

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

![](https://4045603198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fg0qj71PeONPljdPedXLf%2Fuploads%2Fgit-blob-3aefdb5ecb80890dc03909cd3ce536cd0dda037e%2FSpeichern.png?alt=media)
{% endstep %}

{% step %}
**Set encoding**

To ensure special characters and umlauts are displayed correctly, in the next step please set the **file origin** to **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 separate columns. To do this, enter under **Delimiter options** semicolon. and then save the changes.

If you are using 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 → 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 **phone number** and **Costs**.
{% endhint %}

![](https://4045603198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fg0qj71PeONPljdPedXLf%2Fuploads%2Fgit-blob-dc467d4caa95c6ddf668bea9b30788f182d25fd7%2FTextkonvertierung.png?alt=media)
{% endstep %}

{% step %}
**Finish import**

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

![](https://4045603198-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fg0qj71PeONPljdPedXLf%2Fuploads%2Fgit-blob-72d0e868956a8653c0f7139d22a51ff1323d0eac%2FFertig.png?alt=media)
{% 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
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=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.