How to Change Microsoft Forms Response Destination to a New Excel Sheet
Question details
The user wants to direct responses from a reused Microsoft Form into a new Excel worksheet, such as for weekly data collection.
- Product
- Microsoft Forms / Excel
- Device & OS
- not provided
- Scenario
- Reusing a Microsoft Form periodically and wanting each period's responses to be saved in a separate Excel sheet automatically.
- Observed behavior
- Microsoft Forms continuously records all responses in the originally connected workbook and worksheet, without automatically separating them into new sheets.
Ensure you have access to your Microsoft 365 account and the necessary permissions to duplicate the existing form.
Duplicate the Microsoft Form to Create a New Excel Destination
Creating a copy of your form generates a fresh response set, which will open in a newly generated Excel workbook.
Microsoft Forms does not currently support routing responses from a single form into multiple different worksheets automatically. The standard workaround provided by Microsoft is to duplicate the form for each new session (e.g., weekly or monthly).
Log in to Microsoft Forms and locate the specific form you want to reuse.
Click on the three dots (More options) on the top right corner of the form tile, then select 'Copy' from the dropdown menu to duplicate the form.
Open the newly copied form, optionally rename it to reflect the new period, share it with your respondents, and collect the new data.
Go to the 'Responses' tab of the copied form and click 'Open in Excel' to view the newly collected data in a separate spreadsheet.
Manage Your Spreadsheets Easily with WPS Office
While managing complex form integrations in Microsoft Office can sometimes be restrictive, WPS Office offers a lightweight, free alternative with complete compatibility for all your Excel workbooks. Open, edit, and organize your form response data without heavy subscriptions.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your downloaded Microsoft Forms .xlsx response file.
- 3. Organize Your Data: Easily add new worksheets and copy-paste your weekly form responses using familiar spreadsheet tools.
Frequently Asked Questions
Can I link multiple Microsoft Forms to a single Excel workbook automatically?
No, Microsoft Forms natively creates a new Excel workbook for each form. To consolidate data automatically, you would need to use Power Automate to build a flow that routes incoming responses to a designated master workbook.
How do I disconnect a Microsoft Form from its current Excel sheet?
You cannot easily disconnect a live form from its initial sheet without breaking the sync. The most reliable method to reset the destination is to copy the form, which creates a brand new connection.
Does clearing form responses delete them from the Excel sheet?
If your form is synced to an Excel workbook hosted on OneDrive or SharePoint, deleting responses in the Forms web interface does not automatically delete the historical synced data stored in the Excel sheet.
Why isn't my Excel workbook updating with new Microsoft Forms responses?
This sync error often happens if the original Excel file was moved, renamed, or corrupted. You can fix this by going to the Forms 'Responses' tab, clicking the three dots, and selecting 'Sync all responses to a new workbook'.
