Data Commons Sheets API

The Data Commons Sheets API is a Google Sheets add-on that enables Google Sheets users to import data from the Data Commons knowledge graph. The add-on provides an interface for finding the dcid of a location, as well as some custom functions for importing data to a spreadsheet.

Getting Started

Install the add-on from G Suite Marketplace here. To enable the add-on in a document, click “Add-ons > Data Commons > Fill place dcids”. You may use the resulting sidebar to start finding dcids in the United States, or close it and reopen it at any time. Note that none of the custom functions will work in a given document until you have enabled the add-on by choosing “Fill place dcids”.