How can I export my Twitter followers into a CSV/Excel file for free

By October 14, 2019 Social
how to export followers in CSV

Exporting your Twitter followers should be an easy job. It is just like asking a bank for your own financials.

Twitter does provide you with an option to export Twitter followers from your own account in JSON format. Reading the data in JSON format is a bit troublesome and requires you to first unzip the downloaded folder and after that open the individual JSON files in a text editor.

If we talk about the followers list, we are only provided with a profile link and Twitter account ID of individual followers.

However, it is a really straightforward procedure and I am going to mention the steps involved in exporting the Twitter follower list from your own account. I will also mention a paid method which will allow you to export Twitter followers from any public Twitter account using FollowersAnalysis.

These steps are for exporting your followers from the Twitter desktop website.

1:Log into Twitter.
2:Click on ‘More’.
3:Click on ‘Settings and privacy’.
4:In the window that appears, click on ‘Your Twitter data’.
5:Input your Twitter password when prompted.

If you are on a Mobile device, please follow these steps:

1: Open the Twitter app and after logging in, click on the profile picture situated on the upper left corner.
2: On the hamburger menu, click on ‘Settings and privacy’, and after that, click on ‘Account’.
3: In the ‘Account’ menu, click on ‘Your Twitter data’.
4: The final step is to click on ‘Your Twitter data’ and you will be provided with a link which will allow you to download all your Twitter data.

The data is not instantly generated and Twitter takes a few days to accumulate your data and you will get a download link at your Twitter registered e-mail ID after this process is completed.

Once the data is downloaded, you can see that there is a list of various metrics under which you have to individually view the information.

This is a sample data sourced from Twitter’s website. As you can see, the information is in a plain text format with account ID and account link only.

Although this is a good start, but it doesn’t accomplish your purpose. You still have to manually input each user ID to identify followers which I believe is Impractical.

Steps to export Twitter followers list for any public account via FollowersAnalysis

These are the steps for downloading followers list using FollowersAnalysis.

1: Go to www.Followersanalysis.com.

2:Type in the Twitter handle of the profile for which you wish to download the data and click on submit. Login to your own Twitter account if prompted.

3:The next page will immediately give the required account details and provide you with a cost estimate. Kindly remember that the cost varies as per the account information.

4:Click on “Add to cart” and after that, click on “View cart”.

5:Once the amount is displayed, you can make the payment and the report will be ready to download within seconds.

These steps will allow you download follower data in CSV (Excel) format along with various other useful analytical insights (in PDF).

An insight into the analytical report

When we get the data from FollowersAnalysis, we can see that the data downloaded from Twitter pales in comparison to the sheer amount of information we get from FollowersAnalysis. Not only the quality of the information, the number of metrics provided by the FollowersAnalysis report is staggering. Let’s take a look into the downloaded report.

  • User Id: Unique ID of a Twitter account
  • Name: Name of the Twitter account
  • Username: Username of the Twitter account
  • Twitter Joined Date (UTC): Date of Twitter account creation
  • Verified or Non-verified: Whether the Twitter account is verified or not
  • Bio: Bio of the Twitter account which is mentioned in its Twitter profile
  • Location: Location which is mentioned by the Twitter account
  • Website: URL of website mentioned by the Twitter user
  • Tweets Count: Number of tweets posted by the Twitter account
  • Following Count: Number of Following of the Twitter account
  • Followers Count: Number of Followers of the Twitter account
  • Lists Count: Number of lists in which the Twitter account is added by other Twitter users
  • Likes Count: Number of tweets which are liked by the Twitter account
  • Profile URL: URL of the Twitter account’s profile
  • Profile Picture URL: URL of profile picture of the Twitter account
  • Protected or Non-protected: Whether the Twitter account is protected or not
  • Last Tweet Date (UTC): Date and time of last tweet posted by the Twitter account

These are the metrics provided by the FollowersAnalysis report. Comparing it with the information provided by Twitter, you will find that FollowersAnalysis report is like a goldmine of information!

It’s like hitting a jackpot of Twitter information.

Analytics derived from the analytical report

The report consists of statistics which are beautifully illustrated. Let’s delve deeper into the analytics which are derived from the CSV report:

 1: Followers and following last tweet date


This is a very crucial metric that is derived from the report. The last tweet date verifies since when the account is not doing any activity. This metric shows us which of your followers are fake based on their level of activity.

2: Account age of followers


The Twitter account age of followers shows you what percentage of your followers created their Twitter account in any given year. This can help you in differentiating the number of accounts which are relatively new. The greater the account age, the greater its credibility.

3: Tweets count of Twitter account followers


The graph shows the number of followers of the Twitter account divided as per their own tweets count. It comes under “Tweets Count” tab of exported raw CSV list. Accounts with zero tweets are dormant and considered as spam or fake.

4: Followers count of Twitter account followers


This analytic shows us the popularity of followers of your Twitter account. Accounts with zero followers count are considered as fake accounts.

5: Followers verified and protected percentage


Profile verification status confirms that a Twitter account is authentic. It shows that the account is indeed genuine. Accounts which are protected carry out hidden activities such as posts which may not be visible to people outside the group.

6: List of top followers and following


We can find the most popular and most active followers of a Twitter account along with the followers with maximum number of likes and followers list.

Applications of the analytical report

There are various applications for the report generated through FollowersAnalysis. From understanding your Twitter follower base to reading engagement patterns, everything can be achieved by just reading the report. I am going to write a few other applications of this report.

1:Get information regarding the audience behavior such as engagement ratio which is otherwise not visible on Twitter.
2:Identify if an individual has fake or bot followers by looking at various parameters such as follower account age and activeness on Twitter.
3:Get various other Twitter follower details such as client source, languages spoken and other intricate details which are not visible by any other method.

Conclusion

We can see from the above information that the analytical reports have a significant amount of information as compared to the report provided by Twitter. The report generated is thorough and insightful which allows you to draw constructive conclusions.

With this, we come to an end of our article. Stay tuned for more informative articles such as this.

Adios!

Summary
Review Date
Reviewed Item
FollowersAnalysis
Author Rating
51star1star1star1star1star

Leave a Reply