How to export a Reddit thread or subreddit to CSV

Reddit has no button that saves a thread or a subreddit as a spreadsheet. You can copy a thread by hand, request your own data, or write a script. To get a whole thread with its comment tree, or a subreddit's posts, as CSV that opens in Excel, use a browser extension such as Threadcrate.

What would it export?

A subredditr/BalconyGardens: top of the month

Up to the roughly 1,000 posts Reddit lists in this order (a setting finds more by combining eight of its lists), with no comments, the top ones or all of them.

Press Export next to Join, or the Threadcrate icon in the toolbar.

Checked in this page with the extension's own code. The link isn't sent anywhere.

WayWhoWhat you getThe catch
Copy and pasteEveryoneThe comments you expanded, as plain text.Who replied to whom, scores and times are lost. Collapsed replies stay hidden.
Request your data from RedditYour own accountA copy of your own account data, from your Reddit settings.Only your own activity: not the other comments in a thread, not a subreddit.
.json at the end of the addressDevelopersThe page's data as JSON, which a script can turn into CSV.One page at a time: "load more" comments stay unloaded. Reddit may refuse it when it sees too many requests.
A script with Reddit's APIDevelopersWhatever the script asks for.Needs API credentials, and Reddit closed most of its free API in 2026.
Threadcrate for RedditAnyone with Chrome on a computerA thread with its whole comment tree, a subreddit, a profile or a search, as posts.csv and comments.csv, plus JSON and Markdown.A browser extension, so not on a phone. Big exports take minutes, at the pace Reddit allows.

The ways without an extension

Copy and paste

Expand every "more replies" you need, select the thread and paste it into a document. It works for a short thread you want to read later, but a spreadsheet gets one long column of text: no authors, scores or times in their own cells, and no way to tell which comment answers which.

Request your data from Reddit

In your Reddit account settings you can ask Reddit for a copy of the data it has about your account. That's the way to keep your own posts and comments. It doesn't hold other people's comments in the threads you took part in, and it can't export a subreddit.

Add .json to the address

Put .json at the end of a Reddit address and Reddit shows the page's data instead of the page. A script can turn that into CSV. It holds one page of the thread: the collapsed "load more comments" parts aren't in it, and fetching them is up to your script. Reddit may also refuse these requests when there are too many.

A script with Reddit's API

Libraries such as PRAW (Python) read Reddit through its official API. You need API credentials from Reddit, and Reddit closed most of its free API in 2026, so many export tools built on it stopped working.

Export a thread or subreddit with Threadcrate

Threadcrate is a free, open-source browser extension. It reads the same pages reddit.com shows you, in your own browser, so it works logged out and needs no API key.

  1. Open the thread, subreddit, profile or search on reddit.com.
  2. Click Threadcrate in the toolbar, or Export next to Share on a post.
  3. Pick how many posts and comments. Each choice shows how long it takes. Press Export.
  4. Unzip the file it saves in your Downloads folder and open posts.csv or comments.csv.

CSV is on by default, next to JSON and Markdown. Images and videos are off until you turn them on in the settings.

Threadcrate's settings, Files in the ZIP: JSON, CSV and Markdown ticked, Images and videos not

What's in posts.csv and comments.csv

posts.csv has one row per post and comments.csv one row per comment. Field names follow Reddit's own, so code written for Reddit's data reads them too.

  • parent_id is the post (t3_…) for a top-level comment and the comment it answers (t1_…) otherwise. depth is 0 for top-level comments, and path lists the ids from the top-level comment down, joined by /.
  • created_utc is an ISO 8601 time in UTC, and created_unix the same moment in seconds, for sorting.
  • Deleted and removed comments stay in as [deleted] and [removed], with removal_status saying which, so their replies keep their place.
  • num_comments is Reddit's count and comments_exported what the export holds. Reddit's count includes removed comments it no longer shows anyone, so the two can differ; manifest.json lists what couldn't be loaded, and why.

posts.csv columns

  • id
  • subreddit
  • author
  • title
  • selftext
  • url
  • permalink
  • created_utc
  • created_unix
  • edited_utc
  • score
  • upvote_ratio
  • num_comments
  • comments_exported
  • link_flair_text
  • author_flair_text
  • media_type
  • media_urls
  • over_18
  • spoiler
  • locked
  • stickied
  • archived
  • is_self
  • distinguished
  • removal_status
  • domain
  • crosspost_parent
  • name
  • subreddit_id
  • author_fullname

comments.csv columns

  • id
  • link_id
  • link_title
  • parent_id
  • root_comment_id
  • depth
  • path
  • author
  • is_submitter
  • body
  • score
  • created_utc
  • created_unix
  • edited_utc
  • distinguished
  • stickied
  • removal_status
  • controversiality
  • score_hidden
  • subreddit
  • permalink
  • name
  • author_fullname

Open it in Excel or Google Sheets

The files are UTF-8 with a byte-order mark, which Excel needs to show accents and emoji correctly. If a double-click puts everything in one column (Excel in some countries expects semicolons), use Data › From Text/CSV and pick comma. In Google Sheets, use File › Import › Upload. Comments are written by strangers, so any cell that starts with =, +, - or @ gets an apostrophe in front: a spreadsheet never runs a comment as a formula.

Rebuild the thread in pandas

The columns are enough to put the tree back together:

import pandas as pd

comments = pd.read_csv("comments.csv")

# Top-level comments answer the post; the rest answer another comment.
top_level = comments[comments.depth == 0]
replies = comments[comments.depth > 0]

# How many direct replies each comment got.
reply_counts = replies.groupby("parent_id").size()

If you'd rather have the tree already built, data.json in the same ZIP has every comment nested under its parent.

Exporting a whole subreddit

Reddit lists at most about 1,000 posts for any one sort of a subreddit, profile or search. Threadcrate exports up to that from the sort you're looking at. With Find more than the 1,000 posts Reddit lists on in the settings, an All export reads eight lists (newest, top and controversial over several time ranges, and hot) and keeps each post once. That finds several thousand posts in a big subreddit, though never every old one.

Reddit's request limit sets the pace, so comments are the biggest choice. Top comments take one request per post; all comments follow every reply, and a big thread can take hundreds of requests. The popup shows the time for each choice before you start.

Use it responsibly

Export what you have a right to keep: your own posts, threads you take part in, research data you'll handle with care. Respect Reddit's User Agreement and the people who wrote the comments. See the privacy policy for what the extension does with data: nothing leaves your browser except its requests to Reddit.