Is there a way to download a list of all Wikipedia categories?


3 Answers 3


You can download the Wikpedia categories from here. Here is the latest categories in SQL format.

This is a duplicate of this SO question.


This is really a general MediaWiki question, not a Wikipedia question, since there's nothing special about Wikipedia in this regard.

There is a stable, documented, way to obtain a list of all categories from a MediaWiki server. It is documented in the MediaWiki API documentation. You simply need to write, or obtain, a tool that makes use of this protocol.

  • This is not "general MediaWiki question", because: 1) MediaWik does not contains Wikipedia's content; 2) Wikipedia users has no access to DB, only to dumps.
    – AndriuZ
    Jul 13, 2018 at 13:16
  • @AndriuZ You don't understand. MediaWiki is software, not content. The MediaWiki API is exposed by sites like Wikipedia, Wiktionary, and others. Mar 30, 2019 at 11:49

Use the API. A list of API clients is here: https://www.mediawiki.org/wiki/API:Client_code

For example, using the command-line wikiget:

./wikiget.awk -z wiktionary -c "Spanish proper nouns" > output.txt

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.