Forum Discussion
Importing bulk answer choices for a question.
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
8 Replies
I didn't expect that Google Forms could automatically create multiple options by copying multiple choices into the first option—it's really amazing. Microsoft Forms' auto-import feature is super convenient. You can format your document in advance, and then use "Quick Import" to automatically build the form. If you encounter any issues with document formatting, you can search for "formlinker word to form," which can convert any format into Microsoft Forms. Hope this helps!
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.
- I'm encountering the same requirement. Did anybody find out how to do it (w/o manually typing all options)?
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
