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.

eli

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 https://kf.kobotoolbox.org and https://kc.humanitarianresponse.info

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

eli

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.