How to have KoBo in real time in excel?

[stephanealoo]

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

Using API to obtain to excel with variable labels

I do al follows: You need to change the sharing settings of your form for this to work ( caution with sensitive data) [image] Then I use: https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv to obtains the lables in the default languague… of if the lang you need is called "::English (en)" https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv?lang=English (en) then query with Power query or PowerBi

Labels in dataset synced with via API (Excel Power query)

I use API to connect Kobo with an excel file on my server which works well to automatically download the data. However, it downloads only the values and I would prefer to have the labels instead (e.g. for column headers or choice questions). Anyone knows if it is possible to get the labels and if so, how it works?

Stephane