In this tutorial, you will learn how to export Facebook comments from posts in an Excel file. Using methods shared in this tutorial, you will download Facebook comments as CSV or Excel files. So, if you would like to do some data analysis on your engaged users, you can use these methods and use Python to do so.
There are times when we wish we could download all the comments from a particular Facebook post with ease. There is no way you can directly do it with Facebook.
Here are the exported comments from one of our Facebook posts.
Table of Contents
Benefits of exporting Facebook comments to Excel file
- Organizing a competition and selecting a winner at random from the comments.
- Finding out when your audience is active by looking at comment timestamps.
- To create a backup of comments before deleting a post.
- Examine the data in the comments in Excel or CSV.
- Analyze the sentiments of the people who have commented.
- Find top commentators on your page.
- There is no straightforward way to export Facebook comments. For extended comment threads, the manual copy-paste isn’t going to function. This is the reason you may want to use the following tools.
How to Export Facebook Comments From Posts in Excel File
To download FB comments in an Excel or CSV file, we will use two free websites named Comment Picker and Export Comments.
In these programs, enter the URL of the post, and you can extract the comments. Besides, if you use one of the programs mentioned below, you can also extract comments from your own Facebook postings.
The date-time, comment content, number of likes, and number of replies are all included in the final Excel or CSV file generated by these websites.
These tools are also beneficial for performing sentimental analysis. You may download hundreds of comments from any public Facebook post in a matter of seconds.
Let us have a look at them one by one.
1. Comment Picker
Comment Picker is another free tool that allows you to export Facebook comments and commenters’ names to an Excel file. You can log in using your Facebook account, select Facebook pages, and provide rights to see content posted on the page and user content.
Start by choosing a Facebook page. Then enter the Facebook URL or select the Facebook post for which you want to export comments. Select Facebook comment export options. Now select Facebook comments to export.
You may now download and export your Facebook comments in CSV format to an Excel file. You can get the following information from that Excel file:
• Name of the person who commented on Facebook.
• A Facebook remark.
• The number of people who have liked the comment.
• The date on which users commented.
• ID of the comment.
• In case the comment is a reply, you will get the parent Id.
2. Export Comments
Another free website to export Facebook comments to CSV is Export Comments. However, there is a limitation to it. You can only export 500 comments from any Facebook post for free.
It takes the URL of a Facebook post and then lets you export all comments (if there are less than 500) from it. The most excellent part is that you don’t have to sign up or log in via your Facebook account to make it work.
Go to the website and type in the post URL you want to retrieve comments from. It will take a few moments for the post you submitted to be processed. After processing a thread, you will be given a CSV file to save to your computer.
And it adds all of the comments to the CSV file, along with the poster’s name, the date and time of the comment, and the number of likes on that comment.
In this tutorial, we shared how to export Facebook comments in an Excel file. Using any of these tools, you can download comments from any Facebook post that you would like to an excel file. Once exported, you can examine and analyze the data as per your need and requirement.