I have no intent to post a duplicated thread here. I'm interested in an offline version of Stack Overflow where I can study on the run as my job is an interstate courier that does not always have an Internet connection. Using 3G data is very expensive though.

Is there a way to download an offline dump from the Stack Overflow for a specific programming language, for example, I'm learning Python. Download the whole site seems not reasonable as it is too big and not necessary.

How do I browse it alike the "Outlook" style, for example, the title column and content panel?


2 Answers 2


I have created several books (physical and eBooks). I've update the Python eBook with data from the latest data dump (June 2016) and generated a Python physical book if you want that.

While not exactly what you're after (it's not quite "outlook style"), both books have links (eBook has hyperlinks, physical book as page numbers) between sections / tags so that you can read questions by tag, even if the book doesn't group the questions into the tag you want to read (because a more dominant tag exists for the question).

I've put a free promotion on the eBook for 5 days starting today.

eBook: https://www.amazon.com/Python-Programming-Questions-George-Duckett-ebook/dp/B00RY621J6

Physical Book: https://www.amazon.com/Python-Programming-Questions-George-Duckett/dp/1535352752

Hope you find one/them useful!

  • You did a great job George. Thank you sooooo much Jul 23, 2016 at 5:02
  • These Amazon links are now dead, and I can't seem to find this title available elsewhere. What happened?
    – Coquelicot
    Apr 3, 2018 at 22:17
  • @Coquelicot Amazon got stricter with what they allow on their platform. You should be able to find equivalents on iTunes and the Google play store. (don't have the links to hand right now unfortunately). Apr 4, 2018 at 12:03

You can download the whole StackOverflow data dump in archive.org, but you need to download a huge file and have a lot of space in your hard drive to uncompress it.

Alternatively, you can use StackExchange Data with a query like:

SELECT TOP ##NumberOfQuestionsToFetch##
          question.Id AS QuestionId, 
          question.Score AS QuestionScore,
          question.Title AS QuestionTitle,
          question.Body AS QuestionBody,
          answer.Id AS AcceptedAnswerId,
          answer.Score AS AnswerScore,
          answer.Body AS AnswerBody
FROM Posts AS question
JOIN Posts AS answer on question.AcceptedAnswerId = answer.Id
INNER JOIN PostTags AS question_tags on question_tags.PostId = 
INNER JOIN Tags on question_tags.TagId = Tags.Id
WHERE question.Id > ##LastFetchedQuestionId## AND 
      Tags.TagName IN ('##Tag##')
ORDER BY question.Id ASC

You can fetch 50000 questions at a time, but you repeat the search starting with the ID number of the last question of your previous batch.

  • 1
    That's just raw data dump. Stack Exchange got official place with the data dumps. Question here is about downloading specific set of questions, e.g. of one tag. Oct 3, 2017 at 12:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .