How to enter survey data into Excel from a pen-and-paper questionnaire

I show my technique of entering raw data into Microsoft Excel that has been collected via a pen-and-paper survey. This includes both questions with fixed responses and open-ended questions.
Copyright: Text and video © Kent Löfgren, Sweden.

[carolethomas]

Dear Kent! I can't tell you how delighted I have been today after looking at this video 'entering questionnaire onto a spreadsheet'! I arrived for my regular volunteer session today and the manager asked me if I would be able to put data from a questionnaire onto a spreadsheet - I said 'I'm not sure - I've not done it before but I'll give it a go - I'll look on youtube!'. I found this video; which has been quite perfect! very clear, very well paced and exactly what I needed to know to do the task! It's has given such a sense of achievement and satisfaction at the end of my session to have created the spreadsheet and entered the first of many batches of questionnaires. The ability of the organisation to be able to use the results of this survey are critical in achieving an important objective next year. I just wanted to say 'thank you!'.

[Ylana_Figueiredo]

I really like your method of coding the questionnaire. It is very clear and concise.Thank you for sharing your method!

[brrrrrrrrino]

I love that the cat kept bugging him lol

[waasnoode]

Thank you so much!! I've been searching for three days for a solution that I can understand! Plus, I love the kitty :D

[londiwenomusatsosane]

Well understood... Thank u and ur calmness makes it easy to follow ur work

[patriciakelly]

Brilliant, concise, thank you so much.

[superj]

Thank you for both the new knowledge and smile! Your assistant is very insistent, love it!

[mohameddahiryusuf]

Absolutely...very helpful and clear to understand. Thanks a lot

[zeenasamson]

i do not know why i did not do this in school. but this is very informative and straigh to the point. working on my first ever survey!!!! i am now going to be your biggest fan.

[skywechsler]

Thank you very much for this video! It explains everything I need to know! This video is so peacful and easy to understand and really funny because of your cat. <3

[livingtherufflife]

Great, thank you so much. Easy to follow, I'm going to your next video!

[kaysoebenesh]

thank you for sharing this. You do a better job than my research method teacher .

[trimandprim]

Really helpful. Cat is super adorable. Many thanks for your videos sir.

[DesmondL]

This video is so relaxing to watch! It's very therapeutic.

[XGamerXavier]

This was very simple, helpful, and well explained. Thank you. I dropped a like on your video.

[anagabrielleserratos-gonza]

Thanks for helping me with my research! :) Great job and cute cat!

[appiahfantastic]

thanks very much KENT....I REALLY ENJOYED IT

[daniellet]

Very helpful and clear! Thank you. Also, your cat is awesome (:

[lizl.]

thanks! After 8 years you're still finding an ignorant person like me

[mich_n_mikii]

I love how you work around your kitty！！ and nice video!