Wikidata description and sitelink

[Sandra]

Hi @Joseph_Anderson, welcome to the forum and thanks for using OpenRefine!

Thanks for asking this question here. I get this question all the time during OpenRefine trainings in the cultural sector. It does work, and it’s documented, but I notice that people have trouble finding how this works, so having the process described here on the forum is quite useful

It’s documented here: OpenRefine-Wikidata interface - basically you need to type specific code in the ‘Add property’ field as follows:

• Len for Label in English
• Dfi for Description in Finnish
• Apt for Alias in Portuguese
• Sdewiki for Sitelink in German Wikipedia page titles. For an overview of all Sitelinks ids of Wikidata see: MediaWiki API result.

In the screenshot below, I type Scommonswiki to retrieve sitelinks from Wikimedia Commons (that’s also possible).