Others

Combine Responses from Multiple Microsoft Forms in One Excel Worksheet

Natalie TaylorNatalie Taylor Nov 4, 2026 869 views

Question details

The user wants to automatically merge survey or quiz responses gathered from multiple Microsoft Forms into a single Excel worksheet.

How to Combine Responses from Multiple Microsoft Forms in One 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.
Before you start

Ensure you have exported the individual responses from all relevant Microsoft Forms to Excel workbooks and saved them in an accessible folder.

Solution 1Recommended

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.

1
Export Form Responses

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.

2
Create a Master Workbook

Open a new, blank Excel workbook. This will serve as your unified database for all form responses.

3
Copy and Paste Data

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.

Manually Combine Data in Excel
Real-time Updates Limitation: Manual combinations will not update automatically. You will need to repeat this copy-paste process periodically to capture any new responses submitted after your export.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
  2. 2. Open Multiple Spreadsheets: Launch WPS Spreadsheet and use the convenient tabbed view to open all your downloaded form response files simultaneously.
  3. 3. Consolidate Your Data: Easily navigate between tabs to copy the rows from each individual file and paste them into your unified master spreadsheet.
Fully compatible with Microsoft Excel (.xlsx) files downloaded directly from Microsoft Forms.Features an intuitive tabbed interface to open multiple worksheets in a single window for rapid copying and pasting.Lightweight software that runs smoothly on Windows, Mac, and Linux environments.Free to download and use for all your essential spreadsheet and data management tasks.
microsoft office alternative - wps office

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.