Wikipedia

Wikipedia Functions & Syntax

Overview

Wikipedia is an online open-source encyclopedia which provides a database of articles on an extensive range of topics. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can quickly enrich your spreadsheet with data from Wikipedia.

What you can do

With this integration, you can:

  • Import a list of people from Wikipedia with information about them
  • Import a list of organizations from Wikipedia with information about them
  • Lookup biography and profile summaries for people and organizations
  • Enrich a list of topics with information from related Wikipedia articles

What you need

You need to have a Flex.io account to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Wikipedia Topic Description

Returns the first sentence of the Wikipedia entry for a given search term

Syntax

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-description", search)

Sample Usage

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-description", "Yellowstone National Park")
=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-description", "JS Bach")

Parameters

Property Type Description Required
search string Text search of Wikipedia true

Returns

Property Type Description
description string The first sentence of the Wikipedia entry for the given search term

Notes

Wikipedia Organization Enrichment

Returns profile information of an organization from Wikipedia based on given search term

Syntax

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-org", search, [properties])

Sample Usage

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-org", "Google")
=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-org", "Apple")

Parameters

Property Type Description Required
search string Text search of Wikipedia true
properties array The properties to return (defaults to 'description'). See "Returns" for a listing of the available properties. false

Returns

Property Type Description
label string A label for the organization
description string A description of the organization (default)
wikipedia_url string The wikipedia url for the organization
website string The website for the organization
official_name string The official name for the organization
short_name string A short name for the organization
motto string The organization's motto
inception string The date the organization was founded
country string The country the organization is based in
twitter_id string The organization's twitter id
instagram_id string The organization's instagram id
reddit_id string The organization's reddit id
bloomberg_id string The organization's bloomberg id
updated_dt string The date the information was last updated

Notes

Wikipedia People Enrichment

Returns profile information of a person from Wikipedia based on given search term

Syntax

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-people", search, [properties])

Sample Usage

=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-people", "Teddy Roosevelt")
=FLEX("YOUR_TEAM_NAME/wikipedia-enrich-people", "JS Bach")

Parameters

Property Type Description Required
search string Text search of Wikipedia true
properties array The properties to return (defaults to 'description'). See "Returns" for a listing of the available properties. false

Returns

Property Type Description
label string A label for the person
description string A description of the person (default)
wikipedia_url string The wikipedia url for the person
gender string The person's gender
birth_name string The person's birth name
given_name string The person's given (first) name
family_name string The person's family (last) name
native_name string The person's native name
birth_date string The person's birth date
death_date string The person's death date
birth_place string The person's birth place
death_place string The person's death place
religion string The person's religion
citizenship string The person's country of citizenship
native_language string The person's native language
father string The person's father
mother string The person's mother
spouse string The person's spouse
residence string The person's place of residence
occupation string The person's occupation
education string The person's education
net_worth string The person's net worth
twitter_id string The person's twitter id
instagram_id string The person's instagram id
reddit_id string The person's reddit id
bloomberg_id string The person's bloomberg id
updated_dt string The date the information was last updated

Notes

Need help?

Have questions? Need help getting started? Need other Wikipedia templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!