Forum Discussion

Copper Contributor

May 22, 2018

Copy and past to Microsoft Form multiple question answers

I was wondering if there was a way to quickly copy and past a list possible answers to a Microsoft Forms multiple choice question. I will often have an Excel list of 50 possible answers in a column....

microsoft forms

AngelFeng

Copper Contributor

Apr 27, 2021

Kyle Koenig

While there is no specific option to duplicate, you can use this hack:

Type the list of your responses that you'd like to duplicate, one response choice per line into Notepad (or Excel). Select all, copy and paste into the first response choice box of your question, and it should automatically populate the entire list into separate response choices!

ChrismaT

Copper Contributor

Aug 11, 2021

I tried this and it pasted all off the options in the first row.

Will_Thalheimer
Copper Contributor
Jan 19, 2022
ChrismaT

I just copy and pasted a list from word into the first option and it populated them into separate answer choices. There were carriage returns between my options. Here's a picture from MS Word.
- BernardSoh
  Copper Contributor
  Mar 09, 2022
  Strangely, I tried the same and it doesn't work. These are my options
  But when I paste them into Form, only the first option will appear.
  
  I was even thinking there wasn't enough options so I added a few more. Nope.