You want to see a list of the people that like your Facebook page? You want to copy and sort the lists? OK so I figured out how.

Please credit this to the curious-engineer part of my nature rather than anything to do with creepy or stalker! And I will admit that once you are over a few hundred fans this really would be slow stalker territory, but if you really want to know, here is ‘how to’:

-         Go to your fan page.facebook-see-who-likes-page

-         Look for the fan count in the left sidebar

-         Click on the link ‘like this’ under the counter

-         The Insights page will come up

-         Over on the right, there is a little link that says ‘See Likes’. Click on it.

-         Click on the drop-down, and select ‘Pages’

-         Nice and Easy!

If you want to export the lists of people or pages (use the drop down in top left of the pop up window), there is no export button, but you can do it. It takes a couple of minutes. If anyone has a better export strategy, let me know!

-         Click and drag within the box to highlight everything (names and logos)

-         Right click on part of the highlighted text.

-         CTRL ‘C’ to copy

-         Open up a spreadsheet

-         CTRL ‘V’ to paste

Yeah, so it looks like a mess, and not even a hot mess! But it can be edited…widen the first column…delete the second column which is now full of ‘submit’ buttons…Data/Sort the first column…copy the rows with text in the to a new spreadsheet (which loses most of the icons)… right-click on each of  the remaining icons to delete them individually

  • http://twitter.com/jaynalocke jaynalocke

    I love “how to” posts like this. It’s one of those things you know you’re going to need at some point! I use content curation as a way to collect and re-share great content. So this will go on StumbleUpon and Scoop.it!

    • http://www.abigailgorton.com/ Abigail Gorton

       Thanks Jayna, I certainly appreciate you sharing!

  • http://www.howwhowhen.com/ Howie

    I only have five fans so Facebook just shows me the list of fans instead of going to the insights page. LOL.

    • http://www.abigailgorton.com/ Abigail Gorton

       Howie, You need to start publicizing your posts and your page.! LOVE your content – it deserves a wider audience. :-)

  • http://twitter.com/tphungster Tori Phung

    As a marketer, I flip back and forth on stuff like this because its great to know exactly who your customers/fans are, but as much as companies are looking to reward loyalty, they can’t creep their customers out. I guess that’s why so many companies are doing these “like us on Facebook and win…” campaigns so customers kind of volunteer themselves.

    • http://www.abigailgorton.com/ Abigail Gorton

       Good point! I am not sure what I would use the list for… If a friend /client / contact has stopped following, I am not sure that I want to find that out and take it personally. If people start engaging with the posts, I can always click on their FB link to see if there might be a business that I want to follow back. My thing is – I just can’t pass a piece of software by without trying to figure out how and why it does what it does – what the algorithm is? So I ‘needed to know HOW to access this more than I needed to access it. Oh well!

  • Guest

    Only problem is that it is limited to 500. I would like to know of a way to copy and paste all of them.

    • http://www.abigailgorton.com/ Abigail Gorton

       Hmm… I have googled it and seen some scripts you can run. I wasn’t motivated enough to test them out, but they are ‘out there’, in every sense of the words.