CommentsToSheets

Guides

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:

LinkWhat 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

  1. Paste the link on the Facebook to Excel page or the home page and press Export.
  2. The export page shows comments read next to Facebook's count. Facebook's count includes replies.
  3. 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 Facebookusername in the file
Marta Readsmarta.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 likes column is the reactions on each comment.
  • Stickers, GIFs and photos. A comment with no text has an empty comment cell.

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

QuestionFormula (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 allIn 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.