Forum Discussion

nandofloresb's avatar
nandofloresb
Copper Contributor
Mar 10, 2020

Import data from excel into microsoft forms

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.

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    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

    • writerMaiaL's avatar
      writerMaiaL
      Copper Contributor
      The vote link isn't working.

      Is this now feature available?
  • Gotrad's avatar
    Gotrad
    Copper Contributor

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

    • Wolfgang13's avatar
      Wolfgang13
      Copper Contributor

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

      • Overlode's avatar
        Overlode
        Copper Contributor

        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! 🙂 

  • abbier07's avatar
    abbier07
    Copper Contributor

    nandofloresb Gotrad Overlode 

     

    I've been battling this and couldn't figure out why it worked once but wouldn't a second time.

     

    As the others mentioned, you add a new 'choice' and then copy and paste from excel into the first option field.

     

    The trick is to make sure the data you are copying from (in excel) is a vertical list (ie columns) NOT a horizontal list (ie rows).

     

    You still have to do it one item at a time (which is annoying) but cut and paste does work like this.

Resources