Others

How to Share Microsoft Forms Externally and Automate Excel Responses

Natalie Taylor Oct 21, 2026 868 views

Question details

The user needs to share Microsoft Forms with external respondents and automatically compile the submissions from multiple forms into distinct worksheets within a single Excel workbook.

How to Share Microsoft Forms Externally and Automate Excel Responses

Product: Microsoft Forms and Microsoft Excel
Device & OS: not provided
Scenario: Collecting external survey or form responses and centralizing the data management.
Observed behavior: Microsoft Forms allows external sharing, but lacks a native feature to automatically combine responses from different forms into multiple worksheets of the same Excel file.

Before you start

Ensure you have the necessary permissions to modify the Microsoft Form's sharing settings and an active Microsoft Power Automate account to configure data routing flows.

Solution 1Recommended

Enable External Sharing and Route Data via Power Automate

Since Microsoft Forms does not natively merge multiple forms into a single Excel workbook, you can configure external sharing and set up a Power Automate flow to route incoming responses to specific worksheets automatically.

Microsoft Forms allows anyone with the link to respond, provided organizational settings permit it. To handle the data collection efficiently, Power Automate can be used to capture each form submission and write it into a designated Excel worksheet.

Change Sharing Settings

Open your form in Microsoft Forms, click the 'Collect responses' or 'Share' button in the top right corner, and change the permission setting to 'Anyone can respond' to allow external submissions.

Prepare the Master Excel File

Create a master Excel file on OneDrive or SharePoint. Add separate worksheets for each form you plan to use, and format the target ranges as Excel Tables (Insert > Table).

Create a New Flow

Open Microsoft Power Automate and create a new Automated cloud flow. Select the 'When a new response is submitted' trigger for Microsoft Forms and select your form.

Add Excel Action

Add the 'Get response details' action to retrieve the form data. Next, add the 'Add a row into a table' action from the Excel Online connector, select your master Excel file, choose the correct worksheet table, and map your form fields to the table columns.

Enable External Sharing and Route Data via Power Automate

Feature Limitation: Microsoft currently has no built-in way to combine multiple forms into one Excel file automatically without Power Automate. Users are encouraged to vote for this feature on the official Microsoft Feedback Portal.

Free Microsoft Office alternative

Manage and Analyze Form Data with WPS Office

While setting up complex automations requires expensive Microsoft subscriptions, WPS Office provides a free, lightweight, and highly compatible alternative for organizing, analyzing, and presenting your collected form data.

1. Download WPS Office: Download and install the free WPS Office suite from the official website.
2. Open Your Data File: Launch WPS Spreadsheet and open your exported Microsoft Forms Excel data file.
3. Analyze Responses: Use built-in pivot tables, charts, and filtering tools to organize and analyze your external responses efficiently.

100% compatible with Microsoft Excel (.xlsx) formatsLightweight suite combining Word, Excel, PowerPoint, and PDFBuilt-in data analysis and visualization tools for survey resultsSeamless transition with a familiar and intuitive user interface

Frequently Asked Questions

Can I natively combine multiple Microsoft Forms into a single Excel sheet?

No, Microsoft Forms does not have a built-in feature to automatically route responses from different forms into multiple worksheets of the same Excel workbook. You must use a workaround like Microsoft Power Automate to achieve this.

Why can't external users access my Microsoft Form?

By default, forms may be restricted to people within your organization. To fix this, click on 'Collect responses' or 'Share' and change the permission dropdown to 'Anyone can respond'.

Where can I request new features for Microsoft Forms?

You can submit feedback and vote on feature requests, such as merging form responses natively, through the official Microsoft Feedback Portal or the Forms Feedback Community.

Do I need a premium license to use Power Automate for Forms to Excel?

Basic triggers for Microsoft Forms and Excel Online (Business or OneDrive) are included in most standard Microsoft 365 business and enterprise licenses. However, you should check your specific subscription plan for flow run limits.

Office Quick Solutions