How to have KoBo in real time in excel?

Bonjour à tous je veux savoir quel la méthodes pour avoir les données de KOBO en excel eb temps réel sans avoir à télécharger les fichiers exporter

Hi @darata,

Welcome to the community! You could do the same by following the instructions as outlined in the support article Pulling Data Into Excel Power Query. However you may have to manually refresh at certain intervals to see the most updated data that has reached your KoBoToolbox server.

Have a great day!

merci :+1:

1 Like

PLEASE QUE SIGNIFIE : Détails : « Web.Contents n’a pas réussi à obtenir le contenu de « https://kc.humanitarianresponse.info/api/v1/data/458990.xls » (404) : NOT FOUND »

Hi @darata,

Would you mind making your data public. Doing so you should not be seeing error message again.

Have a great day!

comment le fait s’il vous plait ?

Hi @darata,

Kindly please have a look at the post which discusses how to share data publicly:

Have a great day!

1 Like

the columns is xml values
can i make it lables ?

Hi @rahhal
Do you mind looking at the discussions that happened in the following topics

Stephane

2 Likes

thanks @stephanealoo


kc.humanitarianresponse.info
Share Data Publicly: Yes
View data in table
Value and header format: Labels

copy URL and use it in excel: ( just first 100 records !!)
0r, copy https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv

1-Data -New Query- From Other Sources - From Web
past it.
2-Refresh All - connection Properties - Refresh every 1 minutes

1 Like