How to import kobotoolbox data into SPSS for Analysis- Easy tutorial for beginners.

[@aminatu9608]

Never knew this. Assumed since it was stored in the cloud, it automatically downloaded all the labels in the correct place. I am so going to try this. Thanks.

[@SPSS4RESEARCH]

Thank you Dr ☺️

[@lakishimko9541]

God will continue to bless you sir, I have looked for this over the whole internet and KZbin without success. Thank you so much! God bless you

[@SPSS4RESEARCH]

😀

[@nelsonudeme-abasi7647]

It's the Okey Dockey for me. Thank you sir

[@PublicHealthResources]

Me too😂

[@ismailraji1832]

Wow! "Easy peasy lemon squeeze". Unravelled. Thanks. I am definitely sharing this vid with colleagues

[@SPSS4RESEARCH]

Nagode Sir, patiently waiting for you to come on stage!! The world needs you☺

[@yariisaycidda4225]

​@@SPSS4RESEARCH1:49 1:49

[@ismailzubair3975]

You've got no idea how helpful this is for me. Thank you very much sir

[@SPSS4RESEARCH]

I am glad this was helpful chief!!

[@musaabdullahigarba978]

Woh! Remain grateful for your contribution in building our capacity in the field of research. May the lord Almighty continue to bless you Sir

[@SPSS4RESEARCH]

Thank you Dr. Your support is much appreciated 🙏

[@t-chip8029]

I was almost crying and thinking of restarting it the medieval way. Thank you very much

[@SPSS4RESEARCH]

You are most welcome 🤗

[@shathilrahmanlemon5521]

MashaAllah, Your teaching skill is unbelievably good sir. Thank you for your contribution. Keep doing such amazing work.

[@SPSS4RESEARCH]

I appreciate your feedback 🤗

[@aminulawal88]

May Allah SWT reward you in abundance Sir...

[@SPSS4RESEARCH]

Amin and you too sir

[@elvisabodoo2839]

This guy is super good in delivery. Great command of the teaching skill. Kudos

[@SPSS4RESEARCH]

I appreciate your feedback Elvis 👍

[@Milkessa]

Thank you very much Big Brother. Finally, i have succeeded in exporting my Kobo data to SPSS by help of your tutorial

[@SPSS4RESEARCH]

Am glad you found this helpful. Cheers 👍

[@badrulawal7273]

Thank you, sir. I have been waiting for this for a long time. You are the best

[@badrulawal7273]

Thank you sir. I am waiting for the day you will discuss logistic regression,it's assumptions and the interpretation. Hope it will be very soon. Thank you sir

[@SPSS4RESEARCH]

You are most welcome, Chief Badru 😊

[@SPSS4RESEARCH]

@@badrulawal7273 Hopefully very soon sir, God willing. I will be starting a full series for data analysis, please stay tuned. Thank you also for your support 🙏

[@badrulawal7273]

@@SPSS4RESEARCH Thank you sir

[@naretuyussuffadams8151]

Knowledge they say is key. Thanks for the opportunity.

[@SPSS4RESEARCH]

Thank you Ma’am ☺️

[@kenyanyoutuber7430]

wooow, i followed all the steps and am great now. Thankyou

[@SPSS4RESEARCH]

Awesome! Wishing you the best

[@hirutgemeda1709]

Dear Professor, I appreciate you for your quick response. You are a great person and dedicated to helping those in need. Really thank you. In the Select export type button, I could not get "XML" but XLS, CSV, GeoJSON, SPSS Labels, CSV (legacy), GPs coordinates (KML), XLS(legacy), and Media Attachment(ZIP) are found. Under the value and header format, there is XML Value and Headers.

[@SPSS4RESEARCH]

Hi Hirut, you are on the right path. Just select the XLS and then under the value and header format select “XML value and Headers” then export. With this you will have the excel file that you can import into SPSS. Then you can get the SPSS labels 🏷️. I will create a document to guide you if you still have issues by tomorrow. Cheers

[@KONEDAOUDA-n4q]

@@SPSS4RESEARCH , Hello professor, I want to export data from kobotoolbox (SPSS label and Value) to SPSS for processing and analysis of the results. To do this, I followed your dedicated video. But, the exported SPSS Syntax file is corrupted. see Spss screenshot. Thank you for assisting me. CAPTURE ECRAN

[@igwemoses2841]

This tutorial is helpful thank you for sharing

[@misheldauda1719]

This is really helpful and insightful, thank you for helping out sir

[@SPSS4RESEARCH]

Thank you Dr Mishel👍

[@DesalewMulu-q7d]

I am the one who needed this software, Owe you one and am searching for your video all about the Kobo toolbox. Your expression style is amazing and makes me gasp the message easily.

[@SPSS4RESEARCH]

Glad you found it useful 🤗

[@mosesrufas1145]

Thanks so much, that's the video am been waiting for

[@SPSS4RESEARCH]

You are most welcome Moses.

[@trysonchisenga9406]

I give this tutorial 5 star ⭐, finally i can proceed with my project

[@SPSS4RESEARCH]

Glad you found it useful

[@glorianjoku5751]

Great , a 5 star for you Sir, a trick no one can share with you for free.

[@SPSS4RESEARCH]

Many many thanks Gloria 😊

[@ojedemorris4632]

i really really want to so thanks you so much guest ur one of the most loved lecturer

[@SPSS4RESEARCH]

You are welcome Ojede. Thank you too 😃

[@AuwalSG]

Thank you very much sir. I am so glad I watched this video. May Allah reward you for this and hope you will continue to share you knowledge and skills with us...

[@SPSS4RESEARCH]

Amin and you too sir. 👍

[@lamiibrahim4131]

Thank you sir, such a great knowledge

[@SPSS4RESEARCH]

You are most welcome Lami👍

[@stephenlugaimukamu9187]

Thanks a lot, I have been searching for this solution for so long, am very happy for what you have done Thanks once again

[@SPSS4RESEARCH]

You are very much welcome sir😊

[@danladiyusuf8802]

Masha Allah, Allah ya bada lada mai gida. Thank you very much sir.

[@SPSS4RESEARCH]

Amin sir

[@anthonygikuri]

I can tell you, I'm a frequent user of Kobo but this is the area I struggled onr day. It was awful. Thank you so much

[@SPSS4RESEARCH]

Glad it helped!

[@abdulchaba3188]

Thank you sir for your tutorials, they've been really helpful

[@SPSS4RESEARCH]

Happy to help 🤗

[@bukkynelly5622]

This is super helpful sir. Thank you so much😊

[@SPSS4RESEARCH]

👍

[@eponguwilbert6541]

Thank you so much Prof. This has been so helpful 🙏 I've been even more motivated by "Let's allow the computer to do it's job, and we use our brains to do better things😊😊"

[@SPSS4RESEARCH]

I am glad you found this useful Epongu 😊

[@ay542]

Thank you very much for this sir

[@SPSS4RESEARCH]

You are welcome, always.

[@biniyamlikinaw8634]

I can't seem to find the option " labels" in the value and header format options, can you help? pls

[@EpiInfoforRookiesE4R]

No worries Biniyam☺️. You need to first select SPSS-LABELS under the “select export type” if you don’t select SPSS-LABELS then you won’t be able to see the option “labels” under the “value and header format options. I hope this helps?

[@rojinachaulagain22]

@@EpiInfoforRookiesE4R hello since i am following ur videos..i selected spss level under select export type but the options are available as english and XML values and headers under value and header format.. i tried but couldnot find out values option only ..so could you help me out of this

[@hirutgemeda1709]

Dear Professor, thank you so much for your clear and simple description. When I try to click the label button there is no such a word in the option. There are other options like English language, local language that I used to translate and XML values and header. How can I get the label? please.

[@SPSS4RESEARCH]

Hi Hirut. The interface has changed a bit but no worries. Just go under downloads, select “SPSS labels” and under value and header format select “XML values and Headers”. Then export and download. Then go to the select export type and select “XML” then under value and header format select “XML values and Headers”. Then export and download. So you should have 2 files now. Then follow the process to import into SPSS and you should be good to go. Let me know how it goes.

[@dumisanimapazi4164]

I enjoyed this video very much, and I had been struggling with this but now I'm able to do it on my own

[@SPSS4RESEARCH]

Great 👍 Am glad you found this video impactful

[@seme15harshsaini62]

sir it would be of a help if you could provide a video of how to check reliability analysis of the data.

[@SPSS4RESEARCH]

Great feedback Harsh. Working on it. Please stay tuned🙌

[@RemmingtonPachiti]

This is a great, insightful and helpful tutorial. Thank you very much.

[@SPSS4RESEARCH]

Happy to help ☺️

[@aminuliman2104]

Thank you for this wonderful explanation

[@SPSS4RESEARCH]

Thank you chief 👍

[@muhatube4755]

Many thanks to give us such an excellent and brief tutorial ... when i was collecting data i use kobo tool box in amharic language then when i download and import to spss it is not defind .. so what is the solution for such problem. or would you advise me to enter the data in to spss one by one? please

[@hadizashehu5147]

Thank you sir. I will try this soon as i just collected some data with the Kobo tool box

[@SPSS4RESEARCH]

Awesome, let me know how it goes 👏

[@shibeshigetachew629]

what an easy explanation !!!! thank you dear brother!!!!

[@SPSS4RESEARCH]

Glad it was helpful 😊

[@abdushabamtonda8853]

Fantastic and superb 👏 🎉 You deserve everything worth honor 🎖. Thanks so much sir

[@SPSS4RESEARCH]

I appreciate your feedback sir👍

[@abolareagan8716]

brilliant, in fact you have simplified everything for me

[@SPSS4RESEARCH]

Great 👍

[@calebdavid7718]

Great job sir ! We are lucky to have you .

[@SPSS4RESEARCH]

So nice of you Caleb

[@abdullahiidrismuhammad6263]

Thank you very much sir

[@SPSS4RESEARCH]

You are welcome Dr

[@mahletgirma9060]

I am really thankful for your valuable information. But where can I get the syntax window?

[@SPSS4RESEARCH]

Great question. Launch your SPSS and click on file >> Open >>> Syntax. Another way is to double click on the syntax file that was generated from the kobo server. I hope this helps?

[@elogekambaletaraja5334]

Thanks for this tutorial. Unfortunately on my side the value are not updated after running the codes. How do I do?

[@SPSS4RESEARCH]

That’s strange, are you having any error messages on your end?

[@emmaaweda6919]

Thank you so much for this amazing content. You are a life and career saver and I intend to emulate you soon in terms of touching lives. While selecting export type, I picked SPSS Labels but there was no "label" in the Value and header format dropdown. All I saw were English, French and XML values and headers. What should I do about this? Thanks so much and God bless

[@leandrafernandes9243]

I have the same issue. Have you been able to figure out what needs to be done here?

[@SPSS4RESEARCH]

Happy to help!

[@olugbengaafolabi1836]

Great lecture

[@SPSS4RESEARCH]

Thank you Chief 👍

[@michaelongko564]

you are the best my bro!! keep doing great stuff!!

[@SPSS4RESEARCH]

Thank you so much Mike

[@boumboum3477]

Thank you for this video it's very interesting, just you ask you how I can make a stratified sampling draw in SPSS.

[@krunchfoodsllc3069]

Weldone ✌️

[@hemanjohnson8408]

This is great I would love to learn more

[@gersongodoy1407]

Muchas gracias el video mejor explicado que he visto, y muy bien editado. saludos.

[@SPSS4RESEARCH]

🤗

[@mubirufrank58]

Many thanks for the video , perfectly understood it . okidoki and kyyoki , !!!!

[@SPSS4RESEARCH]

You are welcome Mubiru 😃

[@nafyssah6100]

Thank you sir

[@getanehtewabe-v1t]

thanks but my doubt is what about label instate of XLS and header during downloads data

[@SPSS4RESEARCH]

👍

[@fatimasani62]

👍👍 This really fun to watch Thank you so much, it is so helpful, well explained and summarized. How i wish i can get a video from you on Latex and Matlap to help me with my Masters dissertation.

[@SPSS4RESEARCH]

Thank you Hajiya Fati. I will add it to my list of topics to cover soon, God willing.👍

[@ahmedabdulahimahamud3272]

Masha Allah, this part is more helpful for me

[@SPSS4RESEARCH]

Glad to know sir🙌

[@sundayasuke2533]

Nice, informative and straightforward.

[@SPSS4RESEARCH]

Thank you chief sir

[@mahameddol3415]

realy realy....thank you very much bro

[@SPSS4RESEARCH]

You are welcome sir Mahamed

[@onyinyelinda2003]

Thank you, sir. Looking forward to more videos.

[@SPSS4RESEARCH]

More to come! 😊

[@LawrenceOkidi]

Thank you very much for the informative video. When running the Syntax file, i encountered the error "Text value unmmappable in the current server locale". How do i adrees this?

[@SPSS4RESEARCH]

Hi Lawrence, sorry to hear that you encountered this problem. You need to simply redownload a new file from the Kobotoolbox server and this time compare the values in the syntax file with that of you SPSS data file. Make sure the variable names are the same. If they are different, it may be an issue from the server. You can manually correct the names from the syntax

[@edenkabaya2581]

Thank you very much sir really really helpful and simplified ,,I have a question Sir,,after doing the SPSS export download part,,after downloading the part I'm getting something like "the name of the project date then ZIP at the end,,then I try clicking on it ,its saying the destination is too long try ,,what can I do

[@SPSS4RESEARCH]

Great question! Change the name of the file to a shorter name and try again. Otherwise just unzip the folder to your desktop and use it from there

[@edenkabaya2581]

@@SPSS4RESEARCH thank you very much Sir 🙏🙏 problem solved

[@anthonygikuri]

You made my day. Thank you brother for sharing.

[@SPSS4RESEARCH]

You are most welcome sir Anthony 🙌

[@sulaimanidrissamorlai3497]

I didn't see labels under value and header but language when I was exporting the SPSS files

[@SPSS4RESEARCH]

You need to check under “Values and Header”

[@may-fd8jc]

@@SPSS4RESEARCH that's what we did, it only shows the language and XML values and headers

[@jonathan7620]

It's helpful indeed... Though my data has replicated having... What should I do?

[@SPSS4RESEARCH]

Hey Jonathan! I am not sure what you mean by “replicated having”. Can you clarify

[@wilsonochieng479]

Thank you so much for this. From Kenya

[@SPSS4RESEARCH]

You are most welcome sir Wilson 👍

[@healthtalk.c]

Thank you for the help. Please I have a question. After downloading the labels, the file appeared as a WinRAR ZIP archive file instead of an spss syntax file. I then went ahead and used the spss to open as such, but it appeared blank. Could you help tell me what to do? What did I do wrong?

[@SPSS4RESEARCH]

Fariha, it’s simple! All you need to do is unzip the Zipped file, you will find the SPSS syntax file inside. Click on it and it will open inside SPSS automatically. I hope this helps?

[@carolinetafadzwamaduro6412]

VERY HELPFUL TEACHING IS SURELY YOUR CALLING

[@SPSS4RESEARCH]

Thank you so much Caroline 🤗

[@adejokeakano5733]

😊Easy pizzy, 🍋 squeezy. Thank you sir

[@SPSS4RESEARCH]

You are super welcome, Adejoke🤗

[@timothyyakubu4666]

Waw! Thanks for providing this excellent guide

[@SPSS4RESEARCH]

You are most welcome, Mubiru

[@Nobalesa]

How about the mixed data? We do not code the data on Kobotoolbox, does it code itself or should it be done manually? Thanks

[@SPSS4RESEARCH]

Hi, I am not sure I fully understand what you mean by “mixed data”. But if you are referring to categorical data or even data in form of text or string, then it would be imported exactly the way it was collected. If you want to code it in SPSS, then use the automatic recode function to code it into numbers. So no need for manual coding. I hope this helps?

[@nilimashrestha7892]

This video is amazing. However, I have a quiry. When the values are imported, the multiple response values aren't imported in dichotomous form. As you can see in your video too, the value of multiple response answers are 'none'. Is there any way to import dichotomous value of multiple response answers that has been created using categorical value in kobo? Thanks!

[@PublicHealthResources]

Hi Nilima, great question. There shouldn’t be any problems importing multiple response values.Are you getting any error messages when you run the command in SPSS? if yes, kindly let me know what type of error you are having and if there are no errors then try exporting the file in CSV format from Kobotoolbox and this should do the trick. There can be some minor compatibility issues with the syntax from Kobotoolbox server and older versions of SPSS software. Let me know the version of SPSS you are using so I may suggest another workaround if the prior suggestions do not work. I hope this helps?

[@neimajemal8627]

thanks a lot first but after entering the spss files and xl file it does not give me the values it says non and how can i arrange this

[@SPSS4RESEARCH]

Great question Neima. I am not clear about your question. Have you being able to download both the data file and the syntax files? Did you run the syntax file? Please clarify so I can help you

[@Louez-l-ÉternelTV]

If you can analyze the results for the multiple choice questions, please !

[@SPSS4RESEARCH]

Okay sir, coming up soon. Please stay tuned 😊

[@adzahbismark4501]

How do you run multiple response in spss from kobocollect data?

[@SPSS4RESEARCH]

It’s easy! You get 2 types of data that come out of multiple response questions from Kobotoolbox. The first is a summarized version of the data that was entered while the second is the frequency for each of the options in the multiple response set questions. After importing to SPSS, they should be side by side. Chose whichever one suits your data analysis plan. I hope this helps?

[@badrulawal7273]

Good morning sir, I was not able to import my data with value labels on the variable view from Kobotoolbox to the SPSS. Though the values were shown in the data view. Kindly assist sir.

[@badrulawal7273]

I have done it successfully using your powerful video

[@SPSS4RESEARCH]

Nice to hear this✌️. Thank you for your feedback and don’t forget to share this resource with other folks so they can benefit 👍

[@hussainoluwatobi6362]

Thank you very sincerely for this. I am glad I saw this video. However, when I ran the SPSS label syntax, not all the labels were transferred. It indicated "Warning # 4464 in Column 3" and it further stated that "An invalid command symbol appeared on the VAR Labels command where a variable name was expected". What could have caused this sir?

[@SPSS4RESEARCH]

Glad it helped! It’s very likely that these must be a difference in the variable labels from the form and what is exported. What variable is in Column 3? Try to look at the syntax and change the name of the variable in the syntax to the same name as what is in column 3. It should do the trick. Let me know how it goes

[@sakeebkhan5762]

assalamu alaikum brother. I tried the process as you have shown, but it still isn't working for me. the value field remains void when exported to SPSS

[@SPSS4RESEARCH]

Wa alaykum salam. Oh, that is strange. Do you have any error messages?

[@sakeebkhan5762]

@@SPSS4RESEARCH no I don't have any error message. The value field remains empty even after running the code

[@EpiInfoforRookiesE4R]

@@sakeebkhan5762 I am not sure what the problem is. Can you share the data so I see what the problem is?

[@sakeebkhan5762]

@@EpiInfoforRookiesE4R how would I share the data with you

[@KONEDAOUDA-n4q]

Merci Professeur. Excellent cours

[@SPSS4RESEARCH]

Thank you so much Kone 👍

[@malakmk5746]

ممكن اعرف ازاى افتح الاستمارة عن طريق اكواد معينة يعنى مجموعة معينة فقط وانا محدد لكل واحد كود بمجرد كتبة الكود يظهر اسمه وبياناته وتفتح تفاصيل الاستمارة

[@kindualem]

Could you make a video on how we edit data on kobotoolbox?

[@SPSS4RESEARCH]

Hey Kindu, see if this video helps kzbin.info/www/bejne/kJ_NeapsiLB0isksi=z2Hf91iupoEDhG7Z

[@JamesLadu-g7u]

I really wanted to learn more about SPSS and Kobotool

[@SPSS4RESEARCH]

Alrighty Sir, will work on uploading more Kobo stuff 🤗

[@sallymoyae3203]

This was fun and informative, thank you

[@SPSS4RESEARCH]

You are welcome Sally👍

[@nattygizachew3789]

Excellent presentation!

[@SPSS4RESEARCH]

Thanks Natty👍

[@danielbriosocruz46]

Thanks a lot!, it was such a wonderful lesson.

[@SPSS4RESEARCH]

Am glad you found it useful Daniel 👍

[@galgewako6433]

what if there is no variable labels in the variable label column ? Kindly assist🙏

[@SPSS4RESEARCH]

Do you mean after you have extracted the data? Please clarify.

[@sunshinemebrat8003]

Dear Dr. Abdulhakeem, you are doing very very interesting jobs, I'm pleased with it. But I do have a little bit of doubt here Dr. In SPSS V-20, There are no labels on the value and header format. How can I correct it? Thank you, Dr. for your cooperation.

[@SPSS4RESEARCH]

Sorry to hear about the error you are having with your SPSS. Can you confirm if you were able to download 2 separate files from the Kobotoolbox server?

[@badrulawal7273]

Good afternoon, sir, I have tried importing a friend's data from kobotoolbox to spss, and I have imported the labels successfully but the values were not imported. I have tried it several times but I know I have missed out on something. Kindly guide me through the importation of Values from spss. Thank you sir.

[@SPSS4RESEARCH]

Sorry to hear about this Chief Badru, are you getting any errors during the importation of the data into SPSS? Let me know what the error message is. Sometimes there may be some compatibility issues with Kobotoolbox and older versions of SPSS. Let me have this information and we can go from there

[@anthonygikuri]

Hi again. I gave this technique another try, but it appears not all values are brought into the main SPSS file. Some variables are still recognized as strings. What else could I do?

[@SPSS4RESEARCH]

Oh no sorry to hear this, it may be that the variables themselves were collected as strings when building the Kobotoolbox form. If that’s the case, am afraid you have to transform in SPSS.

[@anthonygikuri]

@@SPSS4RESEARCH I coded the form myself using numbers to represent choices for the select_one and select_multiple.

[@mulugetanega7765]

Dear Professor, I have been looking your tutorials on Kobotoolbox and I found it very interesting. Do you have other tutorials showing how to develop a likert scale based tables in kobotoolbox. Thank you so much in advance.

[@SPSS4RESEARCH]

Yes, soon

[@dorcasgaladima5036]

Awesome lecture sir ❤

[@SPSS4RESEARCH]

Thank you Dorcas 👍

[@Nobalesa]

I have downloaded the data but it appears differently, dissimilar with yours. The file appear with TextEdit not SPSS syntax. Does it because of I have no SPSS on my laptop? Thanks

[@SPSS4RESEARCH]

Great question! You will need to have SPSS installed on your computer before you can use the SPSS syntax file. I hope this helps?

[@alehegnkasahun4574]

excellent boss, you are blessed.

[@SPSS4RESEARCH]

Thank you so much Chief 👍

[@MbilikoAnselutadeth-kl2xt]

I Did all the steps as you explain but, the v alue for labels didn't appear. What can I do?

[@SPSS4RESEARCH]

Are you getting any errors? Let me know what the error message is.

[@dogwal7822]

Hello Have tried to import from kobotoolbox to SPSS but it failed to collect the labels and values. It shows error message “TEXT VALUE UNMAPPABLE IN THE CURRENT SERVER LOCALE”. I am using WPS office package and IBM SPSS version 20. I need help

[@SPSS4RESEARCH]

Sorry to hear of your issues. Did you download and run the syntax file from the Kobotoolbox Server?

[@dogwal7822]

@@SPSS4RESEARCH Yes i did. I followed all the steps in the video

[@ibrahimbangura8237]

Thank you concise explanation

[@SPSS4RESEARCH]

Glad you found it useful 🤗

[@SPSS4RESEARCH]

You are most welcome 👍

[@monsters4266]

Is not working on my spss 21 :( why ??

[@SPSS4RESEARCH]

What’s the problem, can you tell me the error message?

[@monsters4266]

@@SPSS4RESEARCH I found that our IT department didn’t code the questions on kobo :( can you teach us how to code questions on kobo so I can use it immediately in spss

[@PublicHealthResources]

@@monsters4266 okay, I will do that in a new video, you can check out my other Kobotoolbox videos on my public health resources channel.

[@judegandus7003]

Wonderful. Great one, lovely

[@SPSS4RESEARCH]

Thank you for your feedback Jude ☺️

[@zaburonsamwel4899]

Greeting to you Sir, to me when i download spss file it download a word document instead of SPSS Syntax. how can i download a varid file?

[@SPSS4RESEARCH]

Sorry to hear about that sir. Do a right click on the file and under “open with” open it with SPSS. It should open the syntax editor. Otherwise open it with word and copy the Syntax to SPSS syntax editor. I hope this helps?

[@ramadhansheriffkadammanja9491]

Tried it ,it works but some of the data from multiple response questions goes missing