1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to extract emails out of a huge list?

Discussion in 'Black Hat SEO' started by JayAVee, Jun 26, 2013.

  1. JayAVee

    JayAVee Newbie

    Joined:
    Jun 26, 2013
    Messages:
    14
    Likes Received:
    0
    Okay i have about 100k emails but the problem is they are formatted up like this

    Amanda,LastName,INSERT EMAIL HERE,1275 Address Ave.,Red Wing,MN,55066,6513886397,1/16/2010 21:16,66.xxx.147.35
    Next,line,of,the,exact,same,thing

    Is there anyway to exctract just the emails into a comma separated list? Or at least add them to my mailing list the way they are? I want this so i can start a FB and import my "friends"

    Also if there is a way to extract the phone numbers... Im sure i can do something with those...

    Edit: I want to keep my list i have, I want to extract the emails to a separate list. I know it's a bonus to have names etc.

    Any ideas? Also im really new to this email marketing so if you know a good thread you could point me to for beginners, that would be appreciated as well.
     
  2. Bruut

    Bruut Regular Member

    Joined:
    Aug 9, 2012
    Messages:
    227
    Likes Received:
    149
    You need Microsoft Office Excel or something similar.
     
  3. scrapefox

    scrapefox Power Member

    Joined:
    Dec 3, 2011
    Messages:
    692
    Likes Received:
    277
    Open up Excel -> import the text file under the data tab -> choose the delimited option - >select comma -> next -> finish.

    You'll then be able to copy just the 3rd column and paste it in to a text file. Same with the phone column if you desire.
     
    • Thanks Thanks x 1
  4. Asif WILSON Khan

    Asif WILSON Khan Executive VIP Premium Member

    Joined:
    Nov 10, 2012
    Messages:
    10,139
    Likes Received:
    28,607
    Gender:
    Male
    Occupation:
    Fun Lovin' Criminal
    Location:
    London
    Home Page:
  5. SmartMan

    SmartMan BANNED BANNED

    Joined:
    Jul 25, 2012
    Messages:
    673
    Likes Received:
    1,244
    Follow the scrapefox's method. It's the easiest option unless you want to play with regex or email extractors. And for the Email marketing thread, This is the one and only best thread which is open to the Non-Vip Members : http://www.blackhatworld.com/blackhat-seo/making-money/442600-making-money-email-lists-my-40k-month-strategy.html

    Edit : Download the Maxprog's Email Extractor

    Code:
    http://www.mediafire.com/download/z7hisdyjq8vuk9f/Maxprog_Email_Verifier_and_Extractor.rar
    The software is really easy to use. Simply drag your data file into the software and it'll parse all the emails.

    Source : http://www.blackhatworld.com/blackhat-seo/black-hat-seo/452737-get-maxprog-email-extractor-verifier-serial-incl.html#post4364709
     
    Last edited: Jun 26, 2013
  6. JayAVee

    JayAVee Newbie

    Joined:
    Jun 26, 2013
    Messages:
    14
    Likes Received:
    0
    Okay thank you all i figured it out. Im actually using Google Docs tho.
     
  7. JayAVee

    JayAVee Newbie

    Joined:
    Jun 26, 2013
    Messages:
    14
    Likes Received:
    0
    Okay so i have them all in comma separated values, but when i try to upload to outlook as a csv file, it says empty or invalid format -.-
     
  8. scrapefox

    scrapefox Power Member

    Joined:
    Dec 3, 2011
    Messages:
    692
    Likes Received:
    277
    Once you have them separated in Excel (or Google docs), don't save as a CSV and then try and import, just copy and paste the column you want in to a text file.
     
  9. unbel

    unbel Junior Member

    Joined:
    Dec 10, 2011
    Messages:
    155
    Likes Received:
    39
    I'm pretty sure I've found one on Google before, do online email extractors work?
     
  10. JayAVee

    JayAVee Newbie

    Joined:
    Jun 26, 2013
    Messages:
    14
    Likes Received:
    0
    I can only import a csv file on outlook tho

    Also, on Google docs, the emails aren't comma separated until i save it as a csv. They sit in different rows with no commas
     
    Last edited: Jun 26, 2013
  11. damagro

    damagro Registered Member

    Joined:
    Mar 7, 2013
    Messages:
    88
    Likes Received:
    99
    Publish all the data in a .txt message on your server. Load the txt file in an email scraper and you're done.
     
  12. usdachoice

    usdachoice Regular Member

    Joined:
    Sep 22, 2010
    Messages:
    299
    Likes Received:
    262
    Go to http://textmechanic.com/Merge-Text-Line-by-Line.html paste your first column into text input 1 and them paste your second set of data in input box #2. Then add " , " in the divider box and hit the "merge text lines"

    G Docs usually bombs out on me with that many rows so you can always dl open office calc. If you are in a hurry use the first method I mentioned.

    Edit: I am assuming you know to copy the results and paste them into notepad. Then "save as" all files and name your file whatever.csv
     
  13. john1444

    john1444 Elite Member

    Joined:
    Mar 27, 2012
    Messages:
    2,559
    Likes Received:
    755
    Gender:
    Male
    Occupation:
    Marketer
    Location:
    Miami, FL
    Home Page:
    Scraped emails, you will probably get yourself a ban from your hosting..