How can I turn this into an online questionnaire or survey?

January 13, 2014 10:39 AM

I have an excel spreadsheet with a list of songs used by a church. I want to distribute the list online an ask people to indicate whether they like or dislike a song or whether it is unfamiliar. It seems like this should be easy to do, but I can't figure it out.

The online survey makers I have looked at make you set it up question by question. I want to upload the list of songs and have it display all on one page. Ideally, there would be checkboxes next to each song: "Like, Neutral, Dislike, Unfamiliar." I've looked at Google Docs, Survey Monkey, and Excel Apps. Any help is appreciated.

posted by imposster to Computers & Internet (9 answers total)

That's easy enough to do in SurveyMonkey. Create a question with a matrix of choices, one answer per row, or multiple answers per row. That should do it for you.
posted by xingcat at 10:42 AM on January 13, 2014

You can do this with Google Docs/Drive: Use Google Forms to create a survey

That article discusses a Chrome extension but I don't think it's strictly necessary - you can just go to Drive and create a from which you can then mail to people. Results go into a spreadsheet in Google Drive which you can easily export to Excel.
posted by GuyZero at 10:45 AM on January 13, 2014 [2 favorites]

Response by poster: In both of those cases, I believe that you have to type in each question individually. I have 200 songs and would prefer just uploading them all, rather than typing them out. (Maybe that isn't possible.)
posted by imposster at 10:53 AM on January 13, 2014

Best answer: Google Forms is brilliant for this, as GuyZero says.

I have always done it from within Drive.

From digging around in the Create Form area, it looks like you can make a question in a "grid" format, which might be more what you want than a multiple choice format.

You could always structure it as a checklist with "Which of the following songs do you enjoy hearing at church services?", "Which of the following are you unfamiliar with", etc.
posted by Sara C. at 10:55 AM on January 13, 2014

Response by poster: Here is a sample of who I imagine the survey looking. I'll look into the grid format.
posted by imposster at 10:59 AM on January 13, 2014

In both of those cases, I believe that you have to type in each question individually. I have 200 songs and would prefer just uploading them all, rather than typing them out. (Maybe that isn't possible.)

You could probably pay someone on Mechanical Turk to do this for pretty cheap...
posted by showbiz_liz at 11:15 AM on January 13, 2014

Best answer: I just went into Google Forms, created a question, and changed the Question Type to "Grid".

Then I went to a spreadsheet I had created with 10 rows of data, selected those 10 rows and hit "Copy"

Then I went back into the Form, put my cursor in "Row 1", and hit paste -- the 10 rows populated as 10 rows in the survey.

You should be able to do that in one fell swoop for all 200 songs, no problem.
posted by brainmouse at 11:20 AM on January 13, 2014 [1 favorite]

Best answer: Just copy all the rows into something like Notepad, then paste that raw text into the Question format.

I did just that in my surveymonkey, and it took me three seconds to get this
posted by xingcat at 11:20 AM on January 13, 2014 [1 favorite]

Response by poster: Yes! That does it. Thanks everyone.
posted by imposster at 11:33 AM on January 13, 2014