Reddit is a goldmine for genuine opinions — product research, pain points, competitor gripes — but there's no native way to pull a thread into a spreadsheet. Copy-pasting a 2,000-comment AskReddit thread by hand isn't realistic.
This guide exports comments from any public Reddit thread into a CSV that opens directly in Excel — one row per comment, reply structure preserved.
The columns you'll get
The Clean export (default) gives you one comment per row with these fields:
- Author (u/username)
- Username
- Comment text (Unicode-safe — emoji and non-Latin scripts render correctly in UTF-8)
- Upvotes / score
- Reply count
- Timestamp (UTC)
- Language
- Pinned / stickied (TRUE / FALSE)
- Comment ID
- Reply-to ID (the parent comment, for reconstructing threads)
- Avatar URL
Need every raw metadata field? Switch to the Raw export for the full set.
Step-by-step
1. Copy the thread URL
Any of these public Reddit URL types work:
https://www.reddit.com/r/{subreddit}/comments/...https://old.reddit.com/r/{subreddit}/comments/...- Shortened
/s/share links
2. Open the Reddit exporter
Go to zocialcomment.com/export/reddit and paste the URL. Paste up to 50 threads, one per line, to batch them into one CSV.
3. Click "Export Comments"
The tool walks the comment tree and shows a preview. Free tier covers 3 threads 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
- Open Excel first (blank workbook)
- Data ribbon → From Text/CSV
- Pick your downloaded file
- Set File Origin to
65001: Unicode (UTF-8) - Set Delimiter to
Comma, then Load
Mac Numbers and Google Sheets handle UTF-8 automatically — just double-click.
Useful Excel formulas
Show only top-level comments
Filter the Reply-to ID column to blank/empty — those are the root comments, not nested replies.
Rank by upvotes
=SORT(A2:K1000, 4, -1) — sorts by score (column D) descending to surface the top-voted takes.
Count mentions of a product or competitor
=COUNTIF(C2:C1000, "*productname*") against the comment-text column — quick share-of-voice inside a thread.
Free tier limits
The free tier exports comments from 3 threads per day with no signup. For large threads or bulk research, the $14 3-Day Pass unlocks unlimited exports for 3 days, and the $39 pass adds AI comment analysis for sentiment and theme clustering across thousands of comments.
Also exporting other platforms? See TikTok comments to Excel and Instagram comments to Excel.