Delete all survey responses

Question

Hopefully a simple question yet I can't seem to find a simple answer. In SharePoint 2010 Foundation, how can I delete ALL survey responses at once? I can delete one at a time, but with over 450 responses, that will not do.

We have a periodic survey that we need to clear so we can open it up again to see if there have been any improvements in our scores.

score 5 · Accepted Answer · answered Dec 02 '13 at 03:51

5

Open site manager by adding *_layouts/sitemanager.aspx* in the url. (e.g) http://www.servername:10001/_layouts/sitemanager.aspx
You can access the same in Site Actions >> Manage Content and Structure ( in SP 2007) (or) Site Settings>> Site Administration>> Content and Structure (in SP 2010).
Navigate down to your survey.
Select all responses and go to Actions >> delete.

Alternatively, you can find a useful link here

answered Dec 02 '13 at 03:51

Manivannan Nagarajan

592
2
14
25

Thanks for the response. I had found that information prior but when I go to the sitemanager.aspx page, I get an Unexpected Error and there is no Content and Structure option in Site Settings -> Site Admin. I had wondered if using this was a feature missing in Foundation. – Trido Dec 02 '13 at 04:07
1

Can you perform the following steps: Navigate to Site Settings, click Modify All Site Settings, and then under Site Collection Administration, click Go to top level site settings. Under Site Administration, click Content and Structure.
Note: To access the Site Content and Structure page, you must have a minimum of Contribute permissions.
– Manivannan Nagarajan Dec 02 '13 at 07:36

score 2 · Answer 2 · edited Apr 13 '17 at 12:41

While there are ways to delete all items from a list (e.g. through powershell on the sharepoint server) (I would advise testing this code on another list or dev environment first to make sure you understand what it is doing):

$web = Get-SPWeb http://mysite
$list = $web.Lists["My Survey"]

while($list.Items.Count -gt 0){$list.Items.Delete(0)}

Another simple option is to save the list as a list template (without the content), then create a new survey list from the site template:

Click List Settings -> Save List as Template. Make sure "Include Content" is unchecked. Click OK. Go to Site Actions -> Create List. Find the list template you created and click OK. Give it a new name (e.g. People survey 2013). Now you have a copied empty survey list with the original data in tact as well. :)

I have assumed a relatively small/medium sized list for the deletion code. If you have a large list, you may be better of using a batch deletion command to improve performance. — Russell, Dec 02 '13 at 04:31

score 1 · Answer 3 · edited Apr 09 '16 at 14:22

1

The best way to Remove All Responses from SharePoint Survey is: using "Site Content and Structure Manager".

Go to Site Actions > Site Content and Structure Manager'
you can click the header Double check-box Icon to select all items
Now select actions -> delete

Find the detailed example at: How to Remove All Responses from SharePoint Survey

edited Apr 09 '16 at 14:22

Iman

583
9
19

answered Jun 23 '14 at 13:58

Smith

11
1

score 1 · Answer 4 · answered Aug 16 '18 at 18:36

1

There is no "Content & Structure in SP2010.. Save as a template and start over? All these answers are bogus.

answered Aug 16 '18 at 18:36

Frustrated Guest

11
1

You are correct - Content and Structure are "missing" in SP 2010. – Benny Skogberg Aug 16 '18 at 19:35

score 0 · Answer 5 · answered Jun 23 '14 at 15:34

Save the survey as a template in the list settings (do not include content) Create a new empty copy of the survey from that template(delete the old one first if you want the same name)

I love how everyone always assumes people have enterprise features (the sitemanager) or want code when simple options are available.

Delete all survey responses

5 Answers5