Subreddit Scraper
Scrape any subreddit using Reddit's public JSON API. Export posts to Excel, CSV, or JSON. No API key required.
What is Reddit's JSON API?
Reddit provides public JSON endpoints that allow you to access subreddit data without authentication. By appending .json to any Reddit URL, you get structured data instead of HTML. For example, reddit.com/r/programming.json returns posts in JSON format.
This tool uses these public endpoints to fetch subreddit posts, then formats the data for easy export. No API key or authentication is required for public subreddits.
How to Use This Tool
Type any subreddit name without the "r/" prefix. For example: programming, webdev, or dataisbeautiful.
Select how posts should be sorted (Hot, New, Top, Rising) and how many posts to fetch (up to 100).
Download results as JSON (for developers), CSV (for spreadsheets), or Excel (XLSX) with one click.
Frequently Asked Questions
Do I need a Reddit API key?
No! Reddit's public JSON endpoints work without authentication for public subreddits. This tool uses those endpoints directly, so you don't need to register for an API key.
Is there a rate limit?
Reddit limits unauthenticated requests to about 10 per minute. This tool makes one request per scrape, so you shouldn't hit limits with normal use.
Can I scrape private subreddits?
No, this tool only works with public subreddits. Private and quarantined subreddits require authentication and are not accessible via public JSON endpoints.
What data fields are included?
Each post includes: title, author, score, comments count, upvote ratio, creation date, URL, permalink, flair, self text, and more. The full JSON includes all available fields.
How do I get more than 100 posts?
Reddit limits single requests to 100 posts. For larger datasets, you'd need to use pagination with the "after" cursor. The JSON export includes this cursor if you want to build a custom solution.
Common Use Cases
- •Market Research: Analyze trending topics and user sentiment in industry-specific subreddits.
- •Content Ideas: Find popular posts for inspiration on what resonates with specific communities.
- •Academic Research: Collect discussion data for social media analysis and NLP projects.
- •Competitor Analysis: Monitor mentions and discussions about brands or products.
- •Community Moderation: Export data for analysis or backup of subreddit activity.