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 Python.
Sometimes, we wish we could easily download all the comments from a particular Facebook post. There is no way you can directly do it with Facebook.
Here are the exported comments from one of our Facebook posts.
Benefits of exporting Facebook comments to Excel file
- Organizing a competition and selecting a winner at random from the comments.
- Find 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
We will use two free websites named Comment Picker and Export Comments to download FB comments in an Excel or CSV file.
In these programs, enter the post’s URL, and you can extract the comments. Besides, if you use one of the programs mentioned below, you can also extract comments from your 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 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 post 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 to an Excel file in CSV format. 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.
• If 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. 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.
It adds all the comments to the CSV file, along with the poster’s name, the date and time, and the number of likes on that comment.
In this tutorial, we shared how to export Facebook comments in an Excel file. Using these tools, you can download comments from any Facebook post that you want to an Excel file. Once exported, you can examine and analyze the data per your needs and requirements.