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
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.

4 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! :)