How to Blacklist multiple prospects (bulk update)

In order to prevent multiple email addresses (not domains) from being contacted, you can change their status to BLACKLISTED.

There are 2 ways in which you can accomplish this task: either by changing the status of multiple prospects at once in bulk or by re-importing prospects in a CSV or Excel file.

IN THIS ARTICLE

Blacklisting prospects in bulk
Re-importing prospects in a CSV or Excel file


I. Blacklisting prospects in bulk

BLACKLISTED is a global status. That means that changing the prospect’s status to BLACKLISTED at any place in Woodpecker will change it everywhere (every campaign and main prospect list). Assigning this status means that you do not want this prospect to be contacted in any existing or future campaign. Read more about statuses » and how to change statuses in bulk »

Campaign

  1. Edit your campaign and go to ‘Prospects’.

  2. Checkmark contacts you want to bulk change.

  3. Click the ‘Change status’ icon.

  4. Select ‘BLACKLISTED’ from the list and click ‘save’.

Changing status in bulk step-by-step in Campaign

Prospects database

  1. Open the main Prospects tab.

  2. Checkmark some contact.

  3. Click the ‘Change status in bulk’ icon.

  4. Select ‘BLACKLISTED’ from the list and click ‘save‘.

Gif with changing the status in bulk in the main Prospects tab

II. Re-importing prospects in a CSV or Excel file

1. Create a CSV or Excel file containing two columns:

A. Email – with the email addresses you want to block,
B. Status – with the word BLACKLISTED in each row.

Example prospects with Blacklisted status in Google Sheets file

Make sure that the status is written in uppercase.

2. When the file is ready, open the Prospects menu.

3. Next, click ‘Add prospects’ on the right, and select ‘Import’.

When importing the file to Woodpecker, make sure to select ‘Update the existing contact with changed or new fields’ (otherwise this will have no effect!).

'Import from file

4. Match the columns from the CSV or Excel file with those in Woodpecker.

If you created column headers in the first row, tick the ‘Ignore column headings when importing’ option.

blacklist-multiple-prospects image

If you wish to block entire domains instead, we have a different solution for that.

This guide will take you through the whole process »