I wanted to make an on-wiki place to host discussion of the tool so I set
up this project page on meta.
This is an interesting tool. I have been playing with it for some weeks
trying to learn whether it could be used to generate monthly traffic
reports for sets of Wikipedia articles. Among editors of Wikipedia's
medical articles, there is continual discussion about monthly article
traffic for certain sets of articles, and I think that somehow this tool
could be used to get those reports for health articles in different
If anyone wants to join me in discussing the tool then write me or meet me
on that wiki page.
On Mon, May 2, 2016 at 4:08 AM, Thomas Steiner <tomac(a)google.com> wrote:
Esteemed Wikipedia, Wikidata, Linked Data, and
Semantic Web communities[*],
tl;dr: Released a Google Spreadsheets add-on called Wikipedia Tools
 that makes working with data from Wikipedia and Wikidata a breeze.
I am happy to release a Google Spreadsheets add-on called Wikipedia
Tools . This add-on allows you to work with data from Wikipedia and
Wikidata from within a spreadsheet context using custom formulas. Let
me motivate the tools with a short example:
You may have heard of Volkswagen's #DieselGate scandal. Is this still
a problem for Volkswagen—and if so, where? Google Trends to the
rescue? Maybe . But what about global impact? How do people in
Korea, an important Volkswagen export market [citation needed😉],
refer to the scandal? Turns out they call it 폭스바겐 배기가스 조작 (among
probably other options).
With a custom function from Wikipedia Tools, we can safely "translate"
from one English (a language that, for the sake of this example, we
assume we dominate well enough) Wikipedia article to many other
languages (that we do not necessarily dominate):
bg Афера на Фолксваген
Then, using Wikipedia page views as one (among others) reasonable
popularity indicator, for each of these language results, for example
for Korean, we can get =WIKIPAGEVIEWS("ko:폭스바겐 배기가스 조작") for the last
n days, and plot the results  (in practice, you would probably
still normalize by size and/or total views of the particular
There are a lot more custom functions implemented than I could cover
in this short example. I have put together a slide deck  and paper
 that go into more detail if you are interested, a demo with all
functions is available at . The add-on also has a built-in manual
(in Google Sheets, click Add-ons→Wikipedia Tools→Show documentation)
and its underlying code is open-source .
Please let me know in case of any open question, feature request, or
 bit.ly/wikipedia-tools-paper (PDF)
[*] Cross-posted on purpose
please choose your reply options accordingly.
[**] This is a simple example for illustrative purposes, I do _not_
claim it is an accurate popularity prediction, nor do I mean to bash
Dr. Thomas Steiner, Employee (http://blog.tomayac.com
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany
Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle
Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.29 (GNU/Linux)
-----END PGP SIGNATURE-----
Wikidata mailing list
user:bluerasberry on Wikipedia