Glad it work now . I just released a new one where I'm using the option of connecting to the web with the basic option. Though it is in Power BI, the same will work for Excel.

Thank Janet. One thing I found once you connect Kobo to Excel, you can then use power queries to for your data transformation, shaping and calculation. a simple click on the refresh button then you've got everything updated.

Hi, I have the same problem could you solve it?

Hey! I have the same query. Did you find an answer?

The error "Web.Contents failed to get contents from the API" in Excel typically means that Excel was unable to retrieve data from the specified API endpoint. This error can occur due to several reasons, such as incorrect API endpoint URL, missing or incorrect authentication credentials, network connectivity issues, or an issue with the API itself. To solve this problem, you can try the following steps: 1) Verify that the API endpoint URL is correct and active. 2) Check if you have provided the correct authentication credentials, such as API key, OAuth token, etc. 3) Ensure that your network connection is stable and there are no firewalls blocking the connection. 4) Try to access the API endpoint using a web browser or other tools to confirm that the endpoint is working correctly. 5) If the issue persists, you may need to contact the API provider or your IT department for further assistance. It is also worth noting that some APIs have rate limits or other usage restrictions that may cause errors, so make sure to check the API documentation for any such restrictions. Hope this helps

check the extension of your file. Is it xls or xlsx. If the Excel file to be Imported has the extension '.xlsx', then this requires Excel drivers that are for 2007 and onwards. Please install the new Microsoft.ACE.OLEDB.12.0 drivers.

this is weird. Did you get an error message

not sure why you are having this problem. Alternatively I would retry to connect to kobo with out have the dataset sharable mode. take a look at this video. kzfaq.info/get/bejne/mbhymdmi0svOeIE.html&ab_channel=AnalyzeIt

just update accessibility on project share to everyone and it works

Je te recommande de regarder cette video ou tu n'auras pas besoin de gerer les parametres de partage de Kobo. Bien que c'est pour Kobo connecté a Power BI, C'est la meme operation. kzfaq.info/get/bejne/mbhymdmi0svOeIE.html

did you checkmark the shareable option in Kobo ?

@@AnalyzeIt_Nael Yes, I ticked both in Kobo but still can't connect

This problem usually happens when the computer is using the Proxy/VPN. Please disable the Proxy/VPN temporary and try again.

@@AnalyzeIt_Nael thanks let me try this way.

@@Nighttimestories, please let me know if its works. I m curious about that too

Thanks. I would also suggest you to take a look at the updated video that I made on that matter. in that one I'm showing how to do the same using your Kobo Account credential (i.e not making the project publicly available). kzfaq.info/get/bejne/mbhymdmi0svOeIE.html&ab_channel=AnalyzeIt

As long as you have the URL for you data source, it should works.

As long as you can get the URL, it should work

Kobo is mainly a tool use for mobile data collection and it is not for storage or warehouse data purpose. If you have your data already in and excel spreadsheet , that means the data have already been collected. So not sur why you want to put it in Kobo. But your question is still an interesting feature that I need to investigate. Will let you know. In the meantime you can post this question as well in kobo helpdesk

Actually, I think the easiest way would hav been in Kobo to set the value with the value name. Alternatively, you could (in Excel) duplicate the variable (column) and use find/replace with the variable name.

I just released a new version. The main difference is that you don't need to set kobo share option. Though it is for connecting to Power BI, it is the same process and it should work with Excel. kzfaq.info/get/bejne/mbhymdmi0svOeIE.html

I just released a new version. The main difference is that you don't need to set kobo share option. Though it is for connecting to Power BI, it is the same process and it should work with Excel. kzfaq.info/get/bejne/mbhymdmi0svOeIE.html

what message are you getting?

i am also facing same problem