Microsoft Office

How To Connect Microsoft Forms To Excel

To connect Microsoft Forms to Excel, open your form, view its responses and select Open results in Excel. With a supported work or school account, this opens a linked workbook in OneDrive or SharePoint. Keep using that cloud workbook for new responses; a downloaded copy.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.

Choose the right way to get responses into Excel

For an ongoing survey, registration form or classroom questionnaire, start with the built-in Excel connection. It gives you a response workbook without building an automation. The instructions below use Excel for the web so you can check the connection in your browser.

If you only need results for a finished survey, downloading a copy is sufficient. If you need to populate a particular reporting table, use the Power Automate method later in this guide. These approaches serve different purposes, so decide where your results should live before sharing the form.

Prepare your form and response settings

For the cloud connection described here, sign in with your Microsoft 365 work or school account and check that you can access Forms, Excel for the web and your organisation's OneDrive or SharePoint. Personal Microsoft accounts can use Forms, but available Excel options can differ.

  1. Open Microsoft Forms and select an existing form, or choose New Form.
  2. Give a new form a clear title and add the questions you need. Choice questions help keep categories consistent; text questions let respondents explain their answers.
  3. Use Preview to check the questions and submit a test response. Confirm that required questions and answer choices work as intended.
  4. Select Collect responses and choose who can answer before copying the response link.

Microsoft's form creation instructions explain the question types and preview controls.

For a work or school form, check whether responses should come from anyone with the link, everyone in your organisation or specific colleagues. Where available, Record name and One response per person provide additional controls for internal forms. You can also set a start and end date in Settings. These options depend on your account and chosen audience; see Microsoft's guidance on who can fill out a form.

Open the linked Excel workbook

  1. Open the form whose responses you want to analyse.
  2. Select View responses to reach the response overview.
  3. Choose Open results in Excel. The workbook opens in Excel for the web.
  4. Check that your test submission appears and that each answer matches the correct question column.

For work or school accounts, an individually owned form's workbook is stored in OneDrive for work or school; a group form's workbook is stored in SharePoint. The linked workbook receives new response data. Choosing Download a copy instead creates an offline file without a connection to the form. Microsoft documents this distinction in its guide to checking form results in Excel.

The built-in route opens the workbook associated with the form. To send answers to an unrelated existing workbook, set up a flow rather than looking for a general workbook-selection dialogue.

Check that new responses reach the workbook

Submit another clearly labelled test response through the form's response link. Return to Forms and open the results workbook again. Look for the new submission before relying on the connection for reporting.

Keep using the workbook opened from Forms. A local download or separately saved copy should not be treated as the live destination. Microsoft's explanation of Forms and Excel workbooks describes opening or reopening the associated cloud workbook to see the latest responses.

Send responses to an existing workbook with Power Automate

Use this method when your team already has a workbook with a defined table. Check that your account includes access to Power Automate and the required connectors.

  1. Save the destination workbook in OneDrive for Business or SharePoint. Add column headings for the answers you want to capture and format the destination range as an Excel table.
  2. In Power Automate, create an automated cloud flow with the Microsoft Forms trigger When a new response is submitted. Select your form.
  3. Add Get response details. Select the same form and use the trigger's Response Id.
  4. Add the Excel Online (Business) action Add a row into a table. Choose the workbook and destination table.
  5. Map each answer from Get response details to its matching table column.
  6. Save the flow, submit a new test response and inspect both the flow's run history and the resulting Excel row.

This trigger handles new submissions; plan separately for any earlier responses you need to import. Avoid having both a flow and the built-in connection write the same submissions into one destination table. Microsoft provides a Forms-to-Excel workflow guide with setup and troubleshooting details.

Analyse responses and resolve access problems

Once your test succeeds, filter answers by category, use conditional formatting to highlight results and build PivotTables or charts for your report. For example, summarise registration choices by session or compare survey ratings across departments. Keep substantial cleaning and reporting work in a separate analysis workbook so the incoming response data remains easy to check.

If rows are missing, first confirm that the submission appears in Forms. Then check that you opened the linked cloud workbook under the correct account. The form owner and internal users with workbook editing permissions can trigger updates; external users cannot. If Forms displays a disconnected Excel connection, follow the workbook's prompts to reconnect.

For a separate desktop Excel activation problem, consult the guide to activating Microsoft Office using Command Prompt. If you need to check existing licence details, see finding an Office product key using Command Prompt. Further application guidance is available in the Microsoft Office guides.

Before distributing your form, submit one final test and confirm that its answers arrive in the intended workbook columns.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post