Forum Discussion

jetimmer's avatar
jetimmer
Icon for Microsoft rankMicrosoft
Jul 11, 2019

Is it possiable to automate exporting form results

Is there a way to either export or query form results using some form of automation?

 

Thanks,

Jeffrey J. Timmerman

Site Reliability Engineer

Microsoft

microsoft forms
Quiz
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Jul 12, 2019

    Hi jetimmer 

     

    If your form is a Group form then there should be an Excel file in SharePoint under the Documents library.

     

    If the Excel file isn't there, try opening your results in Microsoft Forms and then try again.

     

    Could be automated using MS Flow from there as an example.

     

    Hope that makes sense?

     

    Cheers

    Damien

    • Daniel2019's avatar
      Daniel2019
      Copper Contributor
      Nov 29, 2019

      Damien_Rosario  Hi Damien, I would have to have an export in a .csv file and not an .xlsx file. Is there any way to do that?

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Nov 29, 2019

        Daniel2019  you could just export it as an excel file then in Excel save as a csv.

        Rob
        Los Gallardos

         

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jul 14, 2019

    Hi jetimmer, if you don't want to use the built-in excel spreadsheet of results in Forms, you can use Flow to send each response to a new row in a spreadsheet. Make sure you've formatted your spreadsheet as a table, and then the flow is quite simple as shown in the image below.

    Rob
    Los Gallardos

     

Resources