> 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/kontakte-verwalten/wie-importiere-oder-exportiere-ich-kontakte-aus-csv-dateien.md).

# How do I import or export contacts from CSV files?

Besides creating, editing, and directly adding contacts from the event list, it is also possible to import contacts as a .csv or .txt file in UTF-8 (Unicode) format or export them from your sipgate account.

#### Import contacts from Outlook to sipgate

First export your Outlook contacts as a CSV file. To do this, open Outlook, go to your contacts there, and select at the top via the menu HOME → MANAGE CONTACTS → EXPORT CONTACTS.

As soon as your file is ready for import, log in to your sipgate account and go to **My sipgate**. Click on **Contacts** and then on **Import**.

Now choose how you want to import the contacts.

For a .csv or txt file, click on **Upload CSV file**. You will then be asked to select the file and must decide whether it is private (visible only to you) or shared (visible to everyone).

Once you have selected everything, click on **Upload file.** After you have uploaded the file, you will be asked to map the records and save the mapping.

{% hint style="warning" %}
**Tip:** You should not import more than 2500 contacts at once. Better use multiple packages of 2000–2500 if you have larger contact volumes. If there are more than 2500 contacts, possibly only the first approx. 2500–2800 will be imported.
{% endhint %}

The CSV file should be created as follows:

{% code title="CSV example" %}

```csv
"First Name","Middle Name","Last Name","Birthday","Notes","E-mail Address","E-mail 2 Address","E-mail 3 Address","Primary Phone","Home Phone","Home Phone 2","Mobile Phone","Home Address","Company Main Phone","Business Phone","Business Phone 2","Assistant's Phone","Company","Job Title","Business Address","Other Phone","Other Address","Car Phone","Radio Phone", "Max","JR","Mustermann",01/01/70,"Beispiel Kontakt","max_mustermann@domain.tld","mmustermann@job.tld",,"+4930123456789",,,,"Hauptstr. 3,10553 Berlin",,,,,"Mustermann AG","CEO",,,,,
```

{% endcode %}

Most programs such as Microsoft Excel allow you to save files as CSV files. As a rule, the file is automatically in UTF-8, plain text format. To make sure that the file is saved as a .csv or .txt file in UTF-8 format, follow the instructions for [Mac OS](https://help.sipgate.de/hc/de/articles/4719495807133-Wie-bereite-ich-den-CSV-Kontaktimport-f%C3%BCr-MacOS-vor) and [Windows](https://help.sipgate.de/hc/de/articles/4719518065693-Wie-bereite-ich-den-CSV-Kontaktimport-f%C3%BCr-Windows-vor) section.

#### Export sipgate contacts

→ Log in to your sipgate account and go to **My sipgate**.

→ Click there on **Contacts** and then on **export.**

→ Replace the semicolon ";" in the created CSV file with a "," comma.

→ Save the changes.

→ Finally, you can import the CSV file into Outlook.


---

# 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/kontakte-verwalten/wie-importiere-oder-exportiere-ich-kontakte-aus-csv-dateien.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.