Twitter lists are nothing new, but yet they are often over looked by many Twitter users. However, management of your Twitter lists can be very cumbersome…especially if you have a HUGE amount of followers to sift through. And you don’t want too waste too much time on social media. Don’t sweat it, I will show you how you can easily take control of your lists and what is possible with segmented Twitter lists in a few simple steps.
Getting Your Twitter Data
To easily manage this process, I will be using Microsoft Excel to to manipulate the data, but first we need to get the data into Excel. There are many tools that allow you to export your your data from Twitter. Some paid, some free. When possible I like to use free options, however, here are several methods to get your Twitter data.
While Followerwonk is a paid solution, if you have a MOZ account, it is included as part of your membership. Since I have a MOZ account, I will be using Followerwonk to export my Twitter data. Please note that each export service may not export the same data as another service. For example, the Google Docs spreadsheet does not currently export the location of the user. Depending on what you want to accomplish with your lists, this may need to be something to take into consideration.
When you export your data, be sure to export it in CSV/XLS format and not a PDF. If you use Google Docs, you can simply copy/paste your data into Excel. Read more »