Search the knowledge base, browse our resources, and visit our Community Forum for more detailed information
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.
Before connecting KoboToolbox to Google Sheets, you need to retrieve your project’s synchronous export link and enable 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:
Open your KoboToolbox project and go to SETTINGS > Sharing.
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.
A synchronous export link allows external applications to retrieve project data in CSV or XLSX format using saved export settings. The link remains the same, but the data is updated when the external application refreshes its connection.
To generate and retrieve your link, follow the instructions in Using the API for synchronous exports.
For Google Sheets, use the CSV link, which provides your project data in CSV format.
Note: CSV exports do not include repeat group data. If your project contains repeat groups, you will need to use an XLSX export and a different import method to include those records.
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.
To import your publicly accessible KoboToolbox data:
Open Google Sheets and create a new spreadsheet, or add a new sheet to an existing spreadsheet.
Select cell A1.
Enter the following formula, replacing YOUR_EXPORT_URL with your synchronous export link: =IMPORTDATA("YOUR_EXPORT_URL", ";")
Press Enter.
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.
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.
To connect your spreadsheet to Data Studio:
Open Data Studio and create a new report.
In the Add data to report window, select Google Sheets.
Authorize access to your Google account if prompted.
Select the spreadsheet containing your KoboToolbox data.
Choose the worksheet containing the imported submissions.
Ensure Use first row as headers is selected.
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.
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.
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.
Google Sheets automatically checks for updates to IMPORTDATA() approximately every hour while the spreadsheet is open.
To manually trigger a refresh:
Select the cell containing the IMPORTDATA() formula.
Delete the formula.
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.
Data Studio periodically retrieves data from your connected Google Sheet according to its data freshness settings.
To review these settings:
Open your report in Data Studio.
Select Resource > Manage added data sources.
Edit the Google Sheets data source.
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.
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.
If Google Sheets displays an error when using IMPORTDATA(), check that:
Large datasets may also exceed Google Sheets import or processing limits.
If your spreadsheet does not show recent submissions:
IMPORTDATA() formula to request the data again.If your Google Sheet contains updated submissions but Data Studio does not:
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.
Did you find what you were looking for? Was the information clear? Was anything missing?
Share your feedback to help us improve this article!