How to export Unconfirmed or Blacklisted subscribers

You can export a list of your subscribers, including their unconfirmed and blacklisted status, from the Export Subscribers page.

Select “Any date” at the top, untick “Select all” further down, and then tick the following boxes:

• Email
• Is this subscriber confirmed
• Is this subscriber blacklisted

Click “Export” at the bottom. This will download a CSV spreadsheet containing all your subscribers with only their email address and unconfirmed and blacklisted status.

If you wish to exclude subscribers which are confirmed and unblacklisted, you can sort or filter the data in your preferred spreadsheet application, save the document, and then import the CSV into phpList as a new or updated list.