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

saving contact lists as .csv

Discussion in 'FaceBook' started by sipyspam, Feb 28, 2010.

  1. sipyspam

    sipyspam Newbie

    Joined:
    Jan 28, 2010
    Messages:
    35
    Likes Received:
    0
    I am currently having trouble uploading .csv lists. I create the lists in OpenOffice and save as .csv but whenever I upload them I get errors. Does anyone know any free alternatives to excel to make .csv files or know what the problem might be?
     
  2. kaidoristm

    kaidoristm Power Member

    Joined:
    Feb 13, 2009
    Messages:
    561
    Likes Received:
    726
    Occupation:
    Freelancer
    Location:
    Estonia
    Home Page:
    Do you have problem with uploading or creating a file?
     
  3. sipyspam

    sipyspam Newbie

    Joined:
    Jan 28, 2010
    Messages:
    35
    Likes Received:
    0
    Both I guess. I save it as .csv and it says "Only the active sheet was saved". It is still a .csv file though and uploading it I get a error.
     
  4. Cutlass

    Cutlass Newbie

    Joined:
    Apr 22, 2009
    Messages:
    5
    Likes Received:
    0
    By default in Excel or Open Office, there are 3 sheets open. I know that in Excel you simply need to close those sheets. They're tabbed at the bottom.


    So just close those sheets and you'll be good ;)
     
  5. sipyspam

    sipyspam Newbie

    Joined:
    Jan 28, 2010
    Messages:
    35
    Likes Received:
    0
    that fixed my error for saving it but still when I try to upload it I get either "Please check back soon and try uploading your contact file again.
    Click here to go home." or it works and when I click send invites it goes to a white screen.
     
  6. dietbird

    dietbird Junior Member

    Joined:
    Nov 3, 2009
    Messages:
    126
    Likes Received:
    64
    Simply download a cracked version of the newest microsoft office. Works like a charm for me.
     
  7. Cutlass

    Cutlass Newbie

    Joined:
    Apr 22, 2009
    Messages:
    5
    Likes Received:
    0
    Are you adding your contacts into a column and not a row?

    Better off searching for the Enterprise "Blue" Edition ;)
     
    Last edited: Mar 1, 2010
  8. rado84

    rado84 Newbie

    Joined:
    Apr 10, 2008
    Messages:
    24
    Likes Received:
    9
    If you are uploading the CSV to gmail you need it in this format:

    Email address:
    email@somemail.com
    email2@somemail.com
    ...

    one email per line, but the first line must start with Email address:

    If you have a plaintext file with email addresses one per line,just add them in Excel (no matter the version) in the format I told you and save them as .CSV.
     
  9. sipyspam

    sipyspam Newbie

    Joined:
    Jan 28, 2010
    Messages:
    35
    Likes Received:
    0
    Ok I am using excel and I am still having this problem. This is what my list looks like and this is the error. Also even though I upload them and I get a error after a couple of tries it says I have uploaded too many files and i can't upload anymore for a few hours or days.

    [​IMG]

    [​IMG]
     
    Last edited: Mar 2, 2010
  10. dietbird

    dietbird Junior Member

    Joined:
    Nov 3, 2009
    Messages:
    126
    Likes Received:
    64
    Maybe the formatting is your problem.

    Try removing the Name and email ID rows.

    Also, try placing the emails in the first column.

    P.S. You can also paste all the emails in notepad and simply save it as contacts.csv; works the same and no cell formatting to worry about.
     
  11. Big_0n3

    Big_0n3 Senior Member

    Joined:
    Dec 2, 2009
    Messages:
    1,109
    Likes Received:
    85
    Now many rows do you have in the .csv document? I have also this problem. When i upload a document with 6000 rows i get this error once and after i upload again no error. If i try to upload an document with 8000 rows i get this error twice and than i can upload it.