Adds Wikipedia and Wikidata functions for use in Google Spreadsheets like WIKITRANSLATE, WIKISYNONYMS, WIKIGEOCOORDINATES, etc.
Listing updated:ā§Š āϏ⧇āĻĒā§āĻŸā§‡āĻŽā§āĻŦāϰ, ⧍ā§Ļ⧍ā§Ē
Works with:
ā§Šā§Ļ āĻšāĻž+
āĻāĻ• āύāϜāϰ⧇
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].
Additional information
PricingāωāĻĒāϞāĻ­ā§āϝ āύ⧟
Developer
āύāύ-āĻŸā§āϰ⧇āĻĄāĻžāϰ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
Wikipedia and Wikidata Tools will ask for the permissions shown below. Learn more
Wikipedia and Wikidata Tools will need access to your Google account
This will allow Wikipedia and Wikidata Tools to :
āφāĻĒāύāĻžāϰ āϏāĻŦ Google Sheets āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļāĻŋāϟ āĻĻ⧇āϖ⧇, āĻāĻĄāĻŋāϟ āĻ•āϰ⧇, āϤ⧈āϰāĻŋ āĻ•āϰ⧇ āĻāĻŦāĻ‚ āĻŽā§āϛ⧇ āĻĻā§‡ā§Ÿ
Google āĻāϰ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāύ⧇āϰ āĻĒā§āϰāĻŽā§āĻĒāϟ āĻāĻŦāĻ‚ āϏāĻžāχāĻĄāĻŦāĻžāϰ⧇ āϤ⧃āĻ¤ā§€ā§Ÿ āĻĒāĻ•ā§āώ⧇āϰ āĻ“ā§Ÿā§‡āĻŦ āĻ•āĻ¨ā§āĻŸā§‡āĻ¨ā§āϟ āĻĻ⧇āĻ–āĻžā§Ÿ āĻāĻŦāĻ‚ āϚāĻžāϞāĻžā§Ÿ
āϕ⧋āύ āĻŦāĻžāĻšā§āϝāĻŋāĻ• āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϤ⧇ āϏāĻ‚āϝ⧁āĻ•ā§āϤ āĻ•āϰ⧇
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁