Combine Responses from Multiple Microsoft Forms in One Excel Worksheet
Question details
The user wants to automatically merge survey or quiz responses gathered from multiple Microsoft Forms into a single Excel worksheet.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Managing and consolidating data collected from several different Microsoft Forms.
- Observed behavior
- Microsoft Forms natively stores each form's responses in its own isolated Excel worksheet without a built-in function to automatically merge them.
Ensure you have exported the individual responses from all relevant Microsoft Forms to Excel workbooks and saved them in an accessible folder.
Manually Combine Data in Excel
Since automated merging is not supported natively in Microsoft Forms, you must manually copy data from each form's exported Excel file into a master worksheet.
Currently, Microsoft Forms does not feature an automatic way to route responses from multiple forms into a single worksheet. Furthermore, any combined worksheet you create will not update automatically when new responses are submitted.
Open the Microsoft Forms dashboard, navigate to the 'Responses' tab for your first form, and click 'Open in Excel' to download the data. Repeat this step for all forms.
Open a new, blank Excel workbook. This will serve as your unified database for all form responses.
Open each downloaded form workbook. Highlight the response rows (excluding the header row after the first form), right-click to copy, and paste them sequentially into your master workbook.

Easily Manage and Combine Spreadsheets with WPS Office
While Microsoft Forms requires manual data merging, WPS Office provides a lightweight, highly compatible alternative for organizing, editing, and combining your downloaded Excel worksheets without the hefty subscription fees.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
- 2. Open Multiple Spreadsheets: Launch WPS Spreadsheet and use the convenient tabbed view to open all your downloaded form response files simultaneously.
- 3. Consolidate Your Data: Easily navigate between tabs to copy the rows from each individual file and paste them into your unified master spreadsheet.

Frequently Asked Questions
Can I use Power Automate to combine Microsoft Forms responses?
Yes, advanced users can set up Microsoft Power Automate flows to record incoming responses from multiple forms and push them into a single Excel Online spreadsheet or SharePoint list, bypassing the native limitation.
Will my manually combined spreadsheet update when new forms are submitted?
No. If you combine the data manually by copying and pasting, the master spreadsheet will remain static. You must manually add any new responses as they come in.
Where can I request the automatic combination feature from Microsoft?
You can suggest or vote for this feature on the official Microsoft Forms feedback portal. Microsoft uses this portal to track highly requested features for future updates.




