How to make Grid Questions in Google Forms

Google Forms grid question type is excellent for Matching/Selection//Ranking type questions. In this article, we will show you how to use the two kinds of grid questions (Multiple choice and Checkbox) and provide a Form with examples you can start using today.  

To start, add a question to a google form using the plus button and then change the question type to Multiple choice grid.

Adding a question to a Google Form
Selecting the Multiple choice grid type

The question screen shows Rows (Options/Answer) and Columns (Topic/Question) that can be added in any amount.  The example below shows a three-row by four-column grid question.Editor 2

My favorite use of the Grid question type is for matching questions. You can use these at all levels, and it is an easy way to convert traditional worksheets into a digital version.

You can also enable the quiz setting and select answers so students can receive feedback after they submit their responses or have their score automatically added to Google Classroom. I recommend placing the answers/options in the rows and identifiers (Letters or Numbers) in the columns. This helps phone users scroll down rather than use the less convenient slider at the bottom of the question to select a choice. Below is a matching question converted to a grid multiple choice question. The link to this example Form is here.

The options I choose for most grid matching questions are require one response per row and limit to one response per column, as shown below.

Selecting options for Multiple Choice Grid type question

I also use the grid question type for selection type questions. The link to a Form with these questions is here. The next example uses a Multiple choice grid question and asks respondents to select an available time slot or indicate they are not available. The Multichoice grid only allows one response per row, and I also require a response in each row.

In the preview mode this question looks like the following:

The format can be changed so TOPIC/QUESTIONS are on the TOP/COLUMN, and OPTIONS/ANSWERS are in the SIDE/ROW.  This is the option I use since it requires less scrolling on smaller screens.  In the example below, I limit responses to one response per column using the three dots ( ⠇) menu but allow multiple responses per row.  Anytime you are allowing multiple responses per ROW, you need to use a Checkbox grid.

pasted image 0 21

And the preview for this question looks like the following.

pasted image 0 20

The last version of this question is a checkbox grid with no restriction on the number of responses in ROWS or COLUMNS.

pasted image 0 27

The last use we show in this article is RANKING questions using the grid question type.  A form with the ranking question is here.  Below the students select their favorite kind of ice cream on a 1 to 5 scale.  

And the preview for this question.

pasted image 0 25

When choosing between the MC or Checkbox grid type, this table may help.  The quick answer is to use the MC if you want only one response per row and Checkbox to allow multiple responses per row.

pasted image 0 26

*Option shown at bottom of question:

pasted image 0 24

Our goal at Sharingtree is to help you share and collaborate with educators from around the world.  If you have a matching, selection or ranking example, use our “Add a collab” feature to share it today.

Use this link for MATCHING forms

Use this link for SELECTION forms

Use this link for RANKING forms

Then just click on “Collabs” or “Add a Collab” to share your version.

Leaf Google Forms Grid Question for SELECTION

We hope you found this article useful and reach out to us with any questions using

Using Form Builder to turn a Google Sheet/Doc into a Form

Form Builder helps you to build a Google Form in a fast and straightforward way by importing fields/questions/answers from a Google Doc or Google Sheet. Google Forms are flexible and can include questions, text sections, images, or videos. You can always build a survey or quiz directly in Google Forms, and lots of videos show this process. The additional options I wanted to share are creating a Google Form from a Google Doc or Sheet. 

Part 1: Google Doc to Google Form

If you have a survey or quiz as a Google Doc, you can “import it” to Google Forms using the Form Builder add-on. I’ll show this process using a Google Doc with a student info section followed by four questions. 

Example Google Doc

Next, you navigate to Add-ons from the top toolbar and select ‘Get add-ons‘ or ‘Form Builder for Docs -> Start‘. 

Starting or Get Form Builder Add-on

From here, I made two videos showing the process of Getting the Add-on and using it.

If you want to download and follow along with the videos, I made a group in SharingTree with the Google Doc, Google Form, and video links. Just click “Open” to have everything added to your Google Drive so you can follow along and modify to make your own Google Form from a Google Doc.

Group in SharingTree with Google Doc, Google Form and Links to Videos

Once you click ‘Open‘, a folder is added in your Google Drive with the Google Doc used in the video, the matching Google Form, and a Google Sheet with links to the How-to videos

Files in your Google Drive after ‘Open’

If you have any issues or suggestions, the developers of Form Builder can be reached here and are very responsive. 

Part 2: Google Sheet to Google Form

Using a Google Sheet provides the ability to set many Google Form options like the question type, point value, required options. This ability makes writing questions in Google Sheets much quicker than entering each one in Google Forms directly. I made a Group with templates and videos for this section as well if you want to try them out. We start with the Google Sheet shown below.

Google Sheet Template

When you use a Google Sheet Form Builder uses a feature called ‘Automatic Mapping‘ to identify the type of field/question/answer based on the column heading. The Google Sheet template I used has a number of these options set, and clicking the link above shows you all the possible options. The complete list of question types Form Builder supports is below. 

From Builder for Sheets – Supported Question Types

The magic happens in Form Builder when you check the ‘Range includes header‘ option, and your fields/questions are automatically recognized. I again made two videos showing the process of Getting the Add-on and using it.

Selecting options in Form Builder for Question/Field Import

If you make a Google Form from a Google Doc or Sheet and Form Builder, it would be helpful to share both as a Group in SharingTree so users can easily edit and then submit their version as a Collaboration. Our goal at SharingTree is always to help you share and collaborate with others. Let us know at if you have any questions or suggestions.

Up ↑