Others

Can Microsoft Forms Delete All Quiz Responses Automatically?

Huda Qurayshi Oct 10, 2026 868 views

Question details

The user is looking for a way to automatically delete all quiz responses in Microsoft Forms when reusing the same quiz across multiple groups.

Can Microsoft Forms Delete All Quiz Responses Automatically?

Product: Microsoft Forms
Device & OS: not provided
Scenario: Reusing a single quiz or form across different groups of respondents and needing to clear previous data automatically to prepare for the next group.
Observed behavior: Microsoft Forms does not provide a direct built-in automation command to delete all responses; it requires manual intervention.

Before you start

Before deleting any responses, ensure you have exported or backed up the existing response data to an Excel spreadsheet, as deleted responses in Microsoft Forms are permanently removed.

Solution 1Recommended

Manually Clear Responses and Archive with Power Automate

Since there is no native automated deletion, you must manually clear responses. You can pair this with a Microsoft Power Automate flow to archive data before resetting the quiz.

Microsoft Forms does not currently support automatically deleting all quiz responses at scheduled intervals or between group sessions. You must manually clear the responses to reset the quiz for a new group.

To streamline the process, advanced users can set up a custom Power Automate flow to archive responses to a SharePoint list or Excel file automatically. This ensures data is safely backed up before you manually trigger the deletion.

Open the Form

Navigate to the Microsoft Forms portal and open the specific quiz or form you want to reset.

Go to Responses

Click on the 'Responses' tab located at the top of the form editing interface to view the summary metrics.

Access More Options

Click the 'More options' icon (represented by three dots) on the right side of the response summary.

Delete All Responses

Select 'Delete all responses' from the dropdown menu, and confirm the permanent deletion when prompted to reset the quiz for your next group.

Explore Power Automate (Optional)

Visit the Microsoft Power Automate Community to find custom flow templates that automatically extract and save form responses to Excel, preventing data loss before manual deletion.

Manually Clear Responses and Archive with Power Automate

Data Protection: Always ensure you have clicked 'Open in Excel' to download your response data before selecting 'Delete all responses', as this action cannot be undone.

Free Microsoft Office alternative

Try WPS Office for Comprehensive Data and Form Management

If you frequently work with exported form data and need a powerful, lightweight suite to analyze responses, WPS Office is an excellent free alternative to Microsoft Office. It seamlessly handles exported quiz data and offers built-in tools for creating and managing forms.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Open Exported Data: Launch WPS Spreadsheets and open the .xlsx file containing your exported Microsoft Forms responses.
3. Analyze Results: Utilize WPS Spreadsheets' advanced data visualization and pivot chart tools to summarize your quiz data across multiple groups.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your downloaded form responses open flawlessly.Includes robust data sorting, filtering, and pivot table features to analyze quiz responses efficiently.Free, lightweight, and fast to install on Windows, Mac, Linux, and mobile devices.Features a familiar user interface that requires no learning curve for seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Can I recover deleted responses in Microsoft Forms?

No, once you click 'Delete all responses' in Microsoft Forms, the data is permanently removed and cannot be recovered. Always ensure you export your data to Excel before clearing the form.

How do I reuse a Microsoft Form without deleting previous responses?

Instead of deleting responses, you can duplicate the form. Go to the Microsoft Forms portal, click the three dots on the quiz tile, and select 'Copy'. This creates a fresh version of the quiz with zero responses while keeping the original intact.

Can Power Automate automatically delete form responses?

Currently, Power Automate does not have a built-in action to delete Microsoft Forms responses. It can only be used to route, notify, or archive the response data to other services like SharePoint or Excel.

Does WPS Office have a form creation tool?

Yes, WPS Office includes a form builder feature that allows you to easily create surveys and quizzes, share them with users, and seamlessly collect and analyze the data directly within WPS Spreadsheets.

Office Quick Solutions