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"](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_6pdqq6.png)
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](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_1k2iqzy.png)
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](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_1ntpxlh.png)
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](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_1eh1sq5.png)
Step 7: Go to ContactsImport Contacts. Upload the edited file.
![Upload the edited file](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_w4pnr1.png)
Step 8: Update the map column data, using email as a Lookup column.
![Update the map column data, using email as a Lookup column](https://storage.crisp.chat/users/helpdesk/website/eaa36b5a44772800/image_e85131.png)
Push START IMPORT button.
When you check your Contact Lists, this list of contacts will appear updated.
Updated on: 16/11/2022
Thank you!