Tuesday, October 4, 2016

Google Forms: Deleting Responses

You made a Google Form and then you filled it out to test it.  Or maybe you are reusing a form and you want to get rid of last year's responses.  You can do this very easily.

You can delete the responses in the form only, or in the spreadsheet only.  You can delete them from both places - but these are two separate actions.


Deleting Responses From the Form

1.  Click over to the responses section.


2.  Click on the little three dots icon in the top right corner.


3.  Choose "Delete all responses" from the menu.


4.  Click "ok" when it warns you.



As it stated in the warning, this does not delete the responses from the spreadsheet if one was created.


Deleting Responses From the Spreadsheet

1.  Go to the spreadsheet where your responses are.
2.  Delete the entire row for each of the responses you wish to delete - you can select more than one at a time.

If you just delete the text and not the entire rows, Google Forms will still skip those rows when new responses come in.  If you want to clear the responses for good, you should delete the entire row.  


If you want to keep the responses but not see them, you can simply hide the rows.


You can also duplicate the sheet so that you can save old responses before you delete them from the "live" sheet.

3 comments:

  1. Thank you! Very clear and solved my problem. I would delete it in one or the other place, but not both (which I will now do).

    ReplyDelete
  2. Thanks. I couldn't figure out why the spreadsheet hadn't cleared.

    ReplyDelete
  3. thanks for the post. what if the delete all responses is grayed out? I cannot select it. Any ideas for that situation or what causes it?

    ReplyDelete

Thank you so much for taking the time to leave a comment!

Helping teachers incorporate technology, one tech tip at a time.