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

Help cleaning up a gmail csv full of contact information to only have the email addresses

Discussion in 'White Hat SEO' started by loveBHseo, Jun 16, 2013.

  1. loveBHseo

    loveBHseo Registered Member

    Joined:
    Oct 31, 2009
    Messages:
    67
    Likes Received:
    21
    I need help cleaning up a gmail csv full of contact information to only have the email addresses. Whats the easiest way to do this? Notepad++, excel, ???

    Thanks :)
     
  2. jp_smith86

    jp_smith86 Senior Member

    Joined:
    Jul 6, 2012
    Messages:
    855
    Likes Received:
    339
    Location:
    DIL APNA PUNJABI
    Home Page:
    excel..

    First remove the empty rows with filter. Then select all rows in filter containing @.. You will get all email addresses sorted. :)

    EDIT: Let me know if you need my help.. i will do it at no cost.
    :)
     
    • Thanks Thanks x 1
    Last edited: Jun 16, 2013
  3. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    707
    Likes Received:
    267
    Location:
    PHP Scripting ;)
    Check out : idgrabber (website) //Cant post links. Sorry.

    That may do it for you. Just copy paste everything in the CSV to the site. And well, I am not sure if they are going to steal your emails.(If I owned the site, I will be doing that for sure) Well, so try this as your last resort. If I wanted to do this, I would be doing with Regex. Well, thats an overkill for you, at the moment.
     
    • Thanks Thanks x 1
  4. loveBHseo

    loveBHseo Registered Member

    Joined:
    Oct 31, 2009
    Messages:
    67
    Likes Received:
    21
    Edit: BHW is making this on three different lines. Al the messy content is lined up in one long line in the first cell.

    @jp_smith86
    They are all in the first cell together. I cleaned up all the other cells. So it kinda looks like this now.
    -Unnamed,,,Unnamed,,,,,,,,,,,,,,,,,,,,,,*MContacts,,,,,,,Work,job45482166472272@craigslist.org,,,,,,,,,,,,,,,,,,,,,,,,, I need to pull the email out of this mess. I don't care for the rest. :) Thanks for the offer.
     
  5. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    707
    Likes Received:
    267
    Location:
    PHP Scripting ;)
    Did you try the site that I suggested?
     
    • Thanks Thanks x 1
  6. Asif WILSON Khan

    Asif WILSON Khan Executive VIP Premium Member

    Joined:
    Nov 10, 2012
    Messages:
    10,112
    Likes Received:
    28,544
    Gender:
    Male
    Occupation:
    Fun Lovin' Criminal
    Location:
    London
    Home Page:
  7. jp_smith86

    jp_smith86 Senior Member

    Joined:
    Jul 6, 2012
    Messages:
    855
    Likes Received:
    339
    Location:
    DIL APNA PUNJABI
    Home Page:
    Yeah.. Its simple.. firstly filter with containing @..

    do you have team viewer?

    Let me do that for you...

    its just 5 minutes work
     
    • Thanks Thanks x 1
  8. loveBHseo

    loveBHseo Registered Member

    Joined:
    Oct 31, 2009
    Messages:
    67
    Likes Received:
    21
    I didn't use that site. I am not interested in these emails being used for other things besides my campaigns.
     
  9. loveBHseo

    loveBHseo Registered Member

    Joined:
    Oct 31, 2009
    Messages:
    67
    Likes Received:
    21
    There should be a simple method as the way this is created as a csv is simply the way gmail exports the contact information. I didn't do anything else other than export and then clean up all cells that don't have an email address in it.

    If there is a simpler way to export the information from gmail then I'd do that too.
     
  10. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    707
    Likes Received:
    267
    Location:
    PHP Scripting ;)
    Ah, well that was just a guess. Not sure if they are stealing though.
    Try the tool what W130SN suggested. Should do the job.
     
    • Thanks Thanks x 1
  11. loveBHseo

    loveBHseo Registered Member

    Joined:
    Oct 31, 2009
    Messages:
    67
    Likes Received:
    21
    It worked. Thx!