Others

Reuse Microsoft Forms for Multiple Classes and Combine Responses

Elise WilliamsElise Williams Nov 13, 2026 870 views

Question details

The user wants to reuse a Microsoft Forms survey across multiple classes while identifying each class and combining the response data.

Reuse Microsoft Forms for Multiple Classes and Combine Responses
Product
Microsoft Forms and Microsoft Excel
Device & OS
not provided
Scenario
Collecting the same survey answers from several classes and organizing them into one dataset for analysis.
Observed behavior
Reusing a form does not automatically label responses by class. Copying a form duplicates its structure but does not include existing responses.
Before you start

Decide whether each class needs a separate survey link or can use one shared form with a required class question. If you use separate forms, keep the questions, answer options, and question order consistent so their exports can be combined.

Solution 1Recommended

Copy the form for each class and combine the Excel exports

Use this method when each class needs its own survey link and separate response collection.

1
Create a copy for each class

On the Microsoft Forms home page, open the original form's More options menu and select Copy. Rename each copy with its class name, keeping the survey questions in the same order.

2
Share the class-specific links

Open each copied form, select Collect responses, and send its link to the corresponding class. Keep a list matching each form name to its class.

3
Export each response set

After collecting responses, open each form's Responses tab and select Open in Excel or the available Excel download option. Save each response workbook with a recognizable class name.

4
Label the rows by class

Open each exported workbook in Excel and add a column named Class. Fill that column with the correct class name for every response row, placing it in the same column position in every workbook.

5
Combine the response rows

Create a master Excel workbook and copy the headers from one export into its first row. Copy the response rows from every class export below those headers without repeating the header row. Match columns by header name, then select the combined data and use Insert > Table to make filtering easier.

Copy the form for each class and combine the Excel exports
Copied forms start with no responses: Copying a form does not move its existing responses. Export responses from the original form separately if you also need them in the master workbook.
Free Microsoft Office alternative

Combine Exported Class Responses in WPS Spreadsheet

WPS Office is a free, lightweight alternative for working with the Excel files exported from Microsoft Forms. Its familiar spreadsheet interface and Excel format compatibility make it easy to move your response-analysis workflow to WPS. It does not change how Microsoft Forms collects or labels responses.

Combine exported class-response rows into one worksheet and filter them by class.Open, edit, and save Microsoft Excel .xlsx and .xls files.Use familiar spreadsheet controls for sorting, filtering, and reviewing survey answers.Move existing response workbooks into a free, lightweight Office workflow without re-entering the data.
microsoft office alternative - wps office

Frequently Asked Questions

Does copying a Microsoft Form also copy its responses?

No. Copy creates a separate form with the survey structure, not its response history. To retain existing answers, open the original form's Responses tab and export them to Excel.

Can I use one Microsoft Forms link for every class?

Yes. Add a required Choice question listing the classes, then use Collect responses to share one link. The selected class will appear with each new response and in the Excel export.

How do I prevent columns from getting mixed up when combining exports?

Keep the questions and their order identical across copied forms. Before pasting response rows into the master workbook, compare the exported column headers and align them by name. Include the header row only once.

Can WPS automatically identify the class for an unlabeled response?

No. WPS Spreadsheet can organize exported data, but it cannot infer a missing class reliably. Add a class question before collection, or label rows from separate form exports using the known class associated with each form.