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 — one thread per export, each downloading as its own 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 posts for 3 days (up to 10,000 comments per post), and the $49 Pro 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.