How to Remove All Responses from SharePoint Survey?

How to delete all the survey responses in SharePoint 2007 all at once without having to go through deleting one at a time?

sharepoint survey remove all responses

Datasheet view? Oops, it doesn’t support the datasheet view. How to Delete All Survey Responses and results in one click?

Here is an easy solution:

Go to Site Actions >> Site Content and Structure Manager, browse the survey list. Use the select all checkbox just below the menu bar on top of the list to select all the answers. Select in the ‘Actions’ menu and then the delete option. This will bulk delete all/multiple responses from the SharePoint survey.

SharePoint Survey Delete All Responses

Unable to find  Site Content and Structure Manager In Site actions? Don’t panic. Just enter https://Your-Site/_layouts/sitemanager.aspx  in the browser!

Reset survey response number in SharePoint:
If you want to reset Response Number, here is how to reset the SharePoint survey response count: Save the survey list as a template, Delete the original survey list and create a new Survey based on the survey template you have created!

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

17 thoughts on “How to Remove All Responses from SharePoint Survey?

  • Agree but it really do not reset the counting which can be confusing .Please provide information for this as well.Thank you!

    Reply
  • This is a good time saver. Thanks for the post.

    Reply
  • This came at the right time. Thanks for the post Salaudeen Rajack.

    Reply
  • this is really helpful one…thanks a ton 🙂

    Reply
  • Thank you very much..! 🙂

    Reply
  • Exxxcellent. Just what I needed.

    Reply
  • This did not reset the response number count.

    Reply
  • Is this option available in Sharepoint 2010 Foundation, or just in SP2010 Server Edition. As i am using the Free version of SP and not able to find this option.

    Reply
    • Unfortunately, This option is available only on SharePoint Server and not Foundation!

      Reply
  • This saved us a lot of time! Thank you! We were trying to create a custom Datasheet View of a survey, but now there is no longer a need for that!

    Reply
  • totally forgot this option when i was trying myself.. thanks a lot!!!

    Reply
  • This is perfect. It is amazing that this information is not easy to get to in the Microsoft website or in my companie’s help desk. Thank you, thank you, thank you…..

    Reply
  • Thanks a ton for sharing this useful information.
    The below mentioned information worked for me !

    Unable to find Site Content and Structure Manager In Site actions? Don’t panic. Just enter: https://Your-Site/_layouts/sitemanager.aspx in browser!

    Reply
  • Thanks a ton for sharing this info.. this really helped a lot and was real quick, saving a lots of time for me.. thanks again 🙂

    Reply
  • Thanks, great tip!

    Reply
  • thanks for sharing this info, just used it and it worked great as is.

    Reply
  • Worked perfectly. Thanks.

    Reply

Leave a Reply