# How to export subreddit posts and comments to CSV > Get a subreddit's posts and comments into a CSV or spreadsheet without code, with points, flair, upvote ratio and top replies. Reddit has no export of its own. By Matt, Parsly · Updated 2026-11-02 · https://parsly.to/guides/how-to-export-a-subreddit-to-a-spreadsheet/ ## The short answer Reddit has no export button for a subreddit: its data request covers only your own account. To get a subreddit's posts and comments into a CSV or spreadsheet, use the Reddit API if you can code, or a Chrome extension such as Parsly, which collects posts with points, flair and top comments, or a post's comments row by row. Reddit is where people say what they really think about a product or a problem, in their own words. That makes it useful for market research, ad copy and content ideas, once it's somewhere you can sort it. This guide is for founders and marketers who want that without writing code. ## Can you export a subreddit from Reddit? No. Reddit has no export for a subreddit's posts or comments: its [data request](https://www.reddit.com/settings/data-request) covers only your own account's activity. To get a subreddit into a spreadsheet, you need the Reddit API, which takes code, or a tool that reads it for you, such as Parsly. ## How do I export a subreddit's posts to CSV? Collect it with a Chrome extension. [Parsly](https://parsly.to/) is free. 1. Add Parsly to Chrome, and allow it on Reddit when it asks. 2. Open the subreddit (reddit.com/r/startups), signed in to Reddit. 3. Choose **Newest**, going back by date or count, or **Top** of a day, week, month, year or all time. 4. Turn on **Top comments** if you want each post's best replies: 3, 5, 10 or 20 per post, about 2 seconds a post. 5. Click **Collect posts** and download the **CSV**. Each row has the full text, points, upvote ratio, comments, flair, link, picture and top comments. ## How do I export the comments on one post? Open the post and click **Collect comments**. Choose Reddit's sort (Best, Top, New, Old, Controversial or Q&A) and how many, and the thread arrives as one row per comment, in reading order, with its depth, who it answers and its points. ## Can I use the Reddit API instead? Yes, if you can write code and your use isn't commercial. You register an app, follow [Reddit's Data API terms](https://redditinc.com/policies/data-api-terms) and handle paging and rate limits yourself. Commercial use, or research beyond the rate limits, needs a separate agreement with Reddit. ## Which way should I use? Use Parsly if you don't code and want a spreadsheet today, and the API if you're building this into your own software. Reddit's data request only helps with your own account. | Way | Free | Posts | Comments | Effort | |---|---|---|---|---| | Copy by hand | Yes | One at a time | One at a time | Very high | | Reddit data request | Yes | Your own only | Your own only | Slow | | Reddit API | Commercial use needs an agreement | Yes | Yes | Code | | Scraping services | Paid | Yes | Yes | Setup | | Parsly | Yes | Yes | Yes | One click | ## What can you do with the spreadsheet? Sort by comments to find the arguments, and by points to find what people agree on. Search for "I wish", "alternative to" and "how do you" to find problems worth solving. Then paste the top posts and comments into an AI and ask for the complaints that repeat, in the exact words people use, which is useful for ads and landing pages. ## What can't you export? - **Huge threads in full.** A thread loads about 500 comments at most. - **More than Reddit lists.** Reddit shows about 1,000 posts per sort for a subreddit, and about 1,000 items for a user. - **Private subreddits you can't see.** Parsly reads what you can. - **Reddit search results or your home feed.** Parsly collects subreddits, posts and users. - **Deleted and removed comments.** They're left out, so a thread can have fewer rows than its comment count. ## Questions people also ask ### Can I export a whole subreddit? Usually not. Reddit lists about 1,000 posts per sort, so that's the most any tool reading its listings gets in one go. To reach further, collect Newest, then Top of the year and Top of all time with Parsly, and remove the duplicates in your spreadsheet. ### Can I export several subreddits at once? Yes. Open reddit.com/r/startups+SaaS+Entrepreneur, up to 10 joined with a plus, and Parsly collects them as one list, newest first. ### Can I open the export in Excel or Google Sheets? Yes. Parsly downloads a CSV, which opens in Excel, Google Sheets or Numbers. It also downloads JSON, with every field. ### Can I export a user's posts and comments? Yes. On reddit.com/user/name, Parsly collects their posts or comments. Reddit lists about 1,000 of a user's items at most. ### Do I need a Reddit account? Yes. Parsly reads Reddit from your own signed-in browser, and Reddit blocks the data it reads when you're signed out. ## Sources - [Reddit: Request your data](https://www.reddit.com/settings/data-request) - [Reddit Data API Terms](https://redditinc.com/policies/data-api-terms)