ODK Central to Google Sheets

Development
1

What is the simplest way to pull data directly from ODK Central to Google Sheets?

2

Hi Tony,

Currently there is no out-of-the-box way to pull data into Google Sheets. Google has recently added Data Connectors for BigQuery and Looker, they might build a connector for general APIs, till then you have two options:

  1. Manually export CSV from Central and import it in Google Sheets
  2. Rely on third-party add-ons

:warning: I don't endorse any third-party add-ons, use it at your own risk. Make sure to read the terms and conditions + privacy agreement before installing any add-ons

I have just tried API Connector, it does the job

image
image859×1017 72.4 KB

3

HI. Thanks for your reply. Would it be possible to do a quick step by step guide to link API Connector to Central an pull the headers and data in?

Thanks