Handling Surveymonkey results?
Does anyone have any tips on how to handle Surveymonkey survey results?
I recently performed an online survey through Surveymonkey, and the results were sent to me as Excel files. They are atrocious. Some of my questions were open-ended written answers, and some of them had six or seven categories to choose from, and because of the way that Surveymonkey formatted these Excel files, they are just really unwieldy, hard to read, and hard to manage. Does anyone have some fast ways of getting the results out of the Excel files into something like a usable, codable format, or am I going to have to do a bunch of cutting and pasting and hoping that I don't skip columns and record things incorrectly?
Thanks for any help!
I recently performed an online survey through Surveymonkey, and the results were sent to me as Excel files. They are atrocious. Some of my questions were open-ended written answers, and some of them had six or seven categories to choose from, and because of the way that Surveymonkey formatted these Excel files, they are just really unwieldy, hard to read, and hard to manage. Does anyone have some fast ways of getting the results out of the Excel files into something like a usable, codable format, or am I going to have to do a bunch of cutting and pasting and hoping that I don't skip columns and record things incorrectly?
Thanks for any help!