Thomas Steiner
•  11,691
Overview
Adds Wikipedia and Wikidata functions for use in Google Spreadsheets like WIKITRANSLATE, WIKISYNONYMS, WIKIGEOCOORDINATES, etc.
Adds the following Wikipedia custom functions for use in Google Spreadsheets:

- WIKITRANSLATE: Returns Wikipedia translations (language links) for a Wikipedia article.
- WIKISYNONYMS: Returns Wikipedia synonyms (redirects) for a Wikipedia article.
- WIKIEXPAND: Returns Wikipedia translations (language links) and synonyms (redirects) for a Wikipedia article.
- WIKICATEGORYMEMBERS: Returns Wikipedia category members for a Wikipedia category.
- WIKISUBCATEGORIES: Returns Wikipedia subcategories for a Wikipedia category.
- WIKIINBOUNDLINKS: Returns Wikipedia inbound links for a Wikipedia article.
- WIKIOUTBOUNDLINKS: Returns Wikipedia outbound links for a Wikipedia article.
- WIKIMUTUALLINKS: Returns Wikipedia mutual links, i.e, the intersection of inbound and outbound links for a Wikipedia article.
- WIKIGEOCOORDINATES: Returns Wikipedia geocoordinates for a Wikipedia article.
- WIKIDATAFACTS: Returns Wikidata facts for a Wikipedia article.
- WIKIDATAQID: Returns the Wikidata qid of the corresponding Wikidata item for an article.
- WIKIPAGEVIEWS: Returns Wikipedia pageviews statistics for a Wikipedia article.
- WIKIPAGEEDITS: Returns Wikipedia pageedits statistics for a Wikipedia article.
- WIKICOMMONSLINK: Returns the Wikimedia Commons link for a file.
- WIKICATEGORIES: Returns Wikipedia categories for a Wikipedia article.
- WIKIARTICLESAROUND: Returns Wikipedia articles around a Wikipedia article or around a point.
- WIKISEARCH: Returns Wikipedia article results for a query.
- WIKIQUARRY: Returns the output of the Quarry (https://meta.wikimedia.org/wiki/Research:Quarry) query with the specified query ID.

You can see a demo of all functions in the demo spreadsheet https://docs.google.com/spreadsheets/d/1sVduZul787O-bRzuy0UKpRl7bkouxwaIOsxXuJGm6yg/edit?usp=sharing.

The source code of the Wikipedia Tools is available on GitHub: https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets. Please post feature requests and report issues on GitHub as well.

A paper with use case descriptions is available on arXiv: http://arxiv.org/pdf/1602.02506v1 [PDF].
Reviews
Language:
Sort by:
A User of Wikipedia and Wikidata Tools
April 27, 2020
What a great idea! Where's the documentation on how to use ALL of the functions?
Is this review helpful?
Yes
No
A User of Wikipedia and Wikidata Tools
March 30, 2020
Didn't work. Just returns an unknown function error.
Is this review helpful?
Yes
No
A User of Wikipedia and Wikidata Tools
December 24, 2017
Too limited for practical use with any larger data-sets (and this is the only place where it would be needed). There clearly is a potential, but it should be developed further to reach that.
Is this review helpful?
Yes
No
A User of Wikipedia and Wikidata Tools
December 7, 2017
Automatic Wikidata lookups, combined with automated lookups of specific Wikidata properties, make this an incredibly useful tool for querying Wikidata and for reconciling databases.
Is this review helpful?
Yes
No
A user of Wikipedia and Wikidata Tools
April 27, 2020
how can I do that -- look up specific Wikidata properties for example: population of the country of Norway?
A User of Wikipedia and Wikidata Tools
December 3, 2017
Great tool, bit slow and complicated but great.
Is this review helpful?
Yes
No
Joe Devon
March 28, 2017
Love it! Great tool to help mine data from wikidata
Is this review helpful?
Yes
No
David Lowe
January 27, 2017
Incredibly helpful for harvesting info. I only wish I could grab links to Wikipedia from Wikidata IDs. Brilliant tool though.
Is this review helpful?
Yes
No
A User of Wikipedia and Wikidata Tools
December 22, 2016
Fantastic tool for analysing Wikipedia content.
Is this review helpful?
Yes
No
A User of Wikipedia and Wikidata Tools
November 12, 2016
This is fatastic Addon. Helped a lot in various wikis to manage various events. Importing various kind of data into sheets is great. Thanks a lot.
Is this review helpful?
Yes
No
1-9 of 9
Additional information
Thomas Steiner
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu