How to Download Your Reddit Data

Reddit is following in Twitter’s footsteps and charging third-party apps for access to their APIs. The result: Apollo, one of the most popular Reddit apps for iPhone, is shutting down entirely after determining that the new pricing would cost it $2 million a month. RIF, another popular app, is calling it quits for the same reason. After the API news, several major Reddit communities are blacked out this week in protest.

Reddit has every right to charge for its API, legally speaking, and it stands to gain if more people use the (terrible) official app. Reddit CEO Steve Huffman argued in an AMA that the changes are being overblown. Comments in that thread are, shall we say, less than friendly to the company line.

If all of this leaves you wondering what might happen to the posts and comments you’ve made on Reddit over the years, you’re not alone. David Brownman, a programmer based in San Mateo, California, was wondering exactly that.

“I have put so much into Reddit over the years, and I didn’t like the idea of it being inaccessible to me,” he tells me. “It’s my content, and I’ll need to be a steward of it if Reddit won’t. I also reference old posts of mine a lot, so having full text search was important to me.”

With these concerns in mind, Brownman wanted an offline archive of his posts. Here’s how you can get one too, either by asking Reddit or by using a tool Brownman built to download it yourself.

Ask Reddit for Your Data

Reddit has a form where you can request a copy of your data. The process can take up to 30 days, after which you will get a private message on your Reddit a count with a download link. The data comes in the form of CSV files that you can open using Microsoft Excel or any text editor. There are separate files for your comments, your posts, your voting history, and your chats, among other things.

This method has a few downsides. First, CSV files can be a little unwieldy, especially if you want to search. Second, there’s a delay, which is annoying if you just want to download the data and move on with your life. Still, it’s easy, and for most people, this is probably the best way to back up their Reddit content.

Download Your Reddit Data Yourself

If you’d rather not wait for Reddit to deliver your data, or would prefer to keep your data in a searchable archive, you can use Brownman’s tool, reddit-user-to-sqlite. This command line application can download the complete public archive of any Reddit user and compile it in an SQLite database file. Just keep in mind that this method will stop working on July 1, 2023, when the API change occurs.

Brownman offers a blog post outlining the tool with a few instructions—if you’re comfortable with the command line, I recommend following the instructions there. For everyone else, don’t worry: It’s not as hard as it sounds.

First you will need to install Python. For Windows users, this is best done by downloading and running the installer for your computer. After installing Python, you will need to install pipx. On Windows, this is best done with the following commands, which you can run in the Command Prompt or PowerShell: