Google-forms – Edited Google Form while users were responding – how to recover initial responses

google-forms

I have utilized Google Forms to create a mid-term exam for my students. However, after they started taking the quiz, I went in to edit and simply added a section after the first question and now, after the students have submitted their responses, nothing is showing up in either the "responses" tab on Google Forms nor in the spreadsheet. I took the exam after making the change and my responses are showing up. Thus, it looks like I was the only one that selected any responses. The only response that is showing up is the students' responses to the first question (which I made into a password). Thus, I know that their responses are recorded, they're just not showing up in my version of the form.

screen shot

Thus, my question is whether or not I can revert to earlier versions of the Google Form so that I can actually see their responses and create a spreadsheet from them? Two reasons I am confident the responses have been recorded are that I literally saw a students' screen before they submitted and every question was populated with a response when they submitted and another students' screen showed the message "successfully recorded."

Any help you can offer would be greatly appreciated. I truly hope I don't have to ask the students to take the exam again!

Best Answer

Assuming you didn't delete the responses that were already recorded you can absolutely recover them.

  1. Open the form
  2. Click the "Responses" tab
  3. Click the Vertical ... menu
  4. If you hadn't linked your responses to a spreadsheet click the "Select Response Destination" option. If it was linked to a spreadsheet, click "Change Response Destination."
  5. Either create a new spreadsheet or select an existing spreadsheet depending on whether or not you had already linked to a sheet (it would create a new form responses tab if you link to existing.)

When the sheet is created it will automatically populate it with all responses that were ever received by the form.

Related Topic