Here is a method to extract your data friend data from Facebook. If you are thinking about deleting your Facebook account you might want to do this first. That way you will have your the contact info for your high school friends that you have never e-mailed anyway.

Step 1 - Extract the e-mail addresses

For many people, this will be the only step needed. Go to Yahoo mail and login or create an account. http://mail.yahoo.com Go to Contacts in the middle of the upper right hand pane. Click Import Now in the middle of the right hand pane. Click the Facebook icon and then Ok to share with Yahoo. Click Done. You now have the names and e-mail addresses of all your Facebook friends in Yahoo mail.

Step 2 - Export the e-mails

From the Tools menu just below the tabs choose Microsoft Outlook > Export Now. Enter the captcha and click Export Now. This will save the file 'yahoo_ab.csv' to your hard drive.

Step 3 - Export Facebook friend data Login to Facebook and then go to this url: http://apps.facebook.com/friendstocsv/?ref=ts Click all the checkboxes and then click Create CSV File. This will save the file 'friends_of_123456.csv' to your hard drive.

Step 4 - Combine the e-mail and other data Open 'yahoo_ab.csv' and 'friends_of_123456.csv' in Excel. In cell BC2 type:

=B2&D2

Then double click the lower right of that cell to paste the formula down the column. Next, go to 'friends_of_123456.csv'. Go to cell R1 and type "email" for the column header. In R2 and type or paste:

=VLOOKUP(C2&B2,yahoo_ab.csv!$BC:$BD,2,FALSE)

Copy R2 to the clipboard and paste it down column R. You now have a good copy of the data. You can import this into your email program, pim, crm, etc.

Some optional steps

Step 4 - get picture urls Go to S1 and type "picurl" for the header. In S2 type or paste:

="<a href="""&P2&"""><img src="""&Q2&""" alt="""&D2&"""></a>"

Then copy S2 down the rest of column S. You now have the urls for pictures of all your Facebook friends. You can paste that into a page like this Tom's Facebook Friends