Blog/How-To

Reddit Scraper: Export Posts and Comments Without Code

··8 min read

To scrape Reddit without code, open the subreddit, search results or thread you want in Chrome, open the Lection side panel and describe the columns in plain English ("title, author, score, number of comments, post link"). Lection reads the posts your browser is already showing, collects more pages if you ask, and gives you one table to download as CSV or Excel or paste into Google Sheets. No API key, no Python.

This guide walks through a worked example for posts and one for comments, then covers the limits that matter on Reddit specifically: what you can and cannot collect, why we do not recommend scheduling Reddit scrapes in the cloud, and what Reddit's own terms say.

The short answer

  1. Open the Reddit page in Chrome (a subreddit sorted the way you want, a search, or a single thread).
  2. In the Lection side panel, describe the fields you want for each post or comment.
  3. Check a few rows of the preview against the page, then ask for more pages.
  4. Download the table as CSV or Excel, or import it into Google Sheets.

What you can collect from a Reddit page

Lection extracts what the page shows you. On Reddit that usually means:

PageTypical columns
Subreddit listing (Hot, New, Top)Post title, author, score, number of comments, time posted, flair, post link
Search resultsThe same post fields, across subreddits, for a keyword
A single threadComment author, comment text, score, time posted, comment link
A user's public profileTheir public posts or comments, with the same fields

If a number is hidden on the page (some subreddits hide scores for a while after posting), it will be blank in your table too. Lection does not pull anything the page does not display.

Worked example 1: top posts from a subreddit

Say you want last month's top posts in a subreddit about your product category, to see which questions and complaints keep coming up.

Step 1: Open the listing you actually want

Go to the subreddit and choose the sort and time range on Reddit first, for example Top and This month. Filtering on Reddit is free; filtering a big export later is work.

A practical tip: the older layout at old.reddit.com shows 25 posts per page with a plain "next" link at the bottom, while the current layout loads more posts as you scroll. Both work. Numbered pages are the most predictable to collect across several pages, so if the current layout gives you trouble, try the same URL on old.reddit.com.

Step 2: Describe the columns

Open the Lection side panel and type something like:

"For each post: title, author, score, number of comments, flair, time posted and the post link. Skip promoted posts."

Always include the post link. It is how you remove duplicates later, and you need it if you want to open each thread for comments.

Step 3: Check the preview

Compare three or four rows with the page. Watch for promoted posts, pinned posts at the top of the listing, and scores shown as "1.2k" rather than 1,200. If something is off, correct it in plain English ("ignore pinned posts", "write scores as full numbers") and preview again.

Step 4: Collect more pages

Ask for more: "collect the next 4 pages" or "keep scrolling until you have 100 posts." Lection follows the next link on old Reddit or scrolls the feed on the current layout, and stacks every page into one table. How far one run goes depends on your plan's page limit; the multi-page scraping guide explains page limits and what to do when a list is longer than that.

Step 5: Export

Download the table as CSV or Excel. For Google Sheets, open a sheet, choose File → Import, upload the CSV and pick "Insert new sheet." From there, a pivot table on flair or a COUNTIF on a keyword column gives you a quick view of what people talk about most.

Worked example 2: comments from a thread

Comments are where the useful detail is: the exact wording people use, the alternatives they mention, the complaints that get upvoted.

  1. Open the thread in Chrome.
  2. Expand what you need first. Reddit collapses long threads and hides deeper replies behind "more replies" or "load more comments" links. Lection reads what is on the page, so click those open for the parts you care about, or ask Lection to click them before extracting.
  3. Describe the columns: "For each comment: author, comment text, score, time posted and the comment's link."
  4. Check that replies are not being merged into their parent comment, then download.

For several threads, start from the posts table in example 1. Ask Lection to open each post link and add the top comments as columns, and test it on five threads before running it on fifty. Each thread is a separate page, so this uses your page and credit allowance faster than a listing does.

What people use Reddit exports for

  • Product and market research. Collect posts that mention your product or a competitor, then sort by score to see which complaints and requests have the most support.
  • Content ideas. Questions in a niche subreddit are often the questions your customers search for. A month of top posts makes a good list to work from.
  • Tracking a launch or announcement. Export the thread once on launch day and again a week later to see how the discussion changed.
  • Research datasets. Small, documented samples of public posts for coursework or qualitative analysis. For anything larger or for publication, check your institution's rules and Reddit's terms first (see below).

If you also follow technical communities, the free Hacker News tool exports stories without the extension.

Limits to know before you start

  • Your browser, your view. Lection reads the page in your own Chrome tab. It does not get past logins, private or quarantined subreddits, or anything Reddit does not show you.
  • Don't schedule Reddit in the cloud. Scheduled runs fetch pages from our servers, and Reddit blocks many unauthenticated server requests. That is why we retired our built-in Reddit tools in 2026. For a fresh copy, rerun the extraction from your browser. For pages that do allow cloud runs (stores, directories, job boards), scheduled scrapes to Google Sheets work with your computer off.
  • Reddit's terms. Reddit's User Agreement and its Data API terms restrict automated collection and commercial reuse of Reddit content. Read them before you collect, keep collections small and for your own analysis, and do not republish people's posts or usernames.
  • Rate limits. Reddit may slow down or block a session that loads many pages quickly. Collect what you need, not every page you can.
  • Layout changes. Reddit updates its pages from time to time. If a column comes back blank, reopen the extraction, describe the field again and preview.
  • Deleted and removed content. Posts and comments shown as "[deleted]" or "[removed]" come through as exactly that.

Other ways to get Reddit data

OptionGood forTrade-off
Copy and pasteA handful of postsSlow and error-prone past a page or two
Reddit's Data API (for example with Python and PRAW)Developers who need structured data at volumeRequires an app registration, code, and following Reddit's API terms, including its paid tiers for larger use
Lection in your browserNon-developers who need a few hundred posts or comments in a spreadsheetLimited to what the page shows; rerun from your browser instead of a cloud schedule

Try it

Install the free Lection extension, open a subreddit you follow and export one page of posts to check the columns. The free plan is enough to see whether it works for your research.

When your research reaches beyond Reddit, such as competitor sites, review pages or directories you want refreshed in Google Sheets every day, start the 30-day Standard trial for more credits, Google Sheets delivery and hourly schedules on sites that allow cloud runs. It is free for 30 days, then $29 per month, a card is required, and it is for first-time subscribers only.

FAQ

Is there a free Reddit scraper? Yes. The Lection extension is free to install, and the free plan includes monthly credits for exporting posts and comments from pages you open in Chrome.

Can I scrape Reddit without the API? Yes, by extracting what the page shows in your own browser. You do not need an API key. Reddit's terms still apply to how you use what you collect.

Can I scrape Reddit comments? Yes. Open the thread, expand the replies you need, and describe the comment fields. Collapsed replies that are never opened are not collected.

How do I get Reddit posts into Google Sheets? Export the table as CSV, then use File → Import in Google Sheets. Scheduled cloud delivery to Sheets is not reliable for Reddit, because Reddit blocks many requests from servers.

Can I scrape a private subreddit? No. Lection only reads what your browser can already show you, and it is not meant for content Reddit restricts.


Ready to supercharge your research?

Join thousands of researchers using Lection to capture and organize the web. It's free to get started.