Data Import & Export

How to Send Multiple Microsoft Forms and Combine Results in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to distribute similar Microsoft Forms surveys separately using a personal account and then consolidate the downloaded responses into a single Excel workbook for analysis.

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Collecting responses from multiple similar surveys and combining the data into one central Excel file.
Observed behavior: Responses must be downloaded individually from each form and manually combined into a master Excel workbook while preserving source identifiers.

Before you start

Ensure that all your Microsoft Forms surveys have identical or highly similar questions to make appending and analyzing the data in Excel much easier.

Solution 1Recommended

Manually Download and Combine Form Responses in Excel

Since the personal version of Microsoft Forms doesn't support automatic consolidation, you will need to export each form's results and manually combine them in Excel.

By following this approach, you can gather responses from distinct recipient groups and consolidate them while keeping track of where each entry originated.

Create and share surveys

Create each survey in Microsoft Forms. Click 'Share' and send them to your different recipient groups separately.

Download responses to Excel

Open each form's 'Responses' tab in Microsoft Forms and select 'Open in Excel' to download the individual result workbooks.

Move or copy worksheets

Open the downloaded Excel workbooks. Right-click a sheet tab containing the survey data, select 'Move or Copy', choose a new master destination workbook from the drop-down list, and repeat this for each downloaded sheet.

Append data into one sheet

Once all sheets are in the master workbook, copy and paste the rows into a single worksheet. Create an additional column named 'Source Survey' to identify where each row of data came from.

Maintain Consistent Headers: When appending data into a single sheet, ensure the column headers from all forms match exactly to prevent data misalignment.

Combine Data in WPS Spreadsheet

Combine Your Survey Responses Effortlessly with WPS Spreadsheet

After downloading your Microsoft Forms responses, you can quickly consolidate and analyze the Excel files using WPS Spreadsheet, a free and highly compatible tool for all your data management needs.

1. Open Downloaded Forms: Launch WPS Spreadsheet and open all the downloaded .xlsx files containing your survey responses.
2. Move Sheets to One Workbook: Right-click the sheet tab at the bottom, click 'Move or Copy Sheet', and select your main workbook as the destination.
3. Consolidate Data: Copy the data from the newly moved sheets and paste them into your primary worksheet, making sure to add a column indicating the source form.

Fully compatible with Microsoft Excel (.xlsx) formats.Easily merge multiple worksheets into a single workbook.Advanced sorting and filtering tools for survey analysis.Free, lightweight, and completely ad-free for standard data tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Can I automatically combine Microsoft Forms responses into one Excel sheet?

In the personal version of Microsoft Forms, responses cannot be automatically combined. You must download each form's results as a separate Excel file and manually merge the data. Enterprise users, however, can use Microsoft Power Automate to sync multiple form responses to a single master Excel file.

How do I keep track of which form the data came from after combining?

Before copying and pasting the data from different sheets into your master worksheet, insert a new column labeled 'Source' or 'Survey Name' in each downloaded sheet and fill it with the respective form's name for all its rows.

Why are my columns misaligned when appending survey data in Excel?

This happens when the questions in your multiple forms are not identical or are ordered differently. You must manually rearrange the columns in the downloaded Excel files to match your master sheet's structure before copying the data over.

Is there a quick way to move all sheets into one workbook?

Yes, open all the Excel workbooks you want to combine. Right-click the sheet tab you wish to move, select 'Move or Copy', and choose your master workbook from the 'To book' dropdown list. Repeat this for all open workbooks.

Excel & Data Problems