Importing KoBoToolbox Data to Google Spreadsheets

Hello KoBoToolbox Community,

I would like to import data collected by KoBoToolbox to Google sheets. So far I have followed this approach, Import KoboToolBox API Data into Google Sheets [2021] | API Connector and the only thing I imported is more like metadata, and not the intended data that I need for analysis! See attachment.

Please let me know how you succeeded to import data from KoBoToolbox to Google sheets.

Appreciating for your great help.


Welcome to the community, @elimboto! Maybe this post discussed previously should help you solve your issue:

Hi @Kal_Lam

I followed the procedure and did not get the real data, as described previously. Sorry, I should have mentioned that Iā€™m using and

It is not clear how to find an API that will pull the submitted data. Any further idea?


Here is an elegant solution using KoBoExtractor (Post #6):

1 Like

Thank you for sharing this with the entire community, @elimboto! The community should greatly benefit.