I need to aggregate the information entered in Microsoft Form

Seril, Suzzette A 0 Reputation points
2026-10-07T13:37:01.3933333+00:00

I have to aggregate the completed microsoft form questionnaire into an excel spread sheet that is auto populated that I created

Microsoft 365 and Office | Excel | Other | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Xavier-D 13,840 Reputation points Microsoft External Staff Moderator
    2026-10-08T00:41:44.68+00:00

    Hello Seril, Suzzette A,

    Could you clarify what you mean by “aggregate”?

    Are you trying to:

    • Add every new response as a separate row in your existing workbook, or
    • Combine the responses into totals, summaries, or a report?

    Also, is the workbook already formatted as an Excel table, and does each column correspond to a question in the form?

    For a custom workbook, the exact approach depends on its layout and the type of summary you want to produce. Please share a sample of the desired output without including any personal or sensitive information.

    I hope to hear update from you soon.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-10-07T13:37:18.31+00:00

    Yes. The supported way is to connect Microsoft Forms to an Excel workbook and then have each new response added automatically.

    A simple end-to-end setup:

    1. Create or open the Excel workbook that will store the responses.
      • Store it in OneDrive or SharePoint.
      • Create a table in the worksheet for the response data.
    2. In Microsoft Forms, use the form that collects the questionnaire responses.
      • Forms responses can be viewed and exported to Excel.
      • An Excel workbook with response data is stored in OneDrive or SharePoint Online, depending on where the form started.
    3. In Power Automate, create an automated flow:
      • Select Create.
      • Choose Automated cloud Flow.
      • Set the trigger to Microsoft Forms – When a new response is submitted.
    4. Add the Forms action to read the submitted answers:
      • Add Microsoft Forms – Get response details.
      • Select the same form.
      • In Response Id, choose Response Id from dynamic content.
    5. Add the Excel action to write the response into the spreadsheet:
      • Add Excel Online (Business) – Add a row into a table.
      • Choose the workbook location in OneDrive or SharePoint.
      • Select the file and the table.
      • Map each form question to the matching Excel column.
    6. Save the flow and submit a test response.
      • Expected result: each new Microsoft Forms submission is added as a new row in the Excel table automatically.

    If the goal is to calculate totals or aggregate values after the responses arrive in Excel, add Excel formulas in extra columns. For example, Excel can calculate totals from numeric response columns, and functions such as AGGREGATE can summarize data while ignoring errors.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.