Others

How to Combine Responses from Two Microsoft Forms into One Link

Huda Qurayshi Oct 8, 2026 870 views

Question details

The user wants to merge response data from two identical Microsoft Forms into a single presentation or summary link.

How to Combine Responses from Two Microsoft Forms into One Link

Product: Microsoft Forms
Device & OS: not provided
Scenario: Collecting data via two separate but identical forms and needing a centralized location to view all consolidated responses.
Observed behavior: Microsoft Forms does not natively support merging response data from two different forms into one summary link; data remains strictly separated by default.

Before you start

Ensure you have access to Microsoft Power Automate with your Microsoft 365 account and have a blank Excel Online workbook or SharePoint list ready to receive the merged data.

Solution 1Recommended

Consolidate Responses using Power Automate and Excel Online

Create an automated workflow that pushes new submissions from both forms into a single, shared Excel table.

Microsoft Forms lacks a native 'merge' button, but you can build a bridge using Power Automate. By setting up a trigger for both forms, every new submission is automatically written into a master Excel file, which can then be shared via a single link.

Prepare an Excel table

Open Excel Online, create a new workbook, insert a Table with headers matching your form questions, and save it to OneDrive or SharePoint.

Create a new automated flow

Go to Power Automate, click 'Create' in the left menu, and select 'Automated cloud flow'.

Set up the first trigger

Choose the 'When a new response is submitted' trigger for Microsoft Forms and select your first form from the dropdown list.

Fetch response details

Add the 'Get response details' action, linking it to your first form and the corresponding Response ID.

Add data to Excel

Add the 'Add a row into a table' action for Excel Online. Select your prepared Excel file and map the form responses to the appropriate table columns.

Repeat for the second form

Create a second automated flow (or a parallel branch in an advanced flow) using the exact same steps for your second Microsoft Form, pointing it to the same Excel table.

Share the consolidated link

Open your master Excel file in OneDrive or SharePoint and generate a shareable link to provide a single view of all merged responses.

Consolidate Responses using Power Automate and Excel Online

Shared Data Integrity: Make sure the column headers in your Excel table exactly match the questions from both forms to prevent data misalignment.

Solution 2

Manually Export and Merge Form Responses in Excel

If you do not have access to Power Automate, you can periodically download the results and combine them manually into a single file.

Free Microsoft Office alternative

Merge and Analyze Exported Form Data Free with WPS Office

If you need to manually consolidate exported Microsoft Forms data or want a powerful, lightweight suite to handle large spreadsheets without a Microsoft 365 subscription, WPS Office is the perfect solution. It offers robust data tools and full compatibility with Microsoft Excel formats.

1. Open exported data in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet module, and load your downloaded Microsoft Forms Excel files.
2. Combine worksheets: Use the copy-paste function or the built-in 'Merge Workbooks' tool to consolidate the form data into a single sheet.
3. Analyze and share: Create charts or PivotTables to analyze the combined data, then save and share the file with your team.

Fully compatible with Microsoft Excel (.xlsx) formats and CSV files.Free and lightweight alternative to Microsoft 365 for data consolidation.Advanced data manipulation and formatting tools within WPS Spreadsheet.Familiar tabbed user interface for a seamless workflow migration.

microsoft office alternative - wps office

Frequently Asked Questions

Can I directly link two Microsoft Forms together without external tools?

No, Microsoft Forms does not currently have a built-in feature to merge or link two separate forms natively. You must use Power Automate to sync them or manually combine the exported Excel data.

Will merging forms via Power Automate update existing responses?

Power Automate triggers only apply to new responses submitted after the flow is turned on. To include past responses, you will need to manually export them and copy them into your master Excel table.

Can I combine Microsoft Forms into a SharePoint list instead of Excel?

Yes. In Power Automate, you can use the 'Create item' action for SharePoint instead of the Excel action to push responses from multiple forms into a single centralized SharePoint list.

What happens if the two forms have different questions?

If the forms have different questions, your centralized Excel table or SharePoint list will need distinct columns for all unique questions. Fields that don't apply to a specific form will simply remain blank for those submissions.

Office Quick Solutions