Elliot Lee

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.

• Tribe and LinkedIn
• ViralInviter: Allow Visitors to Invite Friends with their Address Books
• Gmail
• Stopping Fraudulent Spam with SPF
• Identity Fraud on MSN Messenger
• 1 Terabyte (1,000 GB) of Gmail Storage
• Drupal Audio Importer
• Email spam sent to random addresses at a specific domain
• Gmail Open To All
• Audio Cleaning with Audacity and The Levelator