Great tutorial. This is very helpful for me. Thank you
@RuttoAlex4 жыл бұрын
My friend Nael, this is amazing stuff! Thanks for the video. You are always one step head of me :)
@eidrag Жыл бұрын
yes Kobo and Excel, great synergy
@zeineb22632 жыл бұрын
This is an excellent tutorial, it is working now!! 🤩
@AnalyzeIt_Nael2 жыл бұрын
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.
@janetmugo59562 жыл бұрын
This is such an excellent video, you've saved a lot of time for me.
@AnalyzeIt_Nael2 жыл бұрын
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.
@msreza994 жыл бұрын
This is very helpful for me. Thank you very much for your helpful contribution.
@m.asifhussain17302 жыл бұрын
sir what about image and audio data file in kobo? will I get in the excel sheet.
@sadaqajaria91443 жыл бұрын
Great tutorial... thank you
@arsenicgirl1276 Жыл бұрын
Hola! Disculpa, quería preguntar: a la hora de escribir la URL copiada desde word a Excel, me dice que no se encuentra la página web Sabes como se puede resolver esto?
@vikramgupta38275 жыл бұрын
Did you have to make changes in trust settings of excel to enable connection with external database?
@abucubaydah79473 жыл бұрын
Thanks Neal. This very helpful but want your technical assistance of how to connect with excel on mac
@simonblower40483 жыл бұрын
Great tutorial, thank you!
@Did-nm6fo3 жыл бұрын
Hi Nael; thank you so much for this video. Very much appreciated. Please, I have used this procedure. But it connecting me to the names and not to labels of my variables. This makes data analysis and visualisation more complicated. Your help please. thank you again.
@RaquelChaicoj3 жыл бұрын
very helpful, but is there anyway to use label instead the name in the data base???
@banjomartins70623 жыл бұрын
This is a great video Neal, Thank you. I was able to connect Kobo to excel but it failed to refresh when new submissions were made from field. I have tried refreshing countless times but proved abortive. How can I solve this? thanks again
@lauraalajma36953 жыл бұрын
Hi, I have the same problem could you solve it?
@amritsakya2 жыл бұрын
Hi, Thank you for the video. Can we pull labels instead of values???
@julescherylumm45104 жыл бұрын
Thank you so much for the video, one question please. Once how can i update my datas in Kobo? Am not saying adding new records, but modifying existing ones. Can Excel do this for me? Thanks
@zhoulkarimou24674 жыл бұрын
Thank you very much you are so good
@JobShyaka Жыл бұрын
@Analyze it. Can I edit Data in the Excel and its also updated in Kobo? Thats it i linked them up
@3familymedia3 жыл бұрын
Thanks for your video, it was really helpful for me. One question though, Is there a way I can display the pictures(media) in Excel instead of downloading the Zip file from KoBo? Thanks once again.
@gtnaveen2 жыл бұрын
Hey! I have the same query. Did you find an answer?
@juliensombola9311 Жыл бұрын
Thank you for the video but here is my problem : Web.Contents failed to get contents from the API, how will I solve this problem
@AnalyzeIt_Nael Жыл бұрын
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
@mariaelenacabrera86253 жыл бұрын
it is amazing! thank you
@martingodoy68214 жыл бұрын
Hi! how to connect kobo to excel in a research account?
@zohasinasafidymiarantsoaai31252 жыл бұрын
Wonderful! is there a way to automatically download media attachment files? thanks
@technologieetautres38262 жыл бұрын
i get this troube,please help me : "External table is not in the expected format."
@AnalyzeIt_Nael2 жыл бұрын
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.
@marylusenie6893 жыл бұрын
Please help. i have used the link , it shows the API , but i cannot connect
@thanoo7640 Жыл бұрын
One issue, after loading data to excel, some of the data is missing. how can I fix it
@AnalyzeIt_Nael Жыл бұрын
this is weird. Did you get an error message
@albertyendor60432 жыл бұрын
please i have followed the steps but this is the error im getting; This error (HTTP 404 Not Found) means that this program was able to connect to the website, but the page you wanted was not found. It's possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpage.
@AnalyzeIt_Nael2 жыл бұрын
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
@rangahuruba5836 Жыл бұрын
just update accessibility on project share to everyone and it works
@mukeshmishra71004 жыл бұрын
Sir, how to add logo on the every survey page in the ODK. I know how to add a logo on the front page but I don't know how to add logo on every page.
@hamedsougue98183 жыл бұрын
Thanks a lot
@yoroedsondidier2 жыл бұрын
bonjour formateur, je n'arrive pas à gérer les paramètres de partage des données de kobo à excel via power query; pourriez vous m'aider?
@AnalyzeIt_Nael2 жыл бұрын
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
@Nighttimestories2 жыл бұрын
I tried based on your video review but the result is DataSource.Error: The underlying connection was closed: An unexpected error occurred on a send. what wrong is it?
@AnalyzeIt_Nael2 жыл бұрын
did you checkmark the shareable option in Kobo ?
@Nighttimestories2 жыл бұрын
@@AnalyzeIt_Nael Yes, I ticked both in Kobo but still can't connect
@AnalyzeIt_Nael2 жыл бұрын
This problem usually happens when the computer is using the Proxy/VPN. Please disable the Proxy/VPN temporary and try again.
@Nighttimestories2 жыл бұрын
@@AnalyzeIt_Nael thanks let me try this way.
@AnalyzeIt_Nael2 жыл бұрын
@@Nighttimestories, please let me know if its works. I m curious about that too
@habtamu.a4322 жыл бұрын
it is anice presentation
@AnalyzeIt_Nael2 жыл бұрын
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
@kangsocheata98692 жыл бұрын
Excuse me, this way is use for Humanitarian data, and what about other data, does it do the same?
@AnalyzeIt_Nael2 жыл бұрын
As long as you have the URL for you data source, it should works.
@AnalyzeIt_Nael2 жыл бұрын
As long as you can get the URL, it should work
@MafizulIslamIT4 жыл бұрын
Can you share a similar version for Power BI?
@AhmadAli-kw5oo3 жыл бұрын
I did the same but did not work for me . can anybody help, please?
@PeopleHealthDevelop2 жыл бұрын
Can we do data entry in excel then link it to KoBo?
@AnalyzeIt_Nael2 жыл бұрын
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
@thomaspharris5 жыл бұрын
Thanks for your video, it was really helpful for me. One question though, the file pulled into Excel is displaying the KoBo XLS form names column instead of the labels (which contains the names I am interested in). Is there a way I can display the label in Excel instead of the form column names from KoBo? Thanks once again.
@AnalyzeIt_Nael5 жыл бұрын
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.
@ucomsatadminoffice81362 жыл бұрын
my friend, i try to connect kobo and excel it don't work. pls i need a help
@AnalyzeIt_Nael2 жыл бұрын
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
@pngpower20202 жыл бұрын
im having problems with this. Please i really need your help
@AnalyzeIt_Nael2 жыл бұрын
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
@almanamo68582 жыл бұрын
@yvonnedede48824 жыл бұрын
please kindly assist me to add a phone number to my questionnaire by using validation criteria
@digitalworldclub34113 жыл бұрын
Unable to connect ? What to do
@AnalyzeIt_Nael2 жыл бұрын
what message are you getting?
@erosfaus4 жыл бұрын
Hello, thanks for the video. Excel ask me for user and password when write the URL... I used the same of the Portal but do not work. Some one know the problem?*