Delete contacts in an email list using an Excel file

One of the options to delete a contacts from your email list is by using an Excel file. You can use files of the .xls or .xlsx type up to 40 MB in size.

To delete contacts using an Excel file:

  1. In the top navigation bar, hover your mouse over the Audience tab, and then click Email lists.
  2. Click on the email list name from which you want to delete contacts.
  3. In the menu, click Perform bulk actions.
  4. On the Choose Bulk Action page, navigate to Delete List Members and click Select.
  5. In the pop-up dialog box that appears, navigate to the Excel File option and click Select.
  6. On the Data selection tab, click Browse to select the Excel file you want to import from your computer. Then click Next.Snag_25d165.png
  7. On the Data Mapping tab, click each drop-down list and select the default fields or a custom field. If you want to map a specific column to a field, click the Map to drop-down list, then click the field to use, and click Next.

    Note: If you have not mapped all the fields, a notification appears asking if you want to ignore any columns that remain unmapped. Click Ignore and continue.Snag_28cd50.png

  8. On the Notification tab, select if and how you want to be notified once the delete process has been completed. Select Apply to all email lists if you want the deletion process to be applied to all your email lists simultaneously.  Click Delete when you are ready to start the process.Snag_248165.png
  9. A pop-up dialog indicates that your requested delete operation has been successfully queued. To view a report of your import's progress, click Go there.Snag_231207.png
  10. Click View reports to see the details of when the delete operation started or finished and how many members were deleted.Snag_228b14.png