Hi Support team,
My name is Charles from Nigeria, I currently work for an international development organization. I am involved in a lot of data gathering, analysis, and reporting.
I have a data on my kobo account which I want to connect to Power Bi, Google Sheets, or excel. I need to fetch data from the kobo server in real-time to any of these (Power Bi, Google Sheet, or excel). I was able to fetch the data from Kobo to Power Bi and Excel, but the data imported does not come in the form of the normal excel export. The data fetched looks very distorted and dirty which find it very difficult to clean. I will also like to state that the form contains a repeat group
Thanks in anticipation
screening_xlsform.xlsx (13.2 KB)