Wikipedia Tools

WIKIPAGEVIEWS

Returns Wikipedia pageviews statistics for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article in to get pageviews statistics for.
opt_start string= The start date since when pageviews statistics should be retrieved from (optional).
opt_end string= The end date until when pageviews statistics should be retrieved to (optional).
opt_sumOnly boolean= Whether to only return the sum of all pageviews in the requested period (optional).

Return Values

Type Description
Array<number> The list of pageviews between start and end per day.

Example

=WIKIPAGEVIEWS(
  "de:Berlin",
  TODAY() - 2,
  TODAY()
)
February 7, 2016	5173
February 6, 2016	4613
February 5, 2016	6168

WIKIARTICLESAROUND

Returns Wikipedia articles around a Wikipedia article or around a point.

Arguments

Name Type Description
articleOrPoint string The Wikipedia article or the point to get articles around for.
radius number The search radius in meters.
opt_includeDistance boolean= Whether to include the distance in the output, defaults to false (optional).
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of articles around the given article or point.

Example

=WIKIARTICLESAROUND(
  "de:Berlin",
  1000
)
Battle of Berlin	52.516666666667	13.383333333333	0
Timeline of Berlin	52.516667	13.383333	0
Warschauer Straße	52.51658	13.381	158.2
…

WIKIPAGEEDITS

Returns Wikipedia pageedits statistics for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get pageviews statistics for.
opt_start string= The start date since when pageedits statistics should be retrieved from (optional).
end string The end date until when pageedits statistics should be retrieved to.

Return Values

Type Description
Array<number> The list of pageedits between start and end and their deltas.

Example

=WIKIPAGEEDITS(
  "en:Berlin",
  TODAY() - 2,
  TODAY()
)
February 7, 2016	-5
February 7, 2016	-16
February 6, 2016	-17

WIKICATEGORYMEMBERS

Returns Wikipedia category members for a Wikipedia category.

Arguments

Name Type Description
category string The Wikipedia category to get members for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of category members.

Example

=WIKICATEGORYMEMBERS(
  "en:Category:Berlin"
)
Berlin
Free Secession
Intelexit
…

WIKIOUTBOUNDLINKS

Returns Wikipedia outbound links for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get outbound links for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of outbound links.

Example

=WIKIOUTBOUNDLINKS(
  "en:Berlin"
)
1. FC Union Berlin
1896 Summer Olympics
1900 Summer Olympics
…

WIKISYNONYMS

Returns Wikipedia synonyms (redirects) for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get synonyms for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of synonyms.

Example

=WIKISYNONYMS("en:Berlin")
CityBerlin
Berlin, Germany
Capital of East Germany
…

WIKITRANSLATE

Returns Wikipedia translations (language links) for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get translations for.
opt_targetLang Array<string>= The list of languages to limit the results to (optional).

Return Values

Type Description
Array<string> The list of translations.

Example

=WIKITRANSLATE(
  "en:Berlin"
  {"ab"; "ace"; "af"}
)
ab	Берлин
ace	Berlin
af	Berlyn
…

WIKIEXPAND

Returns Wikipedia translations (language links) and synonyms (redirects) for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get translations and synonyms for.
opt_targetLang Array<string>= The list of languages to limit the results to (optional).

Return Values

Type Description
Array<string> The list of translations and synonyms.

Example

=WIKIEXPAND(
  "en:Berlin",
  {"fr"}
)
fr	en
Berlin	Berlin
DE3	CityBerlin
	Berlin, Germany
	Capital of East Germany
…

WIKIMUTUALLINKS

Returns Wikipedia mutual links, i.e, the intersection of inbound and outbound links for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get mutual links for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of mutual links.

Example

=WIKIMUTUALLINKS("en:Berlin")
Albert Einstein
Ankara
Amsterdam
…

WIKISUBCATEGORIES

Returns Wikipedia subcategories for a Wikipedia category.

Arguments

Name Type Description
category string The Wikipedia category to get subcategories for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of subcategories.

Example

=WIKISUBCATEGORIES(
  "en:Category:Berlin"
)
Category:Berlin ePrix
Category:Culture in Berlin
Category:Crime in Berlin
…

WIKICATEGORIES

Returns Wikipedia categories for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get categories for.

Return Values

Type Description
Array<string> The list of categories.

Example

=WIKICATEGORIES(
  "en:Category:Berlin"
)
Category:1237 establishments
Category:All articles with dead external links
Category:All articles with failed verification
…

WIKIDATAFACTS

Returns Wikidata facts for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article in the format "language:Article_Title" ("de:Berlin") or the Wikidata item's qid in the format "qid" ("Q42") to get Wikidata facts for.
opt_multiObj string= Whether to return all object values (pass all) or just the first (pass first) when there are more than one object values (optional).
opt_properties Array<string> opt_properties Limit the resulting facts to a list of properties (optional). See the reference of properties on Wikidata for details.

Return Values

Type Description
Array<string> The list of Wikidata facts.

Example

=WIKIDATAFACTS("en:Berlin")
highest point	Arkenberge
country		Germany
postal code	10115–14199
…

WIKIINBOUNDLINKS

Returns Wikipedia inbound links for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get inbound links for.
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of inbound links.

Example

=WIKIINBOUNDLINKS("en:Berlin")
Albert Einstein
Ankara
Amsterdam
…

WIKILINKSEARCH

Returns Wikipedia articles that have a link that matches a given link pattern.

Arguments

Name Type Description
linkPattern string The link pattern to search for in the format "language:example.com" or "language:*.example.com".
opt_protocol string= Protocol of the link, defaults to "http" (optional).
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of articles that match the link pattern.

Example

=WIKILINKSEARCH("en:berlin.de")
Theodor-Heuss-Platz	http://berlin.de/ba-charlottenburg-wilmersdorf/bezirk/lexikon/theodorheussplatz.html
Theodor-Heuss-Platz	http://berlin.de/ba-charlottenburg-wilmersdorf/bezirk/lexikon/dt_amerikahaus.html
Märchenbrunnen		http://berlin.de/orte/sehenswuerdigkeiten/maerchenbrunnen/
…

WIKIGEOCOORDINATES

Returns Wikipedia geocoordinates for a Wikipedia article.

Arguments

Name Type Description
article string The Wikipedia article to get geocoordinates for.

Return Values

Type Description
Array<number> The latitude and longitude.

Example

=WIKIGEOCOORDINATES("en:Berlin")
52.51666667	13.38333333

WIKICOMMONSLINK

Returns the Wikimedia Commons link for a file.

Arguments

Name Type Description
fileName string The Wikimedia Commons file name to get the link for.

Return Values

Type Description
<string> The link of the Wikimedia Commons file.

Example

=WIKICOMMONSLINK(
  "en:Flag of Berlin.svg"
)
https://upload.wikimedia.org/wikipedia/commons/e/ec/Flag_of_Berlin.svg

WIKISEARCH

Returns Wikipedia article results for a query.

Arguments

Name Type Description
query string The query in the format "language:Query" ("de:Berlin") to get search results for.
opt_didYouMean string= Whether to return a "did you mean" suggestion, defaults to false (optional).
opt_namespaces string= Only include pages in these namespaces (optional).

Return Values

Type Description
Array<string> The list of article results.

Example

=WIKISEARCH(
  "en:Berlin",
  true
)
Berlin			berlin
East Berlin
Greater Berlin Act
…

WIKIDATAQID

Returns the Wikidata qid of the corresponding Wikidata item for a Wikipedia article.

Arguments

Name Type Description
article string The article in the format "language:Query" ("de:Berlin") to get the Wikidata qid for.

Return Values

Type Description
string The Wikidata qid.

Example

=WIKIDATAQID("en:Berlin")
Q64

WIKIDATALOOKUP

Returns the Wikidata qid of the given identifier and property.

Internally, this function invokes a haswbstatement query against the Wikidata API.

Arguments

Name Type Description
property string The Wikidata property.
identifier string The identifier (value) to lookup.

Return Values

Type Description
string The Wikidata qid.

Example

=WIKIDATALOOKUP("P298", "AUT")
Q40

WIKIDATASEARCH

Searches for Wikidata entities using Wikidata labels and aliases.

Arguments

Name Type Description
search string The search string in the format "language:Query" ("de:Berlin") to get the Wikidata qid for.

Return Values

Type Description
string The Wikidata qid.

Example

=WIKIDATASEARCH("nb:veldig lett nysnø")
Q70596575

WIKIDATALABELS

Returns the labels for a Wikidata item.

Arguments

Name Type Description
qid string The Wikidata item's qid to get the label for.
opt_targetLanguages Array<string>= The list of languages to limit the results to, or "all" (optional).

Return Values

Type Description
string The labels.

Example

=WIKIDATALABELS("Q64")
en	Berlin

WIKIDATADESCRIPTIONS

Returns the descriptions for a Wikidata item.

Arguments

Name Type Description
qid string The Wikidata item's qid to get the descriptions for.
opt_targetLanguages Array<string>= The list of languages to limit the results to, or "all" (optional).

Return Values

Type Description
string The descriptions.

Example

=WIKIDATADESCRIPTIONS("Q64")
en	capital and city-state of Germany

WIKIQUARRY

Returns the output of the Quarry query with the specified query ID.

Arguments

Name Type Description
queryId number The query ID of the Quarry query to run.

Return Values

Type Description
Array<string> The list of query results, the first line represents the header.

Example

=WIKIQUARRY(1226)
page_title
Alaminos_City.png
Balungao.png
Cab_logo.PNG
…