Editing responses to a Google Form

[enjay]

I recently sent all staff a survey via Google Forms, and would like to modify some of their results. This isn't any dodgy election-rigging thing or anything (!), the problem I have is lots of support staff ticked the box saying "I don't know how to use this" for a product which only teachers use, meaning the results analysis within the Form isn't much use.

 

I know I could take the data out to Sheets, edit it there then draw new graphs, but that seems like the long way round when Google already makes such pretty graphs and analysis of the results for me. So, does anyone know of a way I can edit people's responses, without going to each person in turn and asking them to re-submit?

[j224]

There doesn't seem to be a way, other than what you suggested using Sheets.