How can I export recipient data from the address book as a file?

You can easily export the data of selected recipients (both active and inactive contacts) or entire recipient groups from your address book. Please follow these steps:

1. Exporting Data from the Address Book

Navigate to your Address Book in the main menu.
Select the desired recipients or groups by checking the respective checkboxes.
Once at least one recipient is selected, a gear icon will appear next to the search field.
Click on the gear icon and select "Export as CSV". The file will then download automatically to your device.

2. Opening and Formatting the CSV File Correctly

Option A: Opening with OpenOffice (Recommended)

For an error-free display, we recommend opening the downloaded CSV file using OpenOffice. From there, you can easily save the document in other formats such as .ods or .xlsx if required.

Option B: Importing into Microsoft Excel

If you prefer to use the file directly in Excel, we recommend a manual data import, as formatting and character encoding can vary when opening the file directly depending on your Excel version:

Open a new, blank workbook in Excel.
Go to the "Data" tab in the top menu bar and select "From Text/CSV". Choose the downloaded CSV file.
A preview window will appear. Under "File Origin", make sure to select "Unicode (UTF-8)" encoding. This ensures that all special characters, line breaks, and umlauts are displayed correctly.
Click on "Load".
Your data will now be cleanly structured into rows and columns. You can save it as a regular Excel workbook (.xlsx) by going to File > Save As.

Column Name	Description / Meaning
`id`	Unique ID of the recipient / customer
`email`	Contact's email address
`phone`	Phone number
`gender`	Gender
`first_name`	First name
`last_name`	Last name
`birthday`	Date of birth
`is_bounced`	Indicates whether an email was undeliverable (0 = No, 1 = Yes)
`statistic_last_bounce_reason`	Reason for the last bounce
`statistic_last_unsubscribe_global_reason`	Reason for the last global unsubscribe
`statistic_last_blacklist_global_reason`	Reason for the last global blacklist entry (reasons are not provided by the system)
`statistic_last_bounce`	Date and time of the last bounce
`statistic_last_unsubscribe_global`	Date and time of the last global unsubscribe (applies to all address books)
`statistic_last_blacklist_global`	Date and time of the global blacklist entry (manually set)
`rating`	Contact quality score (increases with regular activity, decreases with inactivity)
`created_at`	Date the contact was created in the system
`is_unsubscribed`	Indicates whether the contact is unsubscribed (0 = No, 1 = Yes)
`statistic_last_unsubscribe_list_reason`	Unsubscribe reason related to a specific address book
`statistic_last_unsubscribe_list`	Address book from which the contact unsubscribed
`is_blacklisted`	Indicates whether the contact is blacklisted (0 = No, 1 = Yes)
`statistic_last_blacklist_list_reason`	Reason for blacklisting in a specific address book (reasons are not provided by the system)
`statistic_last_blacklist_list`	Date and time of the blacklist entry for a specific address book
`statistic_last_complained_list_reason`	Reason for the last complaint (not provided by the system)
`statistic_last_complained_list`	Date and time of the last complaint (e.g., spam report)
`statistic_mails_received`	Total number of newsletters received
`statistic_mails_opened`	Total number of opens for received mailings (including multiple opens)
`statistic_mails_unique_opened`	Number of unique opens (unique contacts)
`statistic_mails_clicked`	Total number of clicks in received mailings
`statistic_mails_unique_clicked`	Number of unique clicks (unique links/contacts)
`statistic_conversions`	Number of completed conversions
`statistic_conversions_sum`	Total value or revenue generated from conversions
`statistic_last_mail_action`	Timestamp of the last activity (e.g., open, click, bounce, etc.)
`statistic_last_mail_received`	Date and time the last mailing was received
`statistic_last_mail_opened`	Date and time of the last recorded open
`statistic_last_mail_clicked`	Date and time of the last recorded click
`statistic_last_mail_converted`	Date and time of the last recorded conversion
`statistic_last_useragent_device`	Last detected device type (e.g., Mobile, Desktop)
`statistic_last_useragent_family`	Last detected web browser
`statistic_last_latitude`	Last detected latitude (geolocation)
`statistic_last_longitude`	Last detected longitude (geolocation)
`statistic_last_country_code`	Last detected country code (e.g., DE, AT, CH)
`statistic_last_region`	Last detected region / state
`statistic_last_city`	Last detected city
`reference`	Reference ID of the signup form used
`source`	Source of the recipient signup (e.g., FORM, DOI, SYNC, MANUALLY, DOI IMPORT)
`external_id`	External ID (e.g., from a connected CRM or e-commerce system)
`registration_date`	Date of the original registration
`activation_date`	Date of confirmation (e.g., via Double Opt-In)
`registration_ip`	IP address at the time of registration
`registration_website`	Website on which the signup form was embedded