Search the knowledge base, browse our resources, and visit our forum for more detailed information
Last updated: 13 Sep 2025
KoboToolbox offers two primary methods for accessing your data: asynchronous and synchronous exports. The standard asynchronous method involves manually downloading data files containing all submissions up to the time of download. In contrast, synchronous exports enable automatic integration of your KoboToolbox data with external applications such as Microsoft Power BI, Excel, or Google Sheets.
With synchronous exports, your data updates automatically as new submissions are received, eliminating the need for manual refreshing. This method provides a CSV or XLSX file, configured with your predefined export settings, which can include question labels, languages, filters, and repeat group data.
Note: This article focuses on synchronous exports, which is one of two primary ways to use the KoboToolbox API. The other is the JSON API, designed for custom scripts and real-time automations, delivering raw, record-by-record JSON data. Unlike synchronous exports, the JSON API does not include advanced export features such as question labels or support for multiple languages.
This article covers the following steps:
Generating a named export
Retrieving the synchronous export link
Connecting your data to an external application & authentication
To generate synchronous exports, you must first create a named export for your project by following these steps:
In your KoboToolbox project, navigate to the DATA > Downloads tab.
Adjust the export settings as needed.
Click Advanced options to customize the data for export.
Choose Save selection as… and provide a name for your export.
Click Export to save these settings.
To retrieve the synchronous export link, you will need the following:
Project asset UID: A unique ID for each KoboToolbox project, found in the project’s URL.
Server URL: The URL of the server you are using (kf.kobotoolbox.org
for the Global Server, eu.kobotoolbox.org
for the European Union Server, or [your organization].kobotoolbox.org
for private servers).
For more information about retrieving the server URL and project asset UID, see Getting started with the API.
To retrieve the export link, follow these steps:
Open a new browser tab.
Replace your server URL and project asset UID in the following URL: https://[server_url]/api/v2/assets/[project_asset_uid]/export-settings/
.
Open the webpage corresponding to the modified URL.
Scroll to the CURRENT ENDPOINT section.
Find the export setting that matches the named export you created in the first step.
Locate the data_url_csv
and data_url_xlsx
links, which are your project’s synchronous export links.
Copy the link that best suits your needs (CSV or XLSX file).
Note: Repeat groups are exported as separate sheets in Excel files and are not included in CSV exports. If your project contains repeat groups, use the data_url_xlsx
link.
After retrieving the synchronous export link, you can connect your data to your preferred external application. The method for integrating the synchronous export link will vary by application.
To learn how to connect your data to Power BI to create custom dashboards, see Connecting KoboToolbox to Power BI.
To learn how to connect your data to Microsoft Excel, see Connecting KoboToolbox to Microsoft Excel.
Many external applications can connect to your KoboToolbox data. However, not all support authenticated requests, which are requests that carry credentials (e.g., the API key or username and password) so the server can verify the caller’s identity. If the external application does not support authenticated requests, it will only be able to reach resources that have been made publicly accessible through an anonymous export link.
To connect your project without authentication (e.g., to Google Sheets), you will need to ensure the “Anyone can view submissions made to this form” setting is checked in SETTINGS > Sharing.
For more information about project sharing, see Sharing projects with project-level settings.
For projects with sensitive or private data, the “Anyone can view submissions made to this form” option should remain unchecked. In these cases, consider using only applications that support authenticated requests.
When using applications that support authenticated requests, such as Power BI, you will be asked for basic authentication with your username and password or for a token (also called API Key) to access the data. Your API Key is located in your ACCOUNT SETTINGS under the Security tab.
For more information about the API Key, see Getting started with the API.
To maintain server reliability, synchronous exports have the following limitations:
Data refresh interval: Data in synchronous exports update every 5 minutes. Export requests made within this 5-minute window will not include new submission data received within the 5-minute interval.
Export completion time: Exports must complete within 120 seconds. Projects with a large number of submissions or questions may fail. To avoid this, add a query constraint in the export settings to limit submissions or filter out unnecessary questions. Refer to this Community Forum post for guidance.
Did you find what you were looking for? Was the information clear? Was anything missing?
Share your feedback to help us improve this article!
KoboToolbox is maintained by Kobo Inc.