Facebook has no built-in "export comments" button, and the Graph API only returns comments on Pages you own — no use for competitor research or campaign teardowns of other brands' posts.
This guide exports comments from any public Facebook post, Reel, or video into a clean CSV that opens directly in Excel — one row per comment.
The columns you'll get
The Clean export (default) gives you one comment per row with these fields:
- Author name (display name)
- Username / profile handle
- Comment text (Unicode-safe — emoji and non-Latin scripts render correctly in UTF-8)
- Like count
- Reply count
- Timestamp (UTC)
- Language
- Pinned (TRUE / FALSE)
- Comment ID
- Reply-to ID (which comment this reply belongs under)
- Profile picture URL
Need every raw metadata field? Switch to the Raw export for the full set the API exposes.
Step-by-step
1. Copy the post URL
Any of these public Facebook URL types work:
https://www.facebook.com/{page}/posts/...https://www.facebook.com/reel/...https://www.facebook.com/watch/?v=...andfb.watch/...
2. Open the Facebook exporter
Go to zocialcomment.com/export/facebook and paste the URL — one post per export, each downloading as its own CSV.
3. Click "Export Comments"
The tool counts the thread and shows a preview. Free tier covers 3 posts a day, no signup.
4. Download the CSV
You'll get a UTF-8 CSV download when it finishes.
Opening the CSV in Excel without breaking emoji
- Open Excel first (blank workbook)
- Data ribbon → From Text/CSV
- Pick your downloaded file
- Set File Origin to
65001: Unicode (UTF-8) - Set Delimiter to
Comma, then Load
Mac Numbers and Google Sheets handle UTF-8 automatically — just double-click.
Useful Excel formulas
Keep only comments with at least 1 like
=FILTER(A2:K1000, D2:D1000>=1) (assuming Like Count is column D)
Score comments by engagement
=D2 + (E2 * 3) — weights replies 3× since a reply takes more effort than a like. Sort descending to surface your best comments.
Count mentions of your brand
=COUNTIF(C2:C1000, "*yourbrand*") against the comment-text column.
Free tier limits
The free tier exports the first 100 comments of any post with no signup and no daily limit. For posts with thousands of comments or bulk campaign work, the 3-Day Pass unlocks unlimited posts for 3 days (up to 10,000 comments per post), and the Pro Pass adds AI comment analysis.
Also exporting other platforms? See Instagram comments to Excel and TikTok comments to Excel.