ガイド / Export a group to Excel / CSV

How to export Facebook group posts and comments to Excel

A spreadsheet is the easiest way to analyse a group: sort by engagement, filter by date or author, count topics, or share a report. Here is how to get every post and comment into Excel or Google Sheets.

作成者:Pierre Carron · 2026年10月 更新

Export screen with spreadsheet CSV, HTML archive, JSON, JSONL and Markdown options
Choose "Spreadsheet (CSV)" to get posts.csv and comments.csv.

ステップごとの手順

  1. Download the group. With Group Exporter for Facebook installed, open the group on Facebook, click the extension icon and click "Download this group".
  2. Open Export. Open the Group Exporter for Facebook dashboard, go to Export and select the group.
  3. Choose CSV. Tick "Spreadsheet (CSV)". Optionally filter by date range or minimum number of comments.
  4. Open in Excel. Open posts.csv and comments.csv in Excel, Google Sheets or Numbers. They are UTF-8 encoded, so accents and emojis display correctly.
あなたのグループで無料でお試しください。 無料版は 200 件の投稿をすべてのコメントとともにダウンロードします。Pro は無制限で $24.90 の買い切りです。

Columns in posts.csv

post_id, date, author, author_id, text, reactions, comments, shares, url, attachments, image_descriptions, shared_post_author, shared_post_text.

Columns in comments.csv

comment_id, post_id, reply_to_comment_id, depth, date, author, author_id, text, reactions, attachments, post_url. The post_id column links every comment to its post, so you can use a pivot table or VLOOKUP to join the two sheets.

Ideas for analysis

Sort posts by comment count to find the hottest discussions. Count posts per month to see activity trends. Filter comments by keyword to collect every answer to a recurring question. Group Exporter for Facebook's built-in Insights page does much of this for you: posts over time, top contributors and most-discussed topics.

Exporting only search results

In the Library, search for a keyword (for example "refund" or "shipping") and click "Export these results → CSV" to get a spreadsheet of just the matching discussions.

その他のガイド