How To Create A Searchable Yellow Pages From Your Twitter Followers CSV Export

Today I’m going to show you a pretty cool trick that allows you to create a Yellow Pages-type directory from your Twitter followers, just by using the export function within SocialSafe and applying some fairly simple Microsoft Excel filters.

People often use Twitter to try to connect with and find people who may be able to help them in some way, and you’re more likely to get a response to a DM than you would if you just posted a lone tweet into the vastness that is Twitter.

Here’s what to do:

(Before you start, make sure you sync your SocialSafe journal so that you are working from the most recent data)

  1. From SocialSafe, use the left hand navigation to go to Accounts

  2. Click on ‘Select content to view’ and then click on ‘Followers’
  3. Click ‘Export’ and select where you’d like to save the CSV file on your machine

    The rest of the instructions refer to Microsoft Excel, but it should be easy enough to work out the equivalent functions for other applications.

  4. Once you’ve opened the worksheet, add filters to the columns by clicking (from the ‘Editing’ section of the Home tab) ‘Sort & Filter’ > ‘Filter’.
  5. Locate the ‘Description’ column (usually E) and from the drop-down menu select ‘Text Filters’ > ‘Contains…’
  6. Enter your keyword (perhaps ‘marketing’, ‘journalist’ or ‘C++’) and hit ‘OK’.

Hey-presto, you have now found everyone following you who has your keyword in their description. You can also refine this by applying the same filtering logic to other columns, such as ‘Location’. If you were on the hunt for key influencers or wanted to see how much their opinion may be worth, you can also sort your filtered results by how many followers they have.

I’ll be the first to admit that it’s by no means perfect, nor is it an exact science. But once you know what you’re doing with the filters it’s easy enough to play around with the search terms to find people who may be able to help you in a neat and timely fashion.

We hope you find this guide to be useful, and if any of you out there have managed to come up with your own uses for exported data from SocialSafe, please share them with everyone else by leaving a comment.


  1. Woah! I’m really enjoying the template/theme
    of this site. It’s simple, yet effective. A lot of
    times it’s hard to get that “perfect balance”
    between usability and visual appeal.
    I must say that you’ve done a very
    good job with this.
    Also, the blog loads super fast for me on Internet
    explorer. Superb Blog!

  2. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now
    each time a comment is added I get four e-mails with the same
    comment. Is there any way you can remove people from that service?
    Bless you!

  3. You actually make it seem really easy with your presentation but
    I to find this topic to be actually something which I feel I might by no means understand.
    It seems too complicated and very huge for me.
    I’m taking a look forward in your subsequent post, I will try to get the
    hold of it!

  4. Hi there! This post couldn’t be written any better! Reading
    this post reminds me of my old room mate! He always kept
    chatting about this. I will forward this write-up to him. Pretty sure he will
    have a good read. Many thanks for sharing!

  5. Usually I don’t read article on blogs, but I wish to say that this write-up very
    forced me to take a look at and do so! Your writing taste has been surprised me.
    Thank you, very nice article.

  6. Nice blog! Is your theme custom made or did you download it
    from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out.

    Please let me know where you got your design. Many thanks

  7. My partner and I stumbled over here from a different web
    page and thought I may as well check things out. I like what I see so i am just following you.
    Look forward to exploring your web page repeatedly.

  8. Wow that was strange. I just wrote an extremely long comment but after I clicked submit my comment didn’t
    appear. Grrrr… well I’m not writing all that over again.
    Anyhow, just wanted to say superb blog!

  9. We’re a gaggle of volunteers and starting a brand new scheme in our
    community. Your website provided us with valuable info to work on.
    You’ve performed a formidable job and our whole group will probably be grateful to you.

  10. I don’t know whether it’s just me or if everyone else experiencing issues with your site.
    It appears as though some of the written text on your
    posts are running off the screen. Can somebody else please comment and
    let me know if this is happening to them as well?

    This might be a problem with my browser because I’ve had this happen before.

Comments are closed.