Google Forms – Managing your form’s responses

Once you’ve made your form and shared it, you’ll then want to see the responses  and probably want to have a visual summary of them. Google Forms provides a wonderful graphical summary of the responses automatically right within Forms itself, so there’s no need to create charts yourself.

Open your form and you’ll be in the form editor. There are two main parts to the editor, the questions and the responses. Click on “Responses”. Here it will tell you how many responses you’ve received and gives you the option of seeing a summary of them or seeing the individual responses.

Forms responses - 1

VIEWING A SUMMARY OF THE RESPONSES

Click on “Summary”. Here you’ll see all the typed in responses and for questions where there were limited options, you’ll see a graph.

In this question, I can quickly see that some of my students don’t know the capital of Wales, so I’ll need to do something about that in a future class.

Forms responses - 4

Here’s an example of a question asking for their comments:

Forms responses - 5

This one was a Checkbox question and I can quickly see the most popular sessions at this conference.

Forms responses - 6

This question was a linear-scale question. Here I can see that our customers are happy.

Forms responses - 7

This question was a multiple-choice grid and within one graph can show a lot of information. In this case, we asked them to rate the teachers on a set of criteria.

Forms responses - 8

With date and time questions, Forms will put the date or time entered along with the number of people who entered it, so you can see the most popular one.

Forms responses - 9 Forms responses - 10


VIEWING INDIVIDUAL RESPONSES

If you want to see want a specific person filled out on your form, click on “Individual”. You can flick through the responses by clicking on the arrows next to where it says. e.g. “1 of 9”.

Forms responses - 16

This shows you exactly what the form-filler completed. It also gives you the option of deleting a response, by clicking on the bin icon to the right.

Forms responses - 18


Back to the top of the page, there are some further options that you can change.

On the right, you can switch off “Accepting responses”, which means that no-one can submit more responses using your form.

Forms responses - 11

When you first create a form, you can link a spreadsheet to it, so that the responses are stored in a place other than within Forms. Either click on the green spreadsheet icon or the 3 dots and click on “Select responses destination”.

Forms responses - 15

You then have the choice of creating a new spreadsheet (and naming it) or adding a new page to an existing spreadsheet. If you want a new one, just click “Create”. If you want it to add to an existing one, click “Select existing spreadsheet”.

Forms responses - 13

Clicking the second option, opens up a dialogue box where you can choose the spreadsheet you want by clicking on it, then click “Select”.

Forms responses - 14


If you’ve already set up a spreadsheet, clicking on the green spreadsheet icon will open the spreadsheet where the responses arrive and live.

Forms responses - 12


There are also some other useful options by clicking on the 3 dots.

Get email notifications for new responses – By selecting this, Forms will send you an email every time someone fills out and submits your form.

Unlink form – Choose this if you want to disconnect a spreadsheet from a form.

Download responses (.csv) – This downloads the responses in .csv format which can be useful for uploading the data to another application.

Delete all responses – Sometimes you want to use your form with a different set of people, e.g. a new class, but you don’t want to mix the old and new responses. So, here you can delete all the responses from the form. Note, this deletes them from the form but those already collected in the spreadsheet remain.

Forms responses - 15


eBooks now available on Drive, Forms, Sheets, Docs, and Slides:

Baz Roberts (Flipboard / Twitter / Google+)


5 thoughts on “Google Forms – Managing your form’s responses

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s