WordPress: Export Emails Of All Commenters

I managed to export the email addresses of all commenters on a WordPress blog so that I could check if they’re using Twitter. This is fairly straightforward to do:

1. Using phpMyAdmin, export to CSV.

2. Using Excel, clean up the list:

2a. Import and set semicolon as the delimeter.

2b. Take the email addresses column.

2c. Filter to Unique entries only.

2d. Sort and remove the rows which are invalid email addresses (or not email addresses at all).

3. Use Notepad2 to change it into Gmail’s contact .csv format.

4. Import it on a Gmail account, and then use that Gmail account’s login on Twitter to see who’s in.

In my case, 23 people were already on Twitter :) I didn’t invite any who weren’t already on.

3 thoughts on “WordPress: Export Emails Of All Commenters

  1. U just save my life my man !! I’ve tried it, successful ! Now, i have more that 2, 000 emails extracted from my website.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>