FIELD NOTES / GUIDE
How to export Reddit comments for analysis
A single thread may be manageable with a self-service exporter. Multiple communities, a date window, custom filters or linked tables may call for a scoped collection service.
WORKED CHECK / REAL SAMPLE
Check a comment export in four steps
- Export posts and comments separately; keep the original IDs and creation dates.
- Join comments.post_id to posts.post_id. In the real sample, all 20 comments join to one of the 2 posts, 1twcivo or 1ok1fed.
- Check parent_id: in the sample, comment opogn8r has parent_id 1twcivo, so it replies directly to the post; a reply to another comment carries that comment’s ID. Flag unmatched IDs before analysis.
- Compare unique IDs and row counts, inspect blanks and record unavailable or excluded content in a method note.
Keep the thread context
Retain comment_id, post_id and parent_id. In the real sample, 1twcivo is a post and comment opogn8r has post_id 1twcivo and parent_id 1twcivo, so it replies to the post; a reply to another comment carries that comment’s ID as parent_id. The IDs make the relationship explicit even when rows are sorted differently.
See the linked sample ↗Choose the right scope
List thread URLs or communities, dates, whether replies are needed, and the desired format. Decide how deleted or unavailable content should be represented. Availability is not a guarantee of complete historical coverage.
Check the export
First export posts and comments as separate files. Check that each comment post_id exists in the post table; in the real sample, all 20 comments reference one of the 2 posts. Flag duplicate IDs, inspect empty fields and document known gaps. If an ID has no matching post, investigate rather than silently dropping the comment.
THE NEXT STEP
Start with the question.
We'll scope the rest.
Review the examples, then discuss your project directly on Fiverr.