--- title: How do I view and delete responses in Microsoft Forms? description: Microsoft Forms allows form owners to review responses, delete individual responses, remove all responses, and export response data to Excel for further analysis. --- [Skip to content](https://help.stalbansdiocese.org/forms-view-delete#main-content) English Show submenu for translations [![dioceseofstalbans-technology\_474x247-1](https://help.stalbansdiocese.org/hs-fs/hubfs/dioceseofstalbans-technology_474x247-1.png?width=192&height=100&name=dioceseofstalbans-technology_474x247-1.png)](https://help.stalbansdiocese.org/?hsLang=en) - [🎟️Raise Support Ticket](https://help.stalbansdiocese.org/tickets-new) - [🎫My Tickets](https://help.stalbansdiocese.org/tickets-view) - [🧠Knowledge Base](https://help.stalbansdiocese.org/) Open main navigation Close main navigation - [🎟️Raise Support Ticket](https://help.stalbansdiocese.org/tickets-new) - [🎫My Tickets](https://help.stalbansdiocese.org/tickets-view) - [🧠Knowledge Base](https://help.stalbansdiocese.org/) - English Show submenu for translations - [My Tickets](https://help.stalbansdiocese.org/tickets-view) [My Tickets](https://help.stalbansdiocese.org/tickets-view?hsLang=en) How can we help? - There are no suggestions because the search field is empty. 1. [IT Help](https://help.stalbansdiocese.org/?hsLang=en) 2. [Software & Services](https://help.stalbansdiocese.org/software-services?hsLang=en) 3. [Forms](https://help.stalbansdiocese.org/software-services?hsLang=en#forms) # How do I view and delete responses in Microsoft Forms? ## Microsoft Forms allows form owners to review responses, delete individual responses, remove all responses, and export response data to Excel for further analysis. ### **Contents** - [View Responses Online \>](https://help.stalbansdiocese.org/forms-view-delete#view) - [View and Download Responses in Excel \>](https://help.stalbansdiocese.org/forms-view-delete#excel) - [Delete an Individual Response \>](https://help.stalbansdiocese.org/forms-view-delete#delete-individual) - [Delete All Responses \>](https://help.stalbansdiocese.org/forms-view-delete#delete-all) --- ### **View Responses Online** 1. Open [**Microsoft Forms**](https://forms.cloud.microsoft) and select your form. 2. Select the **View responses** tab at the top of the form. ![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-11-44-04-7809-AM.png?width=670&height=47&name=image-png-Jun-25-2026-11-44-04-7809-AM.png) 3. You will see: - A summary of responses and results. - Charts and response statistics. - Individual responses using the **Check individual results** option. - A linked Excel spreadsheet with the results in. - [See View and Download Responses in Excel below \>](https://help.stalbansdiocese.org/forms-view-delete#excel) ![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-11-46-13-4855-AM.png?width=670&height=139&name=image-png-Jun-25-2026-11-46-13-4855-AM.png) --- ### **View and Download Responses in Excel** The spreadsheet contains all submitted responses and can be used for filtering, sorting, reporting, and analysis. **Warning: Do not edit, rename, move, or restructure the linked spreadsheet**, as changes can cause the workbook to become disconnected from the form. To work with responses in a spreadsheet: 1. Open the form and select the **View responses** tab.![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-12-01-20-5465-PM.png?width=300&height=283&name=image-png-Jun-25-2026-12-01-20-5465-PM.png) 2. By the Excel file name, select the dropdown arrow on the right to display all options 1. **Open in Excel Desktop:** Opens the linked spreadsheet in Excel 1. ⚠️**Best Practice:** Always keep the original linked workbook unchanged and use a separate copy for reporting or data analysis. This helps prevent the form from becoming detached from its response data.⚠️ 2. **Download a copy:** Downloads a copy of the spreadsheet 1. Use this option if you wish to analyse or manipulate the response data 3. **Disconnect and sync to a new workbook** 1. Use this option if the linked spreadsheet is corrupt. See: **[My Microsoft Form Responses Excel spreadsheet is no longer receiving updates from the form \>](https://help.stalbansdiocese.org/msforms-workbook-disconnected?hsLang=en)** --- ### **Delete an Individual Response** If you need to remove a specific response: **Warning:** Deleted responses cannot be recovered. ![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-12-03-13-3784-PM.png?width=300&height=237&name=image-png-Jun-25-2026-12-03-13-3784-PM.png) 1. Open your form and select the **View Responses** tab. 2. Select **Check individual results**. 3. Use the navigation arrows to locate the response you want to delete. 4. Select the **ellipsis (...) menu** in the top right of the response 5. Select **Delete response** 6. Confirm the deletion when prompted. ![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-12-04-33-8501-PM.png?width=600&height=143&name=image-png-Jun-25-2026-12-04-33-8501-PM.png) --- ### **Delete All Responses** To remove all responses from a form: **Warning:** This permanently deletes all response data from the form and cannot be undone. 1. Open the form and go to the **View Responses** tab. 2. Select the **ellipsis (...) menu** in the top right. 3. Click **Delete all responses**. 4. Confirm the deletion. ![](https://help.stalbansdiocese.org/hs-fs/hubfs/image-png-Jun-25-2026-12-05-54-0826-PM.png?width=600&height=94&name=image-png-Jun-25-2026-12-05-54-0826-PM.png) - [Communications](https://help.stalbansdiocese.org/communications?hsLang=en#main-content) - [Branding](https://help.stalbansdiocese.org/communications?hsLang=en#branding) - [Devices](https://help.stalbansdiocese.org/devices?hsLang=en#main-content) - [All Devices](https://help.stalbansdiocese.org/devices?hsLang=en#all-devices) - [Computer](https://help.stalbansdiocese.org/devices?hsLang=en#computer) - [iPhone, iPad & Android](https://help.stalbansdiocese.org/devices?hsLang=en#iphone-ipad-android) - [Personal](https://help.stalbansdiocese.org/devices?hsLang=en#personal) - [Links](https://help.stalbansdiocese.org/links?hsLang=en) - [Software & Services](https://help.stalbansdiocese.org/software-services?hsLang=en#main-content) - [Artificial Intelligence (AI)](https://help.stalbansdiocese.org/software-services?hsLang=en#artificial-intelligence-ai) - [Calendars & Tasks](https://help.stalbansdiocese.org/software-services?hsLang=en#calendars-tasks) - [CMS & Database](https://help.stalbansdiocese.org/software-services?hsLang=en#cms-database) - [Emails](https://help.stalbansdiocese.org/software-services?hsLang=en#emails) - [Files](https://help.stalbansdiocese.org/software-services?hsLang=en#files) - [Meetings](https://help.stalbansdiocese.org/software-services?hsLang=en#meetings) - [Finance](https://help.stalbansdiocese.org/software-services?hsLang=en#finance) - [Forms](https://help.stalbansdiocese.org/software-services?hsLang=en#forms) - [PDFs](https://help.stalbansdiocese.org/software-services?hsLang=en#pdfs) - [Printing & Scanning](https://help.stalbansdiocese.org/software-services?hsLang=en#printing-scanning) - [Security & Data Protection](https://help.stalbansdiocese.org/software-services?hsLang=en#security-data-protection) - [SharePoint & OneDrive](https://help.stalbansdiocese.org/software-services?hsLang=en#sharepoint-onedrive) - [Staff](https://help.stalbansdiocese.org/software-services?hsLang=en#staff) - [Teams](https://help.stalbansdiocese.org/software-services?hsLang=en#teams) - [Teams Phone](https://help.stalbansdiocese.org/software-services?hsLang=en#teams-phone) - [Video Conferencing](https://help.stalbansdiocese.org/software-services?hsLang=en#video-conferencing) - [Website](https://help.stalbansdiocese.org/website?hsLang=en) - [Contact](https://help.stalbansdiocese.org/contact?hsLang=en) [![Chill listening crop-3](https://help.stalbansdiocese.org/hs-fs/hubfs/apple-touch-icon-1.png?width=24&height=24&name=apple-touch-icon-1.png "Chill listening crop-3")](https://help.stalbansdiocese.org?hsLang=en) St Albans Diocesan IT Team Copyright © 2026, Diocese of St Albans