Guides / Export a subreddit to CSV

How to export a subreddit to CSV, with every comment

Want the top 500 posts of r/SaaS this year, with their discussions, in a spreadsheet? Here is how to do it in a few clicks, and how to read the result.

Updated October 2026

A subreddit collection with its posts and the export panel
A collection: the posts of a subreddit, their comments, and every export format.

Step by step

  1. Open the subreddit. On reddit.com, open the subreddit with the sort you want (for example Top → This year), then click the Thread Exporter icon.
  2. Choose how many posts. Up to 1,000 with Pro (Reddit's own maximum per listing). Tick "+ comments" to load every discussion.
  3. Export to CSV. When the collection is ready, choose Excel / CSV. You get one row per comment with the post title, score and date, plus a row per post.
  4. Analyse. In Excel or Google Sheets, pivot by post or author, sort by score, or filter by date.
Try it on a thread, free. The free version exports threads up to 300 comments to CSV and Markdown. Pro is $19.90 once for everything.

Going beyond 1,000 posts

Reddit returns about 1,000 posts per listing. Combine sorts and periods (top of the year, of the month, new, controversial) or searches for specific words to cover more of a subreddit.

More guides