Crunchbase
+
Google Sheets
+
Microsoft Excel

Crunchbase in your spreadsheet

Import live, refreshable data from your Crunchbase account in Microsoft Excel and Google Sheets.

Import Crunchbase data into your spreadsheet

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

Learn more about Crunchbase 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 Crunchbase function collection with Microsoft Excel or Google Sheets. Please note that you'll need a Crunchbase account with an API key to use this integration.

Need Help?

Have questions? Need help with installation? Need other Crunchbase 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:

Returns a list of organization profiles that match a search term.

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-list-org", search, [properties])

Parameters

Property Type Description Required
search string Search string for the organization's name. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-list-org", "Crunchbase")
=FLEX("YOUR_TEAM_NAME/crunchbase-list-org", "SpaceX")

Notes

The following properties are allowed:

  • permalink: Crunchbase permalink identifier for the organization
  • name: name of the organization
  • stock_exchange: stock exchange for the organization
  • stock_symbol: stock ticker for the organization
  • primary_role:
  • short_description: short description of the organization
  • profile_image_url: profile image url for the organization
  • domain: domain for the organization
  • homepage_url: homepage url for the organization
  • facebook_url: facebook url for the organization
  • twitter_url: twitter url for the organization
  • linkedin_url': linkedin url for the organization
  • city_name: city name for the organization
  • region_name': region name for the organization
  • country_code: country code for the organization

Returns a list of people profiles that match a search term.

Syntax

=FLEX("YOUR_TEAM_NAME/crunchbase-list-people", search, [properties])

Parameters

Property Type Description Required
search string Search string for the person's name. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/crunchbase-list-people", "Steve Jobs")
=FLEX("YOUR_TEAM_NAME/crunchbase-list-people", "Bill Gates")

Notes

The following properties are allowed:

  • permalink: Crunchbase permalink identifier for the person
  • first_name: first name of the person
  • last_name: last name of the person
  • gender: gender of the person
  • title: title of the person
  • organization_permalink: Crunchbase permalink identifier of the organization of which the person is a member
  • profile_image_url: profile image for the person
  • homepage_url: homepage url for the person
  • facebook_url: facebook url for the person
  • twitter_url: twitter url for the person
  • linkedin_url: linkedin url for the person
  • city_name: city name where the person is located
  • region_name: region name where the person is located
  • country_code: country code where the person is located

Use Crunchbase in your spreadsheet now!