1

My colleague and I did a survey on google form. Once the data started coming in, she started sorting and editing the data directly on the response spreadsheet. This led to the data getting mixed up. I only realized the results were wrong after analyzing the data, and there was no way the respondents could have provided their answers wrong.

Questions:

  1. Is this caused by the filtering, sorting and editing data directly in the google form response spreadsheet?
  2. Is there a way to undo all the sorting, filtering and editing, so that we see only the original response from all the respondents?

Any help is appreciated, thanks!

1 Answer 1

1

If you did all the sorting AFTER the last response, you can access to the Version History in File>Version Historyor withCtrl.+Alt+Shift+H`

enter image description here

There you can check, recover or make a copy of the prior versions of the spreadsheet. If you did the editions after the last response, just find the moment of the last response, and recover that; if you made editions in between responses, it would be a little trickier to track down the responses

But, what you can do is to Unlink your form:

enter image description here

And create a new file, by selecting a new destination in the Responses tab of the form:

enter image description here

It would create a new fresh spreadsheets with all the responses as new!

1
  • 1
    Yes, of course! That was what I meant with "it would be a little trickier to track down the responses" --> if there were hundreds or thousands of responses and months of editing, it would be quite complex to accomplish that; but of course, it's an option!
    – Martín
    Commented Jul 6 at 22:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.