The Geeks' Den: How to Backup Facebook Friends/Event Guests/Group Members to .csv for use in Excel

My blog has moved! Redirecting...

You should be automatically redirected. If not, visit http://www.igeekden.com and update your bookmarks.

Tuesday, December 1, 2009

How to Backup Facebook Friends/Event Guests/Group Members to .csv for use in Excel

Friend Export:

http://apps.facebook.com/friendexport/

Data exported: First Name, Last Name, Sex, Birthday, About, Relationship Status, Looking For, With A, Interests, ID, Profile URL

Friend Table:

http://apps.facebook.com/friendtable/

Data cannot be exported to Excel unless you do a cut and paste.
Data exported: UID, name, status, birthday, relationship status, political status

Friends to .csv:

http://apps.facebook.com/friendstocsv/

The format is not very good and the data is not easily sorted or viewed, possibly a vlookup formula in Excel may help to sort the outputed data.

Data exported: Facebook ID, Last Name, About Me, Hometown, Profile URL, Sex, Full Name, First Name, Current Location, Birthday, Picture URL.

Event Guests to .csv:

http://apps.facebook.com/eventgueststocsv/

The format is not very good and the data is not easily sorted or viewed, possibly a vlookup formula in Excel may help to sort the outputed data.

Data exported: Confirmed, Not Attending, Maybe Attending, Awaiting Reply, Facebook ID, Last Name, About Me, Hometown, Profile URL, Sex, Full Name, First Name, Current Location, Birthday, Picture URL.


Group Members to .csv

http://apps.facebook.com/memberstocsv/

Could not get this app to work at this time.
Data exported: N/A.
Data expected: Facebook ID, Last Name, About Me, Hometown, Profile URL, Sex, Full Name, First Name, Current Location, Birthday, Picture URL.

No comments:

Post a Comment