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 |
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 |
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 |
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!