From Facebook to Excel in three steps
- On the Page post, open the post, tap Share, then Copy link.
- Paste the link into CommentsToSheets and press Export.
- Download the Excel workbook: Comments, Commenters, Mentions, Per day, Hashtags and a Read me sheet.
The link looks like facebook.com/yourpage/posts/…. Only public posts can be read.
What the workbook holds
The Excel download is a workbook, not a single list:
- Comments: every comment and reply,
posted_at_utc as a real date, ids kept as text.
- Commenters: one row per person with comments, replies, likes received, first and last comment time.
- Mentions: every tagged account, how many comments tag it and how many different people did.
- Per day and Hashtags, ready for a chart.
- Read me: the post link, the network, when it was read, comments read next to the count Facebook shows, and what every column means.
Header rows are frozen and filterable, so sorting by likes or filtering to replies is one click.
What to know about Facebook
Public Page posts with up to 300 comments export free. Facebook shows commenters as names, not handles, so the username column holds the name plus four characters that tell two people with the same name apart. Group posts and private profiles are not read.
Above the free limit you see the first comments as a labelled preview, and one payment for that post reads the rest: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments. The same passes apply on every network; there is no subscription.
The columns
#, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform. The platform column says facebook on every row, so exports from Instagram, TikTok, YouTube and Facebook can sit in one sheet and still be told apart.
Questions
How many Facebook comments are free?
Up to 300 per Page post, every one of them. The limit is a number of comments, not a time limit.
Do I log in to Facebook?
No. You paste a link to a public post. Nothing asks for a password and nothing is installed.
Are replies included?
Yes, each on its own row with the comment it answers. On a free export reply threads are read up to a limit and the page says how many replies were not read; a pass reads them all.
Can it check who follows the account?
No. Follows cannot be checked from the comments on Facebook, and this file never claims to. It lists who commented and what they wrote.
Why does the username column show names?
Facebook shows commenters by name, not by handle. Four extra characters keep two people with the same name apart, and mentions are only the @handles typed into the text.
Why are there fewer rows than Facebook shows?
Facebook's count includes comments it hides from everyone, such as spam-filtered or deleted ones. Nobody can read those. The export page shows comments read next to Facebook's number.