--- title: Import external contact groups to Yapla Newsletters description: Import contact groups from an external provider into Yapla Newsletters using attributes, then create segments to target them or unsubscribe them in bulk. --- [Skip to content](https://support.yapla.com/en-ca/import-external-contact-groups-to-yapla-newsletters#main-content) - [English - Canada](https://support.yapla.com/en-ca/import-external-contact-groups-to-yapla-newsletters) - [Français - Canada](https://support.yapla.com/fr-ca/importer-des-groupes-de-contacts-externes-vers-yapla-infolettres) - [Français - France](https://support.yapla.com/fr-fr/importer-des-groupes-de-contacts-externes-vers-yapla-newsletters) - [Italiano - Italia](https://support.yapla.com/it-it/importare-gruppi-di-contatti-esterni-su-yapla-newsletter) English - Canada Show submenu for translations [More support](https://support.yapla.com/en-ca/kb-tickets/new?hsLang=en-ca) [Customer portal](https://support.yapla.com/tickets-view?hsLang=en-ca) [![logo-yapla-help-centre](https://support.yapla.com/hs-fs/hubfs/logo-yapla-help-centre.png?width=880&height=119&name=logo-yapla-help-centre.png)](https://support.yapla.com/en-ca/?hsLang=en-ca) - [Meet](https://www.yapla.com/en-ca/support-meeting?utm_term=plateforme) - [Yapla Academy](https://academy.yapla.com/) Open main navigation Close main navigation - [Meet](https://www.yapla.com/en-ca/support-meeting?utm_term=plateforme) - [Yapla Academy](https://academy.yapla.com/) - - [English - Canada](https://support.yapla.com/en-ca/import-external-contact-groups-to-yapla-newsletters) - [Français - Canada](https://support.yapla.com/fr-ca/importer-des-groupes-de-contacts-externes-vers-yapla-infolettres) - [Français - France](https://support.yapla.com/fr-fr/importer-des-groupes-de-contacts-externes-vers-yapla-newsletters) - [Italiano - Italia](https://support.yapla.com/it-it/importare-gruppi-di-contatti-esterni-su-yapla-newsletter) English - Canada Show submenu for translations - [More support](https://support.yapla.com/en-ca/kb-tickets/new) - [Customer portal](https://support.yapla.com/tickets-view) - [Contact us](https://support.yapla.com/en-ca/kb-tickets/new) [Contact us](https://support.yapla.com/en-ca/kb-tickets/new?hsLang=en-ca) How can we help you? - There are no suggestions because the search field is empty. 1. [Yapla Help Centre](https://support.yapla.com/en-ca?hsLang=en-ca) 2. [Send newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca) 3. [Contacts management](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#contacts-management) # Import external contact groups to Yapla Newsletters ## Are some of your contacts not in Yapla, such as volunteers or partners? This article explains how to import them and group them in Yapla Newsletters. If you want to sign up for our newsletter feature and you already have a contact directory that is well organized into segments, lists, subscribers, unsubscribed contacts or invalid addresses with an external provider, some configuration steps will be needed to get your newsletter mailings working properly again. In this article, see how to import and reclassify your contact lists in the Yapla Newsletters feature. When you activate the Newsletters feature, your contacts in Yapla are synced automatically. [Learn more in this article.](https://support.yapla.com/en-ca/automatic-contact-sync-to-yapla-newsletters?hsLang=en-ca) ### Import external contact groups ### 1. What is an attribute? Attributes make it easy to find a set of contacts so you can perform a bulk action, for example unsubscribing them, flagging them as bounces or grouping them into a sending segment. When you import an external list, it is therefore important to import bounced and unsubscribed contacts first, under attributes that let you reclassify them in Yapla Newsletters and avoid sending to these contacts by mistake. You can do the same for any group of external contacts so you can reclassify them into specific sending segments at any time. ### 2. Prepare your import files and create the attribute We recommend having one Excel file per group of contacts (e.g., unsubscribed, bounces, 2025 conference participants, group of journalists, etc.). You need to add an attribute to each of your import files to classify all its contacts under it. The attribute is created automatically in the feature. Here is how to create your file: 1. In your Excel file, delete all the columns except the email. 2. Add a column named after the group you are importing (the attribute), for example “*tounsubscribe*”, and enter “*yes*” for every email under it. Repeat this procedure for each group of contacts to import, in separate files. ![Excel file with an email column and an attribute column](https://support.yapla.com/hs-fs/hubfs/Knowledge%20Base%20Import/38311224001299.png?width=283&name=38311224001299.png) ### 3. Importing the files 1. In Yapla Newsletters, go to **Audience \> Contacts**. 2. In the left-hand column, if you have more than one list, select the list you want. 3. Click the (+) in the top right corner, then click **Import contacts**. 4. Select the **Existing** option, choose your list, then click **Continue**. ![Select a list step with the Existing option](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-import-liste.png?width=290&name=infolettres-en-import-liste.png) Do not import your contacts under the *Add new* option: your contact count is calculated from the total number of contacts in each list, even if the same contact appears in more than one list. 1. Select the **Copy/paste from spreadsheet** option. 2. Select all the data in your spreadsheet, copy it and paste it into the table. Click **Continue**. 3. In the next step, you can review the data. Make sure the first column field shows “*email*” and that the second column contains the name of the contact group (the attribute) you are importing. Click **Continue**. ![Select contact column names step with the email and tounsubscribe columns](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-import-colonnes.png?width=640&name=infolettres-en-import-colonnes.png) 1. Next, confirm that you have permission to send emails to these contacts by selecting **I confirm I have full permission**, then click **Continue**. You will be redirected to your contact list. ### 4. Create a segment 1. In the left-hand column of your contact list, click **Create segment**. 2. Give the segment the same name as the attribute you created (for example, “*To unsubscribe*”). 3. In the first condition field, select the matching attribute (under *Custom attributes*), select “*is*” in the next row and enter “*yes*” in the last row. 4. Click **Save and exit**. ![Creating the To unsubscribe segment with the condition tounsubscribe is yes](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-segment-attribut.png?width=302&name=infolettres-en-segment-attribut.png) Now, by filtering your contact list with the segment you created, you will get the list of the contacts you imported under the same attribute. Their status will also show that they are “Active”. You can now send newsletters that target this specific group. If you imported a group of unsubscribed or bounced contacts, you will need to change this status to unsubscribe them. Here is how: #### Unsubscribe imported contact groups By filtering your contact list with the segment you created, “To unsubscribe” or “bounces”, you will get the list of the contacts you imported under the same attribute. Under **Audience \> Contacts**, select this segment from the *All contacts* drop-down menu in the left-hand column. ![Segment drop-down menu in the left-hand column of the Contacts page](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-contacts-filtrer-segment.png?width=261&name=infolettres-en-contacts-filtrer-segment.png) To change the status of this group of contacts from *Active* to *Unsubscribed*, select all the contacts in the resulting list (**Select page** checks all the contacts on the displayed page), click **Actions** at the bottom and select **Unsubscribe**. ![Actions menu with the Unsubscribe option after selecting contacts](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-contacts-actions.png?width=400&name=infolettres-en-contacts-actions.png) Your contacts now have the “*Unsubscribed*” status. Note that if, for example, displaying 100 contacts per page gives you a total of 6 pages, you will need to repeat the previous step for all 6 pages (that is, select all the contacts and unsubscribe them on each page). If your unsubscribed contacts have not been imported yet, you can give them this status during the import: at the *Select contact column names* step, select **Unsubscribed** in the **Import as** menu. ![Import as menu with the Active, Unsubscribed and Deleted statuses](https://support.yapla.com/hs-fs/hubfs/Centre-aide/Infolettres/infolettres-en-import-statut.png?width=399&name=infolettres-en-import-statut.png) ### About “*Bounced*” contacts For the same contact list, you need to repeat the entire procedure and name your new attribute based on the imported file, for example “bounces”. The contacts you import from the bounces list may be automatically recognized as invalid during the import. If so, they will not be imported. The other contacts on this list will need to be unsubscribed. ### Good to know You need to repeat the whole import process for each of your contact lists. For example, if you send bilingual newsletters, you may have a list for each supported language. If you run into any difficulties while importing your contacts or would like more help with it, feel free to contact our support team at [support@yapla.com](mailto:support@yapla.com). ### Learn more: - [Guide | Technical vocabulary of Yapla Newsletters](https://support.yapla.com/en-ca/technical-vocabulary-of-yapla-newsletters?hsLang=en-ca) - [Create and use tags in your newsletters](https://support.yapla.com/en-ca/create-and-use-tags-in-your-newsletters?hsLang=en-ca) - [Creating segments for your newsletters](https://support.yapla.com/en-ca/creating-segments-for-your-newsletters?hsLang=en-ca) - [Getting started on Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#main-content) - [Collection of useful resources to discover Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#collection-of-useful-resources-to-discover-yapla) - [Getting started](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#getting-started) - [Make the most of Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#make-the-most-of-yapla) - [About Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#about-yapla) - [Configure my account](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#main-content) - [First steps](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#first-steps) - [Account](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#account) - [Billing](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#billing) - [License and users](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#license-and-users) - [Frequently asked questions](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#frequently-asked-questions) - [Learn about common functionalities](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#main-content) - [Communications](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#communications) - [Forms](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#forms) - [Pictures and media](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#pictures-and-media) - [Frequently asked questions](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#frequently-asked-questions) - [Manage my payments and authentification](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#main-content) - [Authentification](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#authentification) - [Payment method](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#payment-method) - [Voluntary contribution and commission](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#voluntary-contribution-and-commission) - [Frequently asked questions](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#frequently-asked-questions) - [Manage my members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#main-content) - [First Steps](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#first-steps) - [Import members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#import-members) - [Simplified Membership Campaign](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#simplified-membership-campaign) - [Member management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#member-management) - [Member profiles](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#member-profiles) - [Form](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#form) - [Communications](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#communications) - [Organization or family management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#organization-or-family-management) - [Membership management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#membership-management) - [Rates](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#rates) - [Organization or family](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#organization-or-family) - [Advanced functions](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#advanced-functions) - [Continuing education](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#continuing-education) - [Frequently asked questions](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#frequently-asked-questions) - [Organize my events](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#main-content) - [First steps](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#first-steps) - [Settings](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#settings) - [Forms](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#forms) - [Electronic tickets](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#electronic-tickets) - [Advanced settings](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#advanced-settings) - [Communications](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#communications) - [Rate management](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#rate-management) - [Event registration management](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#event-registration-management) - [Activity management with sessions](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#activity-management-with-sessions) - [Conferences](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#conferences) - [Frequently asked questions](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#frequently-asked-questions) - [Receive donations](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#main-content) - [First Steps](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#first-steps) - [Donation management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#donation-management) - [Tax receipts](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#tax-receipts) - [Recurring donation](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#recurring-donation) - [Campaign management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#campaign-management) - [Peer-to-peer campaign (P2P)](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#peer-to-peer-campaign-p2p) - [Donor management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#donor-management) - [Frequently asked questions](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#frequently-asked-questions) - [Create my website](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#main-content) - [First steps](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#first-steps) - [Website personalization](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#website-personalization) - [Content and articles](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#content-and-articles) - [Pages](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#pages) - [Modules](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#modules) - [Online store](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#online-store) - [SEO & Performance Tools](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#seo-performance-tools) - [Simplify my accounting](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#main-content) - [First Steps](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#first-steps) - [Manage sales and invoices](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#manage-sales-and-invoices) - [Manage expenses](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#manage-expenses) - [General ledger](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#general-ledger) - [Consolidation](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#consolidation) - [Reports](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#reports) - [Settings](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#settings) - [Projects](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#projects) - [Taxes](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#taxes) - [Frequently asked questions](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#frequently-asked-questions) - [Manage my contacts](https://support.yapla.com/en-ca/manage-my-contacts?hsLang=en-ca#main-content) - [Manage contact](https://support.yapla.com/en-ca/manage-my-contacts?hsLang=en-ca#manage-contact) - [Send newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#main-content) - [Introduction to Yapla Newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#introduction-to-yapla-newsletters) - [Configure your Newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#configure-your-newsletters) - [Contacts management](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#contacts-management) - [Performance tracking](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#performance-tracking) - [Target your mailings](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#target-your-mailings) - [Grow your subscriber list](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#grow-your-subscriber-list) - [Webinars](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#webinars) - [Manage my data](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#main-content) - [First Steps](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#first-steps) - [Settings](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#settings) - [Object management](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#object-management) - [Reports](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#reports) - [Documentation for developers](https://support.yapla.com/en-ca/documentation-for-developers?hsLang=en-ca#main-content) - [Advanced functions](https://support.yapla.com/en-ca/documentation-for-developers?hsLang=en-ca#advanced-functions) - [Manage my federation](https://support.yapla.com/en-ca/manage-my-federation?hsLang=en-ca#main-content) - [Getting started](https://support.yapla.com/en-ca/manage-my-federation?hsLang=en-ca#getting-started) - Our pricing - [Pricing](https://www.yapla.com/en-ca/pricing) - [Professional Services](https://www.yapla.com/en-ca/professional-services) - [Training hours bank](https://info.yapla.ca/en/services) - Resources - [Help Centre](https://support.yapla.com/) - [Yapla Academy](https://academy.yapla.com/?utm_campaign=website&utm_medium=footer&utm_source=academie) - [Blog](https://www.yapla.com/en-ca/blog/) - [Yapla Newsletter](https://www.yapla.com/en-ca/yapla-newsletter/) - Discover Yapla - [Demo and webinars](https://www.yapla.com/en-ca/webinars) - About Yapla - [About us](https://www.yapla.com/en-ca/about-us/) - [Work with us](https://info.yapla.ca/en/work-with-us) - Contact Yapla - [Become partner](https://www.yapla.com/en-ca/partner-program/) [![Yapla](https://support.yapla.com/hubfs/logo-yapla-fr.svg "Yapla")](https://www.yapla.com) Copyright © 2013-2026, Yapla [Terms of use](https://www.yapla.com/en-ca/terms-of-use)| [Privacy policy](https://www.yapla.com/en-ca/privacy-policy)