Articles on: FAQ's

Bulk updating of contacts using Excel

Bulk updating of contacts using Excel




There is a way to bulk contacts for updating them by a specific category: contact source, assigned contact manager, employer organisation, unsubscribed, etc.



Using the bulk editor

Some fields can be bulk edited directly in the Contacts-All Contacts screen

How do I Bulk Edit Contacts inside ActiveDEMAND?


Using Excel:

This can be made by following next steps:

Step 1: To create a List of contacts from the Contacts menu in ActiveDEMAND select “Contact Lists”. You can make a new list of people or use a set of people that you already have.


Select "Contact lists"


Step 2: Select the contacts you want to bulk, add them to the list and save it.

Step 3: Go to All contacts (Contacts-All Contacts). Click the 'All Contacts' drop down to select your list or segment.

Step 4: Once the list or segment is selected and used to filter the ‘All contacts’ table, click the EXPORT button.

click the EXPORT button

Step 5: Download the Excel file that you received via email (or click CONTACT EXPORTS again to see a list of all your recent exports to download).

Download the EXCEL file

Step 6: In Excel file update appropriate column with new data (email, YES/NO, name values).

In Excel file update appropriate column with new data

Step 7: Go to ContactsImport Contacts. Upload the edited file.

Upload the edited file

Step 8: Update the map column data, using email as a Lookup column.

Update the map column data, using email as a Lookup column

Push START IMPORT button.

When you check your Contact Lists, this list of contacts will appear updated.

Updated on: 16/11/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!