How to Export Facebook Comments to Excel (CSV-Ready) in Under a Minute

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:

1. Author name (display name)
2. Username / profile handle
3. Comment text (Unicode-safe — emoji and non-Latin scripts render correctly in UTF-8)
4. Like count
5. Reply count
6. Timestamp (UTC)
7. Language
8. Pinned (TRUE / FALSE)
9. Comment ID
10. Reply-to ID (which comment this reply belongs under)
11. 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=... and fb.watch/...

2. Open the Facebook exporter

Go to zocialcomment.com/export/facebook and paste the URL. Paste up to 50 posts, one per line, to batch them into a single 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

1. Open Excel first (blank workbook)
2. Data ribbon → From Text/CSV
3. Pick your downloaded file
4. Set File Origin to 65001: Unicode (UTF-8)
5. 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 comments from 3 posts per day with no signup. For posts with thousands of comments or bulk campaign work, the $14 3-Day Pass unlocks unlimited exports for 3 days, and the $39 pass adds AI comment analysis.

Also exporting other platforms? See Instagram comments to Excel and TikTok comments to Excel.