#toc { background-color:rgba(187,222,251,.6); padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; margin-bottom: 20px; width: 400px; } On this page:• Export existing contact records to a spreadsheet• Adjust the exported values• Import the spreadsheet• System fields that cannot be updated• System fields that can be updated• Supported date formatsYou can update multiple contact records in bulk through a three-stage process:Export your contacts to a spreadsheetAdjust the spreadsheet valuesImport the adjusted spreadsheet.Before you begin this process, you should back up your contact database by exporting it to a spreadsheet. Any existing data in imported fields will be overwritten by the imported data. You cannot undo the importing of contact records.To update multiple contact records using this process, follow the steps below.1. Export existing contact records to a spreadsheetTo export contact records to a spreadsheet, follow these steps:Hover over the Contacts menu and select the List option.If you want to update only selected contacts, filter the list. You only need to export the records you want to adjust.Click the Export button.On the screen that appears, select the export file format – XLS, CSV, or XML.Choose which fields to include in the export file.Click the Export button.While the export file is being generated, you can click the Continue working button and safely switch to another Wild Apricot admin screen.Once the file is generated, you'll receive an email with a link to the file.If you waited until the export file was generated, the file will be automatically downloaded. As well, a dialog with a link to the file will appear, and an email with the link will be sent to you.Before clicking the download link within the email, make sure you are logged into your Wild Apricot account as an administrator.You can choose to export the following columns:User IDFirst nameLast nameOrganizationEmailPhonePasswordGroup participationArchivedSubscribed to emailsSubscription sourceEvent announcementsMember emails and newslettersAdministration accessCreated onProfile last updateUpdated byBalanceTotal donatedMembership enabledMembership levelMembership statusMember sinceRenewal dueRenewal date last changedLevel last changedAccess to profile by othersDetails to showPhoto albums enabledMember bundle ID or emailMember roleNotes...plus any custom fields you have added.Also, the Password column will be exported if you select the Export all fields option. The exported Password column will always be empty, but can be used to import passwords.Any date fields that you export will be formatted using the date format that is selected on your Organization details screen.The following system fields are included in the export file but cannot be updated through importing.Administration accessBalanceCreated onLevel last changedMember roleProfile last updatedRenewal date last changeSubscription sourceTotal donatedUpdated byThese fields will be ignored during import if present in your import file.2. Adjust the exported valuesWith your contact records exported, you can now open the export file in Excel (or any other spreadsheet program) and adjust the exported values.If you want to be able to restore contact records in case of a mistake on your part, you should modify a copy of the exported spreadsheet.To simplify the field mapping stage of the process, you might want to delete any columns you don't want to update. Columns not in the spreadsheet will not be updated.When updating existing contact records, you must include either an Email column or a User ID column. If you're updating email addresses, use the User ID column to identify each contact.You can include additional columns for each field you want to update in your contact database. The names of the columns – the column headings – are not important since you can map each column in the spreadsheet to fields in your contact database as part of the import process.If you want to remove a value – leaving it blank rather than replacing it with another value – enter NEVER for system date fields (like Renewal date), and CLEAR for custom fields and for the Group participation and Notes system fields.You can archive multiple contacts – by setting the Archived column to Yes – but you cannot delete multiple contacts through importing. Once archived, however, you can delete all the archived records.You cannot archive a contact through import if the contact has recurring payments enabled. You must first cancel the recurring payments.You can suspend a member by setting the Membership enabled cell to no, and reinstate a suspended member by setting the Membership enabled cell to yes. An empty Membership enabled value indicates that the contact is not and was not a member.For many system fields, you are restricted to entering certain values, or to enter values using a certain format. For more information, see Importing contacts.3. Import the spreadsheetOnce you've finished modifying the spreadsheet, you can use it to update your Wild Apricot contact database.To import the spreadsheet, follow these steps:Hover over the Contacts menu and select the Import option.Click the Choose file button.Select the import file on your computer or network then click the Open button. The file must be in either .xls, .xlsx, .csv, or .xml format, and up to 50 megabytes in size.Click the Upload button.Wild Apricot will now upload and analyze the import file. So that Wild Apricot can process the file properly, you will be prompted to provide some information about the import file.For details on the remaining steps in the import process, see Importing members and contacts.You can update only common and membership fields through importing. Other data related to events, donations, and finances can only be exported.You can also perform mass updates of certain information from within Wild Apricot. You can:Update the privacy settings for all members.Clear the contents of a custom field for all contacts, by deleting the custom field and recreating it again.You can import existing payments and event registrations into your Wild Apricot database using the Wild Apricot API. For more information, see Payments API V2 call and EventRegistrations API V2 call.System fields that cannot be updatedThe following system fields cannot be updated through importing, for security or privacy reasons.Administration accessBalanceCreated onLevel last changedMember roleProfile last updatedRenewal date last changedSubscription sourceTotal donatedUpdated byThese fields will be ignored during import if present in your import file.System fields that can be updatedSystem fields already exist within your Wild Apricot database and do not need to be created in your common or membership fields.The following system fields can be updated through importing. For many system fields, you are restricted to entering certain values, or to enter values using a certain format. The valid values and formats for system fields are listed below.User IDThis is a unique ID automatically generated by the system. You can enter an existing user ID to identity an existing contact in your database. You cannot create your own user ID; any values not found in your Wild Apricot database are ignored and replaced with a system generated ID.Valid values: Usually a 5, 6 or 7 digit numberEmailIf the email address entered already exists in the database, then the existing record will be updated. Otherwise, a new record will be created.If multiple records within the import file use the same email address, only the first record will be imported and the other records using that address will be ignored.Valid values: Any valid email format (i.e. randy@iats.com)Group participationIf you specify a member group that does not already exist in your Wild Apricot account, you will have the option to create it during the mapping stage of the import process. To assign a member to more than one group, enter the group names on separate lines within the same cell (not separate rows).Valid values: Name of the member group. Can be any combination of letters, numbers, characters, and spacesPasswordLeave empty if you do not want to update the current user passwords. Passwords can only be imported, not exported.Valid values: Any combination of letters, numbers, and characters; no spaces.Minimum number of characters: 7.Maximum number of characters: 50Membership enabledIf set to No, all membership fields are ignored during import.Valid values:Yes - contact is a memberNo - membership is suspended; contact no longer treated as a memberMembership levelIf you specify a membership level that does not already exist in your Wild Apricot account, you will have the option to create it during the mapping stage of the import process.Valid values: Name of your membership level. Can be any combination of letters, numbers, characters, and spacesMember bundle ID or emailUse this field to bind members to the same bundle (see Importing bundles).Valid values: The user ID or the email address of a bundle administrator.Member sinceThe date the contact became a memberValid values: Use supported date format (see below)Renewal dueThe renewal due dateUse supported date format (see below), or set to Never if member is not required to renew.StatusThe membership status.Valid values:Active - Member enjoys all member benefitsLapsed - Member has not paid his/her dues in timePending - Renewal - Member initiated the renewal process, but payment has not been confirmed yetPending - Level Change - Membership level change was initiated, now waiting for payment confirmation or approval.Pending - New - New application is awaiting approval or payment confirmation.Subscribed to emailsIf Yes, contacts will be able to receive automatic email notices. Setting to No disables emails being sent to this contact (regardless of the Event announcements and Member emails and newsletters settings).Valid values: Yes, NoEvent announcementsThis controls whether automatic event notices and reminders are sent to the contact. This setting is ignored if Subscribed to emails is set to No.Valid values: Yes, NoMember emails and newslettersThis controls whether the user receives email blasts sent by Wild Apricot. This setting is ignored if Subscribed to emails is set to No.Valid values: Yes, NoArchivedSet to Yes if you want the contact archived.Valid values: Yes, NoAccess to profile by othersSet to Yes if you want this contact's profile to be seen by others.Valid values: Yes, NoDetails to showYou can control which kind of visitors can view individual profile fields using the following format: fieldname&&permission where fieldname is the name of the field, and permission is Nobody, Anybody, or Members.Valid values:Member ID&&NobodyFirst Name&&AnybodyLast Name&&Membersetc.Photo albums enabledSet to Yes if you want to enable photo albums for this member.Valid values: Yes, NoNotesAdmin-only field, typically used by the system to record information not captured by other fields (i.e. automatic membership emails sent, when member was renewed, etc.)Valid values: Any charactersAny other system fields included in the import file will be ignored.Supported date formatsDate fields – membership start date, for example – must be formatted using an Excel date format.Otherwise, an error will occur when importing the file.If you are importing using a CSV file, the date fields must use one of the following date formats:dd mm yyyyExample: 31 Dec 2014yyyy-MMM-ddExample: 2014-Dec-31MM/dd/yyyyExample: 12/31/2014dd/MM/yyyyExample: 31/12/2014yy/MM/ddExample: 14/12/31dd-MMM-yyExample: 31-Dec-14yyyy-MM-ddExample: 2014-12-31dd.MM.YYYYExample: 31.12.2014MM.dd.YYYYExample: 12.31.2014Do not include the time of day within a date field.