How can I view or export all members of my mailing list?

Although you can use Mailman's "Membership Management" pages to view subscribers, those pages only show up to 30 members at a time.

You can use a different section of the Mailman pages to see all members on one page. To do this, you'll visit the public list management page and use the section at the bottom, marked "Viewing (Your List Name) Subscribers".

If you aren't sure where your public list management page is, these instructions will help:

  1. Login to the account management control panel.
  2. Click E-Mail Options.
  3. Click show mailing list details to the right of the list name.
  4. Click the first list link to use the Mailman administration pages.
  5. Login to the mailing list if necessary.
  6. Click Go to the general list information page (top of the page, right-hand column).
  7. Scroll to the bottom of the page, to the "Viewing (Your List Name) Subscribers" section. Enter the list administrator's email address and the list password, then click Visit Subscriber List.

The resulting page will show you all of the members of the mailing list.

If you need to actually copy the addresses, but they're shown with the word "at" instead of a normal @ sign, you can change that:

  1. Go back to the Mailman administration pages.
  2. Click Privacy Options and scroll to the bottom of the page.
  3. Change "Show member addresses so they're not directly recognizable as email addresses?" to No.

How can I export the addresses to a CSV or Excel file?

Each time we make a backup, we save a file named subscribers.csv as part of that backup.

You can use the File Manager to download that backup:

  1. Login to the “My Account” control panel
  2. Click File Manager
  3. Click Browse Backups Directory (it may take a few seconds to load)
  4. Click the most recent backup (the first one in the list)
  5. Click mailman
  6. Click the list name, then click the list name again
  7. Click subscribers.csv

You can then view or download that file.

If you want to convert it to an Excel spreadsheet, simply open the “.csv” file you saved in Excel.