Google Forms is definitely one of the key tools to use to create and grade digital quizzes. It is simple and easy to use and is integrated with Google Drive allowing you to access other Drive services from one single spot. If you have never created a quiz on Google Forms you can check this post for step by step guidance. 

In today’s post, I am sharing with you this handy tip which allows you to gather your Forms responses inside a spreadsheet in Google Sheets. As you probably know, once respondents to your form submit their responses you can either collect them inside the form itself or in a new or existing spreadsheet. Here is how to do it:

1- Open your form in Google Forms

2- Click on ‘Responses’ located in the top then click on the spreadsheet’s green icon

3- Select whether you want to a create a new spreadsheet for responses in Google Sheets or use an existing spreadsheet.

4- Click on create.

Remember, “You can find the response spreadsheet in the Google Sheets homescreen, the Google Sheets app, or in Google Drive.”

Leave a Reply