3.62. How do I extract (export) a list of my list's members (subscribers)?
The preferred way to do this is via the command line tool bin/list_members, but many list owners do not have access to this tool.
Here are the other ways to get a membership list.
- Use the email 'who' command. Send blank email with subject 'help' (without the quotes) to the <email@example.com> address for more info.
- Visit the roster via the listinfo page (or if you are already logged in, directly at something like <http://www.example.com/mailman/roster/listname>) and copy/paste/edit the result.
The above two methods have the drawback that 'hidden' members (those who have opted to be excluded from those lists) are not shown (this drawback was removed in Mailman 2.1.10 for those who authorize with a list admin/moderator password). Also, the roster shows only email addresses, not names. The 'who' result does include names.
- Visit the admin Membership Management...->Membership List pages one by one and copy/paste/edit the results. (Since 2.1.10, you can set admin_member_chunksize on the General Options page to a number larger than the number of list members to see the whole Membership List on one page - not recommended for large lists.)
- Script the above process to automate it. See <http://starship.python.net/crew/jwt/mailman/#throughtheweb> for an example. Note that this script still works with Mailman through at least 2.1.14, but for 2.1.10 and later, it prints %40 instead of @ in email addresses. An updated version of this script is available at <http://www.msapiro.net/mailman-subscribers.py> and <http://fog.ccsf.edu/~msapiro/mailman-subscribers.py>. This revised script addresses the issue above and additionally, can extract essentially all the member flags and other member info except preferred language from the Membership List pages into a CSV format file for import to a spreadsheet. The revised script also has an option to reset the 'hidden' flag for all members. You can use a small shell script to do this for all lists on your server <http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists>
Converted from the Mailman FAQ Wizard
This is one of many Frequently Asked Questions.