Wikipedia
+
Google Sheets
+
Microsoft Excel

Wikipedia in your spreadsheet

Import live, refreshable data from Wikipedia in Microsoft Excel and Google Sheets.

Import Wikipedia data in your spreadsheet

This collection of Wikipedia spreadsheet functions enables you to collect or analyze data from your Wikipedia account directly from your spreadsheet. For example, pull in on-demand, refreshable extract lists from Wikipedia. Or, enrich existing data in your spreadsheet with lookups from Wikipedia.

Learn more about Wikipedia spreadsheet functions and syntax here.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Wikipedia function collection with Microsoft Excel or Google Sheets.

Need Help?

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

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)

Parameters

Property Type Description Required
search string Text search of Wikipedia true

Sample Usage

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

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])

Parameters

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

Sample Usage

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

Notes

The following properties are allowed:

  • label: a label for the organization
  • description: a description of the organization
  • wikipedia_url: wikipedia url for the organization
  • website: the website for the organization
  • official_name: the official name for the organization
  • short_name: a short name for the organization
  • motto: the organization's motto
  • inception: the date the organization was founded
  • country: the country the organization is based in
  • twitter_id: the organization's twitter id
  • instagram_id: the organization's instagram id
  • reddit_id: the organization's reddit id
  • bloomberg_id: the organization's bloomberg id
  • updated_dt: 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])

Parameters

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

Sample Usage

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

Notes

The following properties are allowed:

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

Use Wikipedia in your spreadsheet now!