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

Inviting a contact list..

Discussion in 'FaceBook' started by Peter Shaw, Mar 5, 2010.

  1. Peter Shaw

    Peter Shaw BANNED BANNED

    Joined:
    Sep 1, 2009
    Messages:
    902
    Likes Received:
    359
    Hello everyone. I'm trying to make a contact list in excel to upload to facebook and add the people as friends.

    But the list of emails i have at the minute at like: email1@gmail.com, email2@gmail.com, email3@gmail.com, email4@gmail.com, email5@gmail.com, ETC.

    When i paste all the emails (around 4,000) into one cell on excel, it pastes them all into the same cell. I want to know how i can make them past into a new cell, on the next line (i.e B2, B3, B4, B5) So every time there is a comma, it starts a new line :)

    If you get what i mean, and you can help, please post :)
    Thanks!
     
  2. dashad

    dashad Newbie

    Joined:
    Mar 10, 2007
    Messages:
    30
    Likes Received:
    91
    Location:
    Germany
    hey,

    i would do this with notepad++. just search for "," and replace with "/n".
    dont forget to check enhanced setting there and you have every email in a new line
     
  3. Peter Shaw

    Peter Shaw BANNED BANNED

    Joined:
    Sep 1, 2009
    Messages:
    902
    Likes Received:
    359
    Ah thanks. I knew about the /n just didn't know i had to use Notepad++, well i've never heard of it before :p
     
  4. dashad

    dashad Newbie

    Joined:
    Mar 10, 2007
    Messages:
    30
    Likes Received:
    91
    Location:
    Germany
    it's like ultimate version of windows notepad. i use it a lot it has many good text editing features like delete blank lines.
     
  5. Peter Shaw

    Peter Shaw BANNED BANNED

    Joined:
    Sep 1, 2009
    Messages:
    902
    Likes Received:
    359
    I've tried to upload the contact list, but it says "Everyone on this contact list is already on Facebook or has already been invited.
    Would you like to try another email account or file?"
     
  6. tanay46

    tanay46 Registered Member

    Joined:
    Jun 1, 2009
    Messages:
    91
    Likes Received:
    88
    You probably got the error cause your contact file wasn't created properly. Make sure you saved it as a csv, and then try again.
     
  7. Peter Shaw

    Peter Shaw BANNED BANNED

    Joined:
    Sep 1, 2009
    Messages:
    902
    Likes Received:
    359
    I've got it working now :)
     
  8. senso851

    senso851 BANNED BANNED

    Joined:
    Jan 6, 2009
    Messages:
    133
    Likes Received:
    125
    Argh thanks,was looking for a solution of this :)
    Couldn't find anything on google but i found it here.
    Thanks
     
  9. RicherJack

    RicherJack Registered Member

    Joined:
    Oct 20, 2009
    Messages:
    96
    Likes Received:
    27
    Occupation:
    Full-Time IM'er
    Location:
    United Kingdom
    It needs to be in the following format:

    Email1
    Email2
    Email3
     
    • Thanks Thanks x 1
  10. PlatinumPi4u

    PlatinumPi4u Junior Member

    Joined:
    Mar 5, 2010
    Messages:
    168
    Likes Received:
    29


    Muahaha haha hahahaha...... :sgrin: