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.

About Andrew Robertson

I'm Andrew, I work as the Social Media & Marketing Assistant at SocialSafe. I've been writing blogs on here for over two years now, so you'll find pieces from me about anything relating to social media and tech, as well as the changing face of personal data. There's also room for the occasional post on some slightly off topics stories... just for the sake of variety!!

22 thoughts on “How To Create A Searchable Yellow Pages From Your Twitter Followers CSV Export

  1. 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.
    Kudos

  2. 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.

  3. 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.

  4. 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.

  5. 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!

  6. 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!

  7. 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!

  8. 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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s