Convert GNU Mailman output to tab-separated file for MailChimp

gistfile1.py

#!/usr/bin/env python

# Assumes a file called mailman.txt in the working directory,
# generated by: `list_members -p -f -n enabled -o ~/mailman.txt news`

import csv
import re

with open('exported.tsv', 'wb') as csvfile:
    csvwriter = csv.writer(csvfile, delimiter="\t")
    with open('mailman.txt', 'r') as f:
        for line in f:
            stripped = line.strip()
            matches = re.match(r'^"*([^"]+)"* <(.+)>$', stripped)
            if matches:
                email = matches.group(2)
                name = matches.group(1)
                name = re.sub(r'\\([()])', '\g<1>', name)
                csvwriter.writerow([email, name])
            else:
                csvwriter.writerow([stripped])