Reuse Microsoft Forms for Multiple Classes and Combine Responses
Question details
The user wants to reuse a Microsoft Forms survey across multiple classes while identifying each class and combining the response data.

- 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.
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.
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.
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.
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.
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.
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.
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.

Add a required class question to one shared form
Use this method when all classes can answer the same form and you want their responses collected together from the start.
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.

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.




