> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://knowledge.buildagil.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Exporting Contacts as an Excel File

* [Exporting Contacts](#3-exporting-contacts)
* [Troubleshooting](#3-troubleshooting)

### Exporting Contacts
You can export a complete list of all contacts for a project and process it further in Excel. This allows you to efficiently execute analyses, apply filters, or run comparisons. The contact list is continuously synchronized, which prevents different or outdated versions from circulating.  
The export option is available for the contacts in the project. All contacts to which the user [Viewing Rights](/en/article/visibility-permissions-for-contacts-users-1onepyc/) has access are always exported. The list can then be filtered and analyzed in Excel.

||| The Excel export feature is not available on macOS.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/2/9/f/d29f517da520580/kontaktliste-exportieren_1jb0aa3.png)

When you export, an ".iqy" file is downloaded. This file establishes a direct link to the documents in buildagil.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/2/9/f/d29f517da520580/iqy-datei-kontakte_9zze7q.png)

When the file is opened, it opens automatically in Excel. All contacts with the "Live" status are now displayed here. If a change is made in buildagil, it is updated in the Excel file.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/2/9/f/d29f517da520580/exportierte-kontaktliste_1c2trmf.png)

> User List, Phone Book, Project Contacts, Sync Contacts, Contacts in Excel, Export Contacts, Contacts as a Table

### Troubleshooting

| If the troubleshooting steps below do not resolve the issue, please feel free to contact Support.

You may encounter the error message "An unexpected error has occurred. Changes to your data cannot be saved" when opening the ".iqy" file, causing the document list export to fail:

![](https://storage.crisp.chat/users/helpdesk/website/-/d/2/9/f/d29f517da520580/problembehandlung-excel-oeffne_1jj3mdc.png)

If this error occurs, check which Microsoft account was used to sign in to Excel. Synchronization can only take place without errors if the user’s Microsoft account in buildagil matches the one used in the Excel application. If the accounts do not match, synchronization will be prevented.  

> Troubleshooting, iqy file, Excel synchronization, Microsoft account, document export, error message