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 http://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?

  • December 11, 2015 at 3:19 PM

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

  • November 7, 2014 at 9:19 AM

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

  • April 3, 2014 at 9:58 AM

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

  • February 27, 2014 at 8:14 PM

    this is really helpful one…thanks a ton 🙂

  • November 9, 2013 at 11:56 AM

    Thank you very much..! 🙂

  • October 24, 2013 at 7:08 PM

    Exxxcellent. Just what I needed.

  • August 1, 2013 at 9:47 PM

    This did not reset the response number count.

  • April 26, 2013 at 10:14 AM

    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.

    • April 26, 2013 at 10:50 AM

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

  • April 2, 2013 at 8:23 PM

    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!

  • March 26, 2013 at 6:04 PM

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

  • March 20, 2013 at 5:37 PM

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

  • February 19, 2013 at 8:21 PM

    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: http://Your-Site/_layouts/sitemanager.aspx in browser!

  • January 17, 2013 at 9:45 AM

    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 🙂

  • September 7, 2012 at 9:44 PM

    Thanks, great tip!

  • March 27, 2012 at 1:55 PM

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

  • February 7, 2012 at 5:33 PM

    Worked perfectly. Thanks.


Leave a Reply