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. Beginning with Mailman 2.1.19, a site can optionally enable the display of names on rosters, but a list admin can't control this.
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 https://www.msapiro.net/scripts/mailman-subscribers.py and https://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers.py. There are now Python 3 versions of the script at https://www.msapiro.net/scripts/mailman-subscribers3.py and https://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers3.py. This script 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. It 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 (If this link doesn't work, get it from the wayback machine)
This is one of many Frequently Asked Questions.