To export Reddit comments for market research, paste the thread link into a comment exporter and download every comment, with its score and reply structure, as a CSV, Excel or JSON file. Reddit's own data request only covers your own account, the .json view stalls on large threads, and the official Data API is built for developers running apps, not for someone reading twenty threads about a product category. This guide compares those methods side by side and then shows how to turn a raw thread into ranked pain points, feature requests and buyer sentiment.
Why subreddit threads beat surveys for early research
A survey answers the questions you thought to ask. A Reddit thread answers the ones you did not. When someone posts "What CRM do small agencies actually use?" in a subreddit, hundreds of practitioners reply with their tool, what made them switch, what they still hate and what they would pay to fix. Three properties make that unusually useful for research:
- The community ranks the answers for you. Every comment carries a score, so a complaint with 400 upvotes is a shared complaint, not one person's bad day.
- Disagreement is visible. Replies push back, add caveats and correct each other. The reply chain under a popular comment is often where the real nuance lives.
- People are candid. Pseudonymous accounts talk about budgets, failed purchases and workarounds in a way they rarely do in a branded survey or a review site.
The catch is volume. Reading one 900-comment thread in a browser, with collapsed branches and "load more comments" links, takes an afternoon and leaves you with impressions instead of counts. Getting the thread into a spreadsheet is what turns reading into research.
Five routes for getting a thread out of Reddit, side by side
There are five realistic ways to collect Reddit comments for a study. They differ most in how much of a large thread you actually end up with.
| Method | Effort | Coding | Nested replies kept | Comment ceiling | Output | Best for |
|---|---|---|---|---|---|---|
| Reddit data request | Low, but you wait for an email | None | Not applicable | Only your own comments | ZIP of CSV files | Auditing your own account history |
| Copy by hand | Very high | None | Lost when pasted | What you can expand and select, realistically a few dozen | Unstructured text | Quoting two or three comments |
Thread URL + .json | Medium | Some, to flatten the tree | Yes, as nested JSON | The first page of the thread; "load more" stubs are not expanded | Raw nested JSON | Small threads, one-off checks |
| Official Reddit Data API | High setup | Yes (OAuth app, pagination, rate limits) | Yes | High, bounded by rate limits and terms | Whatever you build | Ongoing monitoring inside your own software |
| ZocialComment export | Low: paste a link | None | Yes, via reply_to_id | Typically about 95% of a large thread | CSV, Excel, JSON | Studies across one or many threads |
Reddit's data request: your own history only
Reddit lets every user request a copy of their account data from the data request page, a right that comes from privacy laws such as the GDPR and CCPA. The archive arrives by email as a set of CSV files covering your posts, comments, votes, saved items and messages.
That is genuinely useful if the research subject is you: a brand account reviewing everything it has said in a subreddit, or a founder pulling their own support replies. It is no help for market research about other people's opinions, because the archive never contains comments written by anyone else. If a guide tells you to "download the thread" through this page, it has confused the two.
The .json view and hand copying: fine for a peek
Adding .json to the end of a thread URL returns the page as JSON: each comment with its author, body, score, timestamp and a nested replies object. Opened in a logged-in browser it works, and for a 60-comment thread it can be enough.
Three limits show up as soon as the thread matters:
- It stops at the first page. Large threads end in "more" stubs and "continue this thread" links. The JSON lists their ids but not their text, and the endpoints that used to expand them were blocked by Reddit in November 2026.
- The tree is nested. Replies sit inside replies inside replies. Before a spreadsheet can count anything, someone has to flatten that tree into rows, which means writing code.
- Logged-out requests are often refused. In our testing in November 2026, anonymous requests for thread JSON were answered with errors or redirects far more often than they used to be.
Hand copying has the same ceiling with none of the structure. Selecting text from an expanded thread loses scores, timestamps and who-replied-to-whom the moment it is pasted. Use it to grab a quote, not a dataset.
The official Data API: built for apps, not one-off studies
The Reddit Data API Wiki describes the sanctioned way to read Reddit programmatically. You register an app, authenticate with OAuth, and are limited to 100 queries per minute per client id. Commercial use, which includes most market research done for a company, needs Reddit's explicit approval, and the Developer Terms restrict how the data may be stored, displayed and shared.
The API is the right tool when Reddit data feeds a product you maintain, such as a dashboard that watches a subreddit every day. For a researcher who needs the comments from a defined set of threads this quarter, it is weeks of setup, an approval process and a script to maintain, all to produce a spreadsheet.
Picking a method by project size
- Reviewing your own account's comments: use Reddit's data request.
- Quoting a handful of comments in a deck: copy them by hand from the thread.
- Checking a small thread once, and you can write a little code: the
.jsonview. - Building software that reads Reddit continuously: apply for the official Data API.
- Researching what buyers say across one or many threads: export the threads to CSV or Excel at zocialcomment.com/export/reddit. This is the right choice for nearly every market-research project, because it keeps scores and reply structure and needs no code.
From a raw export to research findings
A thread export has the same columns for every platform: author, username, text, likes, replies, created_at, language, is_pinned, id, reply_to_id and avatar_url. On Reddit, likes is the comment's score. Here is how to turn those rows into findings someone can act on.
Rank by score before you read
Sort the sheet by likes, highest first, and read the top 30 rows before anything else. These are the views the subreddit agreed with most. Then read a random 30 from the bottom half: low-scored comments are where niche complaints and new entrants show up before they become popular. Keep in mind that early comments collect more votes simply by being early, so compare scores within a thread, never across threads of different sizes.
Rebuild the conversation with reply_to_id
Every row has an id, and every reply has a reply_to_id holding the id of the comment it answers. Rows whose reply_to_id does not match any comment id in the sheet are top-level answers to the original post. In Excel, a lookup from reply_to_id to id pulls the parent's text next to each reply, which is how you find the most useful pattern in Reddit research: a highly scored top-level recommendation followed by replies saying "I tried that, here is what went wrong". CSV and Excel downloads also include Reddit's own depth field, so you can filter to first-level replies in one click.
Tag pain points with a fixed codebook
Add a tag column and decide the labels before you start, so you are counting rather than inventing. A codebook that works for most product research:
- Pain point: a problem with the current way of doing the job.
- Feature request: something people wish a product did.
- Price objection: cost, billing model or value complaints.
- Switching story: "I moved from A to B because…".
- Praise: what an existing option does well.
When tagging is done, a pivot table of tag by summed likes gives you a ranked list of what matters to that community, weighted by how many people agreed. For longer threads, the method in our guide to analyzing Reddit comments goes deeper on weighting and sentiment.
Sample many threads, not one big one
One thread reflects one post's framing and one day's crowd. A sturdier sample is 10 to 20 threads on the same question, from different months and, where possible, different subreddits. With a pass you can paste up to 20 Reddit links at once on the export page and get one file per thread. Stack the files into one sheet, add a thread column, and count each tag per thread so a single viral post cannot dominate the result.
How we know this
This guide comes from running the Reddit exporter, not from reading about it. A few things we see in practice:
- Coverage is about 95%, and we say so. In November 2026 Reddit started refusing the requests that expand "load more comments". Our exporter now reads the thread in each of Reddit's sort orders and then follows individual comment permalinks, which recovered roughly 95% of a 1,192-comment thread in about two minutes. The missing rows are mostly deep "continue this thread" replies and deleted comments.
- The badge count runs ahead of the rows. The comment total Reddit shows on a post includes removed and deleted comments that no longer have readable text, so a file with fewer rows than the badge is normal.
- Some columns are empty on Reddit.
avatar_urlis blank for Reddit rows since that lookup was dropped to stay within Reddit's request budget, andlanguageis not filled for Reddit. - The numbers are live. The 100-comment no-signup allowance, the 20-link paste limit and the column names in this post are the values the product uses today. For anything about Reddit's own rules, follow the links to Reddit's documentation rather than our summary.
Keeping the research above board
Public does not mean unrestricted. Reddit's User Agreement governs how its content can be reused, and usernames can count as personal data. If you work under the GDPR, the UK ICO's guidance on legitimate interests is a practical way to check your purpose. In practice: report findings in aggregate, strip usernames from quotes in decks, do not contact commenters off the back of the export, do not resell the data, and delete the files when the project ends.
Facts worth keeping
- Reddit's data request exports only the requesting user's own activity, never other people's comments.
- Appending .json to a Reddit thread URL returns the first page of comments as nested JSON and does not expand "load more comments" stubs.
- The Reddit Data API allows 100 queries per minute per OAuth client id, and commercial use requires Reddit's approval.
- A ZocialComment Reddit export keeps nested replies as rows linked by reply_to_id and typically captures about 95% of a large thread.
- The first 100 comments of a Reddit thread export without signup; larger threads are a one-time payment, never a subscription (see pricing).
Export Reddit comments for your research →
Related reading: how to analyze Reddit comments, exporting Reddit comments to Excel, exporting a Reddit thread's comments.
