---
title: Import and update members [Guide]
description: Import your members, their latest membership and details in one step with Yapla's import wizard, or update several member records at once in bulk.
---

[Skip to content](https://support.yapla.com/en-ca/import-and-update-members-guide#main-content)

- [English - Canada](https://support.yapla.com/en-ca/import-and-update-members-guide)
- [Français - Canada](https://support.yapla.com/fr-ca/importer-et-mettre-à-jour-les-membres-guide)
- [Français - France](https://support.yapla.com/fr-fr/importer-et-mettre-à-jour-ses-membres-guide)
- [Italiano - Italia](https://support.yapla.com/it-it/importare-e-aggiornare-i-membri-guida)

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-and-update-members-guide)
    - [Français - Canada](https://support.yapla.com/fr-ca/importer-et-mettre-à-jour-les-membres-guide)
    - [Français - France](https://support.yapla.com/fr-fr/importer-et-mettre-à-jour-ses-membres-guide)
    - [Italiano - Italia](https://support.yapla.com/it-it/importare-e-aggiornare-i-membri-guida)

  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. [Manage my members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca)
3. [Import members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#import-members)

# Import and update members \[Guide\]

The import wizard in the Members application allows you to import all your members when you create your account. It also allows you to quickly update multiple members at the same time.

### Preparing the file

To do a mass update, you will need an Excel file (.xls or .xlsx) containing the email addresses of the members to be modified, as well as the information to be updated.

You can use any file, including an export from other management software, or use [this template](https://cdn.ca.yapla.com/company/CPYmC5A4aK0NH6iO0MGqD5U/asset/demo/Yapla-Member-Import-Template.xlsx). It is also important to respect the following rules:

- Only the first tab of the file will be imported.
- The file must be simple, without colors or formating in the cells.
- Cell lines should not be highlighted.
- Cells must not be merged together.
- The file must not contain a macro.
- Avoid empty lines at the end of the file, which could create unwanted members.

If in doubt, do not hesitate to select the data you wish to import and copy it into a new file, using the Paste values function, in order to clean up your data. You will obtain a file containing only the information of your import.

Only the columns containing the changes are required.

For example, your file could contain the following columns: email, first name, last name, title.

![mceclip8.png](https://support.yapla.com/hs-fs/hubfs/Knowledge%20Base%20Import/mceclip8-Dec-22-2025-08-13-07-5528-PM.png?width=407&height=144&name=mceclip8-Dec-22-2025-08-13-07-5528-PM.png)

**Important**: If the field to be updated contains a **multiple choice answer**, such as for the title, the answer choices need to correspond to the exact label or a value. To find out this information, go into the import wizard in the Members application (Members \> Settings \> Member Import). Select the field in question. A table will appear with the list of corresponding values.

![mceclip1.png](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/mceclip1-Dec-22-2025-08-13-05-5386-PM.png)

### Updating members

The import wizard is located in the *Settings* for the *Members* application, in the *Wizards* category (Members \> Settings \> Member Import).

![mceclip3.png](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/mceclip3-Dec-22-2025-08-13-09-8977-PM.png)

In the first step, upload your member list file.

![mceclip5.png](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/mceclip5-Dec-22-2025-08-13-08-6969-PM.png)

In the next step, you will need to link (click and drag) the columns in your Excel file with the custom fields in your account.

The first section, *Unique identifier of your member*, will be used to differentiate your members. It is this information that will determine if the import will update the information of an existing member or create a new one. It is therefore essential to avoid duplicates members in your account. You can use the email, the member number or any [custom field of incremental type](https://support.yapla.com/hc/en-ca/articles/360025269233?hsLang=en-ca).

![unique-id.png](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/unique-id.png)

If you want to force the update of a field, check the box next to it. If this box is not checked and the member already has information in this field, this information will be kept.

![member-import2.gif](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/member-import2.gif)

Click on *Next Step* to continue. If the validation engine does not encounter any problems, you can click on *Next Step* again and launch the import. Note that you can click on the *Refresh* button to see the status of the validation engine.

If any messages are returned at this stage, check their content carefully. If necessary, correct your file and start again. If the errors are not important, you can also choose to ignore them and continue, but some information could be imported incorrectly.

![member-import-errors.png](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/member-import-errors.png)

The import can take several minutes if you have a large file. We recommend letting the page run in the background and working in another tab during this time. An email will be sent to you when the import is complete.

Once you've imported your members, all that's left to do is [import your memberships](https://support.yapla.com/hc/en-ca/articles/360042760894?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)
    - [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)
    - [Content and articles](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#content-and-articles)
    - [SEO & Performance Tools](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#seo-performance-tools)
    - [Frequently asked questions](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#frequently-asked-questions)
- [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)
    - [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)

<https://www.facebook.com/Yapla.ca.en> <https://www.instagram.com/yapla.ca_en/> <https://www.youtube.com/Yapla> <https://www.linkedin.com/company/yaplacommunity/>

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)