Connecting KoboToolbox data to Google Sheets and Data Studio

Last updated: 19 Nov 2026

KoboToolbox allows you to connect project data to Google Sheets and Data Studio using the KoboToolbox Application Programming Interface (API). These connections allow you to retrieve updated submissions for analysis, reports, and dashboards without manually downloading new data files.

Google Sheets is a spreadsheet application for organizing and analyzing data, while Data Studio (formerly Looker Studio) is a reporting tool for creating interactive dashboards and visualizations.

You can connect KoboToolbox to Google Sheets using a synchronous export link, then use the connected spreadsheet as a data source in Data Studio.

This article covers connecting KoboToolbox data to Google Sheets and Data Studio, refreshing the data, and troubleshooting common issues.

Note: The Google Sheets method described below uses a public synchronous export link and does not support authentication. It is only suitable for projects where submission data can be made public. For private projects, use an authenticated connection, such as a custom Google Apps Script, instead.

Preparing to connect KoboToolbox to Google Sheets

Before connecting KoboToolbox to Google Sheets, you need to retrieve your project’s synchronous export link and enable public access to submissions.

Enabling public access to submissions

Google Sheets data import does not support authentication, so you must allow public access to your KoboToolbox project submissions.

To enable public access:

  1. Open your KoboToolbox project and go to SETTINGS > Sharing.

  2. Enable Anyone can view submissions made to this form.

This allows Google Sheets to access the synchronous export link without requiring your KoboToolbox credentials.

Note: Enabling this setting makes your project submissions publicly accessible, including to people outside your organization. Only use this method if your data is intended to be public. For more information, see Sharing projects with project-level settings.

Connecting KoboToolbox to Google Sheets

Google Sheets provides an IMPORTDATA() function that retrieves data from a publicly accessible CSV file. You can use this function with your synchronous export link to import KoboToolbox submissions into a spreadsheet.

Importing project data into Google Sheets

To import your publicly accessible KoboToolbox data:

  1. Open Google Sheets and create a new spreadsheet, or add a new sheet to an existing spreadsheet.

  2. Select cell A1.

  3. Enter the following formula, replacing YOUR_EXPORT_URL with your synchronous export link: =IMPORTDATA("YOUR_EXPORT_URL", ";")

  4. Press Enter.

  5. If you see the warning message “Warning: Some formulas are trying to send and receive data from external parties,” click Allow access.

Google Sheets will retrieve the CSV data from KoboToolbox and populate the spreadsheet with your project submissions.

You can then use Google Sheets to filter, summarize, and analyze your data or create charts.

Note: Keep the cells populated by IMPORTDATA() clear of other content. If existing values block the imported data, Google Sheets may display an error.

Connecting Google Sheets to Data Studio

Once your KoboToolbox data is available in Google Sheets, you can connect the spreadsheet to Data Studio to create interactive reports and dashboards.

Data Studio uses the Google Sheets connector to retrieve data from your spreadsheet. You do not need to configure a separate connection to KoboToolbox.

Adding Google Sheets as a data source

To connect your spreadsheet to Data Studio:

  1. Open Data Studio and create a new report.

  2. In the Add data to report window, select Google Sheets.

  3. Authorize access to your Google account if prompted.

  4. Select the spreadsheet containing your KoboToolbox data.

  5. Choose the worksheet containing the imported submissions.

  6. Ensure Use first row as headers is selected.

  7. Click Add or Connect, depending on the interface, and add the data source to your report.

Your KoboToolbox submission fields will now be available for creating charts, tables, filters, and other visualizations.

Creating reports and dashboards

Once connected, you can use Data Studio to create visualizations based on your KoboToolbox data.

For example, you can:

  • Create charts showing trends in data collection.

  • Display summary statistics from your submissions.

  • Add filters to explore data by location, date, or other variables.

  • Combine data from multiple sources in a single report.

You can customize your report and share it with other users according to your organization’s requirements.

Note: Data Studio reads data from the connected Google Sheet. If you add, remove, or rename columns in your spreadsheet, you may need to refresh the data source fields in Data Studio.

Refreshing your data

When new submissions are received or existing records are edited or deleted in KoboToolbox, the changes must be retrieved by Google Sheets before they can appear in Data Studio.

Refreshing data in Google Sheets

Google Sheets automatically checks for updates to IMPORTDATA() approximately every hour while the spreadsheet is open.

To manually trigger a refresh:

  1. Select the cell containing the IMPORTDATA() formula.

  2. Delete the formula.

  3. Reenter the same formula and press Enter.

Google Sheets will request the data again from KoboToolbox.

Note: KoboToolbox synchronous exports are cached for up to five minutes, so recent submissions may not appear immediately after refreshing.

Refreshing data in Data Studio

Data Studio periodically retrieves data from your connected Google Sheet according to its data freshness settings.

To review these settings:

  1. Open your report in Data Studio.

  2. Select Resource > Manage added data sources.

  3. Edit the Google Sheets data source.

  4. Open the Data freshness settings and select your preferred refresh interval.

You can also manually refresh your report using the refresh option in Data Studio.

Note: Refreshing Data Studio does not force Google Sheets to retrieve new data from KoboToolbox. The report can only display the data currently available in the connected spreadsheet.

Connecting private KoboToolbox projects

If your project contains sensitive or private data, you should not enable public access solely to connect it to Google Sheets.

The IMPORTDATA() function does not support the authentication headers required to access private KoboToolbox API endpoints.

For private projects, you can use Google Apps Script or another application that supports authenticated API requests. These tools can retrieve data using your KoboToolbox API key and write the results to Google Sheets.

Once the data is available in a private Google Sheet, you can connect it to Data Studio using the same steps described above.

For more information about API authentication and retrieving project submissions, see Getting started with the API and Using the API data endpoint.

Troubleshooting

Google Sheets cannot import the data

If Google Sheets displays an error when using IMPORTDATA(), check that:

  • You are using the CSV synchronous export link.
  • Your project allows public access to submissions.
  • The export link is correct and accessible.
  • The cells where the imported data should appear are empty.

Large datasets may also exceed Google Sheets import or processing limits.


New submissions do not appear

If your spreadsheet does not show recent submissions:

  1. Confirm that the submissions are visible in your KoboToolbox project.
  2. Check whether your saved export settings include filters that exclude the submissions.
  3. Allow time for the synchronous export cache and Google Sheets import function to update.
  4. Reenter the IMPORTDATA() formula to request the data again.

Data Studio is not showing updated data

If your Google Sheet contains updated submissions but Data Studio does not:

  1. Check the data freshness settings in Data Studio.
  2. Manually refresh the report.
  3. Confirm that the correct spreadsheet and worksheet are connected.
  4. If the structure of your spreadsheet has changed, refresh the data source fields.

Some fields are missing or incorrectly formatted

Check your saved export settings in KoboToolbox to ensure the required questions are included.

Google Sheets and Data Studio may also interpret some fields, such as dates or numeric values, differently. Review the column formatting in Google Sheets and field types in Data Studio.