provide the ability to copy and paste a pre-existing list into a drop-down list
I would like the ability to copy and paste a list from Excel or Word and provide it as the selections to choose from in a drop-down list.
Chris Campbell commented
Using a table(s) from excel would be a good way of adding lists to forms, this way you could upload an excel file with multiple tables to create lists for options, eg site names, locations, or any other pre determined selections.
Can you not make it so you can see exported file, add columns or data to sheet to edit form, very slow process otherwise
Ben Paddick commented
Please add a function to paste data from Excel into the "Choice" field as a list for Pro version of Forms.
It works perfectly in non pro which seems silly as we will pay for pro.
Yes this is very frustrated.
Want to add a simple dropdown for user to select his country....... takes forever as i need to copy paste each country name one by one to each potential answer.
Just let us copy paste an excel list and take every item as a separate option please.
Ryan Spooner commented
This. Adding a big list of company site names to drop down lists is a royal pain in the derriere. Either let me paste in a precompiled list, or let me use a data source. Thanks.
p.s. While you're at it, please let respondents start typing to jump to that entry, and also make the drop downs an actual dropdown on mobile view, not a big flat list they have to scroll down.
Surely it would be better to pull in the drop down list from the source data? That way if you change the master list it would update all MS forms using that list automatically.
Gary Allman commented
A drop-down list, or select from list question type is fundamental to many form designs, I can't see this option anywhere - am I missing something? This is a no brainer, and we'll be sticking with Google Forms until this is available.
I have the same list of 80 trainers to be used in 4 separate form. the possibility to manage drop-down from an existing list is vital to use forms in the correct way.
I've been a Gsuite user for a couple of years and I'm struggling to migrate even the simplest form into Microsoft form
I would like to create a drop-down from a list of exisiting options (list of trainers or students). Add them from a spreadsheet (as in Excel validation) and possibility to sort them (e.g. alphabetical orders)
Google forms lets you do this. Very frustration that this is not a function yet.