How do I change contact status through CSV import?

DESCRIPTION

Changing contact status through an import

**Note: This only works for changing a "normal" contact to another status. Mass updates to contacts in any other status to different status will not update the record.**

Let's say you have a list of emails you need to change to a new contact status like unsubscribed, held or expired. You don't have to update each one manually! To update email addresses in bulk, follow this process:

HOW-TO

Change contact status through a .CSV import-

1. Create a .csv file of addresses needing to be changed.

2. Set up your file to include two columns EmailAddr and MemberType. Under the EmailAddr column, list the email addresses. Under the MemberType column use 'unsub' or 'held' or 'expired' for each email address (depending on the status you want to change them to).

3. In UI, navigate to the Contacts dashboard.

4. Select 'Import Email Contacts' on the top-right. Browse to find your file. Click 'Next'.

5. Map column headers to the appropriate data fields. Click 'Next'.

6. Be sure Action changed to 'Use Type Setting in CSV file'. Click 'Import'.

When import is complete, double check one or two addresses to be changed to make sure they are now listed as the new status.

NOTES

A sample CSV file to see the setup is attached.