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

WIKIDATASITELINKS

Returns the Wikipedia site links for a given Wikidata item.

Arguments

Name	Type	Description
qid	`string`	The Wikidata item QID to get the Wikipedia site links for.
opt_sitefilter	`Array<string>=`	The list of Wikipedia sites to limit the results to (optional).

Return Values

Type	Description
`Array<string>`	The list of Wikipedia site links.

Example

=WIKIDATASITELINKS("Q42")

en	Douglas Adams
de	Douglas Adams
fr	Douglas Adams
…

=WIKIDATASITELINKS("Q42", {"en", "de"})

en	Douglas Adams
de	Douglas Adams

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
…