Importing bulk answer choices for a question.

%3CLINGO-SUB%20id%3D%22lingo-sub-178625%22%20slang%3D%22en-US%22%3EImporting%20bulk%20answer%20choices%20for%20a%20question.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178625%22%20slang%3D%22en-US%22%3E%3CP%3EG'day%20forms%20community!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20recently%20moved%20over%20from%20Google%20to%20O365%20and%20having%20a%20few%20dramas%20with%20MS%20Forms.%20With%26nbsp%3BGoogle%20Forms%2C%20we%20often%20had%20multiple%20choice%20questions%20with%20an%20answer%20list%20in%20excess%20of%20100%2B%20choices.%20It%20was%20easy%20to%20add%20these%20to%20a%20question%20as%20all%20you%20had%20to%20do%20was%20copy%20the%20list%20of%20answers%20from%20a%20column%20in%20a%20spreadsheet%20and%20then%20paste%20it%20as%20the%20first%20option%20of%20a%20multiple%20choice%20question.%20Google%20then%20simply%20created%20all%20your%20separate%20choices%20for%20you%20and%20job%20done.%20Saved%20us%20hours%20of%20work%20in%20setting%20up%20the%20forms%20and%20also%20mitigated%20the%20risk%20of%20input%20errors.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can't%20seem%20to%20find%20an%20option%20for%20MS%20forms%20to%20do%20the%20same%20is%20there%20one%3F%20Or%20do%20I%20really%20have%20to%20created%20100%2B%20options%20manually%3F%3CBR%20%2F%3E%3CBR%20%2F%3EVery%20many%20thanks%20for%20your%20assistance%20on%20this!%3CBR%20%2F%3E%3CBR%20%2F%3EDave%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-178625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242095%22%20slang%3D%22en-US%22%3ERE%3A%20Importing%20bulk%20answer%20choices%20for%20a%20question.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242095%22%20slang%3D%22en-US%22%3EI'm%20encountering%20the%20same%20requirement.%20Did%20anybody%20find%20out%20how%20to%20do%20it%20(w%2Fo%20manually%20typing%20all%20options)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-207483%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20bulk%20answer%20choices%20for%20a%20question.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207483%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20David%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20built%20my%20first%20MS%20forms%20form%20today%2C%20and%20was%20wondering%20the%20same%20thing%20as%20you%20as%20I%20have%20a%20large%20list%20of%20option%20to%20add%20to%20a%20question.%20Did%20you%20figure%20it%20out.%20Likewise%20Ill%20post%20here%20if%20I%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

G'day forms community!

 

I've recently moved over from Google to O365 and having a few dramas with MS Forms. With Google Forms, we often had multiple choice questions with an answer list in excess of 100+ choices. It was easy to add these to a question as all you had to do was copy the list of answers from a column in a spreadsheet and then paste it as the first option of a multiple choice question. Google then simply created all your separate choices for you and job done. Saved us hours of work in setting up the forms and also mitigated the risk of input errors.

I can't seem to find an option for MS forms to do the same is there one? Or do I really have to created 100+ options manually?

Very many thanks for your assistance on this!

Dave

3 Replies

Hi David,

 

I just built my first MS forms form today, and was wondering the same thing as you as I have a large list of option to add to a question. Did you figure it out. Likewise Ill post here if I figure it out.

 

Thanks

Matt

I'm encountering the same requirement. Did anybody find out how to do it (w/o manually typing all options)?

FYI if anyone stumbles across this old thread - if you copy and paste a column of options (I did from Notepad) into the first option's answer box then it'll add a choice per row.