How to export Facebook Page post comments
Facebook comments differ from every other network in one way that changes how the spreadsheet works: people comment under their names, not under handles. This guide covers the export, the two kinds of post that cannot be read, and the formulas that cope with names.
Updated Nov 19, 2026 · 6 min read
Links that work
The post has to be on a public Page: a business, a brand, a creator, a publication, a club. These link shapes are accepted:
| Link | What it is |
|---|---|
facebook.com/yourpage/posts/pfbid0abc… | A post on a Page. |
facebook.com/permalink.php?story_fbid=…&id=… | The older permalink form of the same thing. |
facebook.com/photo/?fbid=… | A photo post. |
facebook.com/yourpage/videos/… or facebook.com/watch/?v=… | A video. |
facebook.com/reel/… | A reel. |
facebook.com/share/p/…, /share/v/…, /share/r/… or fb.watch/… | What Share, Copy link gives in the app. |
Links from m.facebook.com and business.facebook.com work as well. If a share link is refused, open it in a browser, let the post load and copy the address from the address bar.
Why group posts and personal profiles cannot be read
Groups. A group's posts are shown to people who are logged in, and in most groups only to members. The export here never logs in to Facebook, on purpose: with no login there is no account to lock, nothing to authorise and no way for the tool to act as you. The cost is that anything Facebook shows only to logged-in members is out of reach. Public groups are not read either: a group link is refused when you paste it, instead of returning a partial list.
Personal profiles. A post on someone's own profile is a personal post even when its audience is set to Public. The people commenting under it are that person's friends and family, and they did not comment on a public Page. Those posts are not read.
If you run the group or own the profile, the practical route is to publish the post you want analysed, such as a giveaway or a product question, on your Page and point people there.
Export the post
- Paste the link on the Facebook to Excel page or the home page and press Export.
- The export page shows comments read next to Facebook's count. Facebook's count includes replies.
- Take the ten-sheet workbook, a CSV, or paste into Google Sheets from the Facebook to Google Sheets page.
Page posts with up to 300 comments export free. On a free export every top-level comment is read and reply threads are read up to a limit; a paid export reads far more reply threads, within a budget. The export page and the Read me sheet say how many replies, if any, were left unread. Options for bigger posts are on the pricing page.
Names, not handles
Facebook shows a commenter as "Marta Reads", and there can be many people with that name. So that one row per person still means one person, the username column holds the name in lower case with full stops for spaces, plus four characters taken from the account's ID:
| Shown on Facebook | username in the file |
|---|---|
| Marta Reads | marta.reads.7c1e |
| Marta Reads (someone else) | marta.reads.b204 |
| Fernhill Market (the Page) | fernhill.market.19af |
The four characters are the same every time the same account is read, so counts per person and duplicate checks work across exports. To show a readable name in a report, strip the ending in a helper column (column M holds platform, so use N):
=PROPER(SUBSTITUTE(LEFT(C2, LEN(C2)-5), ".", " "))
That works in Excel and Google Sheets and turns marta.reads.7c1e into Marta Reads. In Google Sheets, a version that only strips the ending when it is really there:
=PROPER(SUBSTITUTE(REGEXREPLACE(C2, "\.[0-9a-f]{4}$", ""), ".", " "))
Keep counting on username or user_id, never on the readable name, or the two Martas merge into one.
Why the mentions column is mostly empty
On Instagram and TikTok a tag is typed as @handle, which is plain text. On Facebook, tagging a friend inserts their name as a link, and the text of the comment just reads "Priya Plans look at this". There is no handle in it. The mentions column holds the @handles that were typed as text, so on a Facebook export it is filled only when someone wrote an @ by hand.
Two consequences:
- The workbook's Mentions sheet will be short for a Facebook post. That is the data, not a fault.
- A "tag two friends" rule cannot be checked from the mentions column on Facebook. If you run giveaways on a Page, ask for something a spreadsheet can check, such as answering a question, and read how to turn comments into an entry list.
What Facebook hides or counts differently
- Most relevant. Facebook opens a post on the Most relevant view, which leaves comments out. Switch the post to All comments before comparing what you see with the file.
- Hidden comments. A Page can hide a comment. It stays visible to its author and their friends, and to nobody else. The count can still include it.
- The profanity filter and blocked words. Comments caught by a Page's filters are hidden in the same way.
- Reactions. A like or a heart on the post is not a comment and is not in the file. The
likescolumn is the reactions on each comment. - Stickers, GIFs and photos. A comment with no text has an empty
commentcell.
The guide on why the row count differs from the displayed count explains what size of gap is normal.
First formulas for a Facebook export
| Question | Formula (Excel and Google Sheets) |
|---|---|
| How many people commented? | The number of rows in the Commenters sheet: =COUNTA(Commenters!A:A)-1 |
| How many comments did the Page answer? | =COUNTIFS(Comments!C:C, "fernhill.market.19af", Comments!H:H, "yes") |
| Top-level comments with no reply at all | In N2: =AND(H2="no", COUNTIF(I:I, B2)=0), then =COUNTIF(N:N, TRUE) |
| Comments longer than a sentence | =SUMPRODUCT(--(LEN(Comments!E2:E5000)>=120)) |
Replace fernhill.market.19af with your Page's value from the username column. From here, the sentiment guide and the weekly report guide both work on a Facebook file without changes.
FAQ
Can I export comments from a Facebook group?
No. Group posts are shown to logged-in members, and the export never logs in to Facebook. Only posts on public Pages are read.
Can I export comments from my personal profile?
No. Posts on personal profiles are not read, even when they are set to Public. Publish the post on a Page instead.
Why does the username column end in four odd characters?
Facebook identifies commenters by name, and names repeat. The four characters come from the account ID and keep two people with the same name apart. They are the same on every export.
Why are there fewer rows than Facebook shows?
Facebook counts hidden and filtered comments that nobody can read. On a free export of a busy post, reply threads that were not read add to the gap, and the export page says how many.
Does it work for Facebook reels and videos?
Yes, when they are published by a public Page. Paste the reel or video link the same way as a post link.