Can I import a list of names into forms , so that a person filing out a form can select a name from that list ? Any refernce link to assist ?

Scuba19 Hi, this is possible. In your form, select 'Choice' then copy your list from Excel and paste into the first box that appears on the form. It will enter each option separately.

I have a survey set up in forms that I intend to use to contact around 30,000 vulnerable customers during COVID lock down. Currently we're having to cut and paste data from Excel individually into forms for each survey. Is there a way to pull that data automatically so groups set up in teams can just open a form pre populated and complete a survey with the next customer data pulling through once completed ?

Steven_Nichol can we use PowerApp to fill in that data in the back end?

No import data functions available at this time. The best you can do is copy and paste into the field on creation.

YDynamics - the copy paste function works beautifully with Microsoft Forms, but not with Forms Pro at the moment. Hopefully something that will be added in the future.

Importing Data (a list) into Forms | Microsoft Community Hub

12 Replies

ryan12
Brass Contributor
Feb 02, 2025
I achieved this automatically through the "Quick Import" feature. If you need to format the file, try searching for "formlinker word to form." I use it to format my original data so I can successfully import the file into Microsoft Forms. It completely supports batch importing multiple options.
YDynamics
Copper Contributor
Sep 17, 2019
Scuba19 Hi, this is possible. In your form, select 'Choice' then copy your list from Excel and paste into the first box that appears on the form. It will enter each option separately.
- mmulawa
  Copper Contributor
  Apr 04, 2023
  works with plain text as well
- Erik_Deahl
  Copper Contributor
  Sep 02, 2022
  Awesome Advice. This worked perfectly. Thanks for sharing. YDynamics
- Megan_V_Walker
  Iron Contributor
  Sep 18, 2019
  YDynamics - the copy paste function works beautifully with Microsoft Forms, but not with Forms Pro at the moment. Hopefully something that will be added in the future.
  - danwebman
    Copper Contributor
    Mar 05, 2020
    Megan_V_Walker It's been a while since you posted. This now kinda works. I ended up with a massive list in option one but then it broke it down into individual options. Then I just needed to delete the option one with it all in.
ChrisWebbTech
MVP
Dec 07, 2018
No import data functions available at this time. The best you can do is copy and paste into the field on creation.

Forum Discussion

Importing Data (a list) into Forms

12 Replies

Resources