Import data from excel into microsoft forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1220821%22%20slang%3D%22en-US%22%3EImport%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220821%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wondering%20if%20there%20is%20a%20way%20to%20upload%20an%20excel%20doc%2C%20into%20ms%20forms%2C%20and%20import%20thata%20data%20to%20ms%20forms%20database%3F%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20there%20is%20a%20way%20to%20fill%20the%20questions%20in%20an%20ms%20form%2C%20with%20data%20in%20an%20excel%20spreadsheet%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1220821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20import%20to%20microsoft%20forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1220900%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220900%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578721%22%20target%3D%22_blank%22%3E%40nandofloresb%3C%2FA%3E%26nbsp%3Bthis%20is%20not%20possible%20yet%2C%20but%20there%20is%20a%20UserVoice%20request%20for%20it%20that%20you%20can%20vote%20for%20%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F33985432-add-the-feature-that-can-import-contents-of-questi%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1357553%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578721%22%20target%3D%22_blank%22%3E%40nandofloresb%3C%2FA%3E%26nbsp%3BIt%20looks%20like%20you%20can%20copy%20from%20Excel%20straight%20into%20the%20options%20and%20it%20automatically%20splits%20them%20out.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2050322%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2050322%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F646675%22%20target%3D%22_blank%22%3E%40Gotrad%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EJust%20tried%20selecting%20and%20copying%20multiple%20options%20stored%20in%20seperate%20XLS%20cells%20and%20then%20pasting%20them%20into%20the%20options%20of%20a%20question%20within%20Forms%20-%20this%20did%20not%20work%20as%20expected%3A%3CBR%20%2F%3EThe%20content%20of%20all%205%20cells%20was%20pasted%20into%20a%20single%20option.%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2484987%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2484987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F925351%22%20target%3D%22_blank%22%3E%40Wolfgang13%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20works%20for%20me%20if%20I%20add%20a%20new%20choice%20node%2C%20click%20into%20it%2C%20and%20press%20paste!%20Though%20it%20didn't%20work%20the%20first%20time%20I%20tried.%20It%20also%20worked%20when%20I%20entered%20something%20in%20the%20option%2C%20selected%20all%20text%20inside%2C%20and%20then%20pressed%20paste.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20apparently%2C%20it%20does%20work%20-%20whether%20intended%20or%20not!%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2778668%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20data%20from%20excel%20into%20microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2778668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1087979%22%20target%3D%22_blank%22%3E%40Overlode%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F925351%22%20target%3D%22_blank%22%3E%40Wolfgang13%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20had%20the%20same%20problem%20to%20paste%2080%20items%20into%20a%20selection%20list%20in%20Forms%20and%20discovered%20it%20doesn't%20work%20in%20Forms(Teams)%20but%20is%20does%20work%20in%20Forms(Office365).%20If%20you%20create%20the%20form%20in%20a%20Teams%20channel%2C%20you%20will%20find%20it%20also%20in%20%3CA%20href%3D%22https%3A%2F%2Fwww.office.com%2Flaunch%2Fforms%3Fauth%3D2%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EOffice365%3C%2FA%3E%20if%20you%20select%20the%20Forms%20app.%20So%2C%20create%20your%20desired%20form%20in%20Teams%20and%20design%20your%20form%20in%20O365.%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I was wondering if there is a way to upload an excel doc, into ms forms, and import thata data to ms forms database?

Please let me know if there is a way to fill the questions in an ms form, with data in an excel spreadsheet?

Thanks.

6 Replies

@nandofloresb this is not possible yet, but there is a UserVoice request for it that you can vote for here.

 

Rob
Los Gallardos

Microsoft Power Automate Community Super User

@nandofloresb It looks like you can copy from Excel straight into the options and it automatically splits them out. 

@Gotrad 
Just tried selecting and copying multiple options stored in seperate XLS cells and then pasting them into the options of a question within Forms - this did not work as expected:
The content of all 5 cells was pasted into a single option. :(

@Wolfgang13 

 

It works for me if I add a new choice node, click into it, and press paste! Though it didn't work the first time I tried. It also worked when I entered something in the option, selected all text inside, and then pressed paste. 

 

so apparently, it does work - whether intended or not! :) 

@Overlode @Wolfgang13 

I had the same problem to paste 80 items into a selection list in Forms and discovered it doesn't work in Forms(Teams) but is does work in Forms(Office365). If you create the form in a Teams channel, you will find it also in Office365 if you select the Forms app. So, create your desired form in Teams and design your form in O365. 

Good luck! 

 

The vote link isn't working.

Is this now feature available?