Connecting KoboToolbox data to Microsoft Excel and Power BI

Last updated: 19 Nov 2026

KoboToolbox allows you to connect project data directly to Microsoft Excel and Power BI using the KoboToolbox Application Programming Interface (API). This allows you to retrieve updated submissions for analysis, reports, and dashboards without manually downloading new data files.

Microsoft Excel is a spreadsheet application for organizing and analyzing data, while Power BI is a business intelligence application for creating interactive reports and dashboards.

Both applications support synchronous export links to connect to KoboToolbox. Once connected, you can refresh your data to retrieve new submissions, edits, and other changes made to your project.

This article covers connecting KoboToolbox data to Excel and Power BI, preparing imported data, refreshing your connection, and troubleshooting common issues.

Note: The steps in this article are intended for Windows users. Power BI Desktop is only available for Windows, and the web data connection features described here are designed for Excel on Windows. Excel for Mac supports Power Query, but some connection options and features differ.

Connecting KoboToolbox to Excel or Power BI

Excel and Power BI use Power Query to connect to external data sources. The connection process is similar in both applications, with some differences in how you access and load the data.

Adding the data source

To connect your KoboToolbox project:

  1. Open Microsoft Excel or Power BI Desktop.

    • In Excel, open a blank workbook or an existing workbook.

    • In Power BI Desktop, open a blank report or an existing report.

  2. Open the web data connector:

    • In Excel, go to Data > Get Data > From Other Sources > From Web.

    • In Power BI, go to Home > Get data > Web.

  3. Select Basic in the web connection window, if prompted to choose a URL entry method.

  4. Paste the synchronous export link you retrieved from KoboToolbox.

  5. Click OK.

Power BI Get data menu with Web selected

Authenticating your connection

If your KoboToolbox project is private, you must authenticate the connection to access its data.

  1. In the authentication window, select Basic as the authentication method.

  2. Enter your KoboToolbox username and password.

  3. Select the appropriate URL level for applying your credentials.

  4. Click Connect.

Excel or Power BI will then connect to your KoboToolbox project and retrieve the available data.

Access Web content authentication dialog

Note: If your project is public, you can select Anonymous instead of Basic authentication. However, making a project public allows anyone with the appropriate link to access its submissions.

Selecting and loading your data

Once connected, Excel or Power BI will display your data in the Navigator or Power Query Editor, depending on the export format and how the data is recognized.

If you are using an XLSX export, your project data may appear as multiple tables or sheets. If applicable, each repeat group is included in a separate sheet.

To prepare your data:

  1. Select the table or sheet you want to import. If available, enable Select multiple items to import more than one table.

  2. Click Transform Data to open the Power Query Editor.

  3. Review the imported data and make any necessary adjustments, such as:

    • Removing unnecessary columns.

    • Renaming columns.

    • Changing data types.

    • Filtering records.

    • Expanding nested columns or converting structured data into tables, if needed.

  4. When your data is ready:

    • In Excel, click Close & Load to load the data into your workbook.

    • In Power BI, click Close & Apply to load the data into your report.

You can now use the imported data to create tables, charts, reports, and dashboards.

Note: You can connect multiple KoboToolbox projects to the same Excel workbook or Power BI report. Repeat the connection process for each project using its synchronous export link.

Working with imported data

After importing your KoboToolbox data, you can use the available tools in Excel or Power BI to analyze and visualize your results.

Working with data in Excel

Excel allows you to organize imported data into tables and create summaries using PivotTables and PivotCharts.

If your data was loaded into the Power Query connection without appearing in a worksheet, you can load it manually:

  1. Go to Data > Queries & Connections.

  2. Right-click the query you want to load.

  3. Select Load To….

  4. Choose Table and select the worksheet where you want to display the data.

  5. Click OK.

You can also use PivotTables to summarize your project data:

  1. Go to the Insert tab.

  2. Select PivotTable.

  3. Choose From External Data Source.

  4. In the window that appears, select Choose Connection.

  5. Select the connection associated with the query you created.

  6. Choose where you want to place the PivotTable and click OK.

Use the PivotTable Fields pane to select the variables you want to analyze.

For more information about creating PivotTables, see Microsoft's Excel documentation.

Working with data in Power BI

Power BI allows you to build interactive reports and dashboards using your imported KoboToolbox data.

After loading your data:

  1. Open the Report view.

  2. Select a visualization type, such as a bar chart, table, or map.

  3. Add fields from your imported KoboToolbox data.

  4. Customize the visualization as needed.

Power BI report view with KoboToolbox data loaded in the Data pane

If your project includes multiple tables, such as repeat group data, you may need to establish relationships between them before combining their fields in visualizations.

To manage table relationships, go to Model view and create relationships using the appropriate identifiers.

Refreshing your data

When new submissions are received or existing records are edited or deleted in KoboToolbox, you need to refresh your connection in Excel or Power BI to retrieve the updated data.

Refreshing retrieves the latest available export from KoboToolbox without requiring you to generate a new export link.

Refreshing data in Excel

To refresh your data manually:

  1. Open your Excel workbook.

  2. Go to the Data tab.

  3. Click Refresh All to update your connected queries.

You can also configure some Power Query connections to refresh when the workbook opens or at regular intervals through the connection properties.

Refreshing data in Power BI

To refresh your data manually in Power BI Desktop:

  1. Open your Power BI report.

  2. Go to the Home tab.

  3. Click Refresh.

Power BI will retrieve the latest available data from your KoboToolbox connection.

You can also configure scheduled refreshes through the Power BI service after publishing your report. To configure scheduled refreshes in Power BI:

  1. In Power BI Desktop, go to the Home tab and click Publish to publish your report.

  2. Open the Power BI service and sign in using the same account you used to publish the report.

  3. Go to Workspaces and open the workspace containing your published report.

  4. In the workspace, find the item with the same name as your report and Semantic model in the Type column.

  5. Click the Schedule refresh icon next to the semantic model to open its refresh settings.

  6. Configure the data source credentials, if required.

  7. Under Refresh, enable scheduled refresh, select the refresh frequency, and set your preferred refresh times.

  8. Click Apply to save your settings.

Power BI workspace showing Schedule refresh option on a semantic model

The number of scheduled refreshes available depends on your Power BI license and capacity. For example, Power BI Pro supports up to eight scheduled refreshes per day.

Note: Synchronous exports are cached for up to five minutes, so new submissions may not appear immediately after refreshing. Refreshing Excel or Power BI does not bypass this interval.

Troubleshooting

Unable to connect to KoboToolbox
If Excel or Power BI cannot connect to your project, check that:
  • You are using the correct synchronous export link.
  • Your KoboToolbox username and password are correct.
  • Your account has permission to view the project's submissions.
  • You selected the appropriate authentication method.
If you previously connected to KoboToolbox using another account on the same server, Excel or Power BI may be using stored credentials from the earlier connection.

To update your credentials:
  1. Open Data source settings:
    • In Excel: Go to Data > Get Data > Data Source Settings.
    • In Power BI Desktop: Go to File > Options and settings > Data source settings, or Home > Transform data > Data source settings.
  2. Select the KoboToolbox connection.
  3. Click Edit Permissions to update the credentials, or Clear Permissions to remove the saved credentials.
  4. Reconnect using the correct KoboToolbox account.

Unable to refresh data
If your connection works initially but fails when refreshing, possible causes include:
  • Changed credentials: Your KoboToolbox password or authentication settings may have changed. Update your credentials in the data source settings.
  • Changes to the form: Questions may have been renamed or deleted, affecting the structure of the imported data. Open the Power Query Editor and review the affected steps.
  • Data type errors: Changes to question types or imported column formats may cause errors. Review and adjust the column data types in Power Query.
  • Export limitations: Large projects may exceed the synchronous export processing limit. Consider filtering submissions or excluding unnecessary fields in your saved export settings.

Missing repeat group data
If your project contains repeat groups but the data does not appear in Excel or Power BI, check that you are using the XLSX synchronous export link.

CSV exports do not include repeat group data. XLSX exports include repeat groups as separate sheets, which must be imported and linked to the main submission data when needed.

Data is not updating
If new submissions do not appear after refreshing:
  1. Confirm that the submissions are visible in your KoboToolbox project.
  2. Check whether filters in your saved export settings exclude the new submissions.
  3. Allow at least five minutes for the synchronous export cache to update.
  4. Refresh the connection again in Excel or Power BI.
If you are using scheduled refresh in Power BI, also check the refresh history for errors and confirm that the schedule is enabled.