back arrowAll articles

6 Steps to Create a Multiple Choice Grid in Google Forms

Last Updated: Thu Apr 11 2024

Struggling to capture nuanced responses in your surveys or quizzes? The multiple-choice grid in Google Forms is your solution.

This versatile format, perfect for detailed feedback or complex questionnaires, transforms the way you collect data.

In this concise guide, we'll walk you through six simple steps to masterfully create a multiple-choice grid, enhancing your Google Forms experience.

Let's unlock the potential of grids together!

Steps:

  • Navigate to Google Forms and Open the Editor
  • Add a Multiple Choice Grid Question
  • Set Up Your Rows and Columns
  • Configure Your Settings
  • Preview Your Multiple Choice Grid
  • Explore Advanced Features and Integration (Optional)

Step 1: Navigate to Google Forms and Open the Editor

  1. 1. First, Go to the Google Forms website.

  2. 2. If you’re not already signed in, enter your Google account credentials.

  3. 3. Click on the “Blank” option or choose a template to start a new form.

Red arrow pointing towards the “blank” button of Google Forms.

4. Give your form a title and description. Your form will look like this without a title

Red arrow pointing towards the “untitled form” box.

For our article example, we are creating a Google Form with Multiple Choice Grid questions for a restaurant. This form will collect “Customer Feedback” from the restaurant customers.

Step 2: Add a Multiple Choice Grid Question

1. By default, you’ll have a question on your Google Form

Red arrow pointing towards the default question box.

2. Click on the drop-down arrow to open the dropdown menu.

Red arrow pointing towards the dropdown arrow of dropdown menu inside the question box.

3. From the drop-down menu, select “Multiple choice grid.”

Red arrow pointing towards the “multiple choice grid” option from the dropdown menu of the question box.

4. Enter your question in the provided field.

Red arrow pointing towards the question field without a question.

Continuing with our example from above, we will set the question for the customers of the restaurant: “How satisfied were you with the following aspects of your experience?”

Red arrow pointing towards the question field with an example question.

Step 3: Set Up Your Rows and Columns

Enter the items for your rows and columns. Rows could be statements or questions, while columns are the options that respondents can choose from. Ensure that your rows and columns are clear and concise.

Two red arrow pointing towards each “Row” and “Column” from the question box.

So the rows (basically statements or questions) will be like this (vertically) when the respondent fills up the form:

 Red arrow pointing towards all the rows from the question box.

And the columns (basically choices/options/answers) will be like this (horizontally) when the respondent fills up the form:

Red arrow pointing towards all the columns and the options from the question box.

Step 4: Configure Your Settings

1. Decide if you want to make the question required, meaning the respondent cannot submit the form without answering.

Red arrow pointing towards the “Require a response in each row” toggle button.

Configure any additional settings as per your requirements. We discussed each setting briefly in Step 6 (don’t forget to check out that).

Red arrow pointing towards the “Settings” tab.

Step 5: Preview Your Multiple Choice Grid

1. Click on the eye icon at the top of the screen to preview your form.

Red arrow pointing towards the eye icon at the top of Google Forms.

2. Ensure that everything appears as it should and that the grid functions correctly.

Mine looks like this after all the above steps:

Preview of a Google Form with a Multiple Choice Grid question.

Step 6: Explore Advanced Features and Integration (Optional)

6.1: Integrate with Google Sheets To Analyse Responses

How to Do It: Once you have created your form, click on the “Responses” tab:

 Red arrow pointing towards the “responses” tab.

Then click on the green Google Sheet icon to create a new spreadsheet that will be linked to your form:

 Red arrow pointing towards the green google sheet icon.

Impact: This integration allows for real-time data collection and analysis. You can view each response in a structured format, making it easier to identify trends, calculate averages, or perform other statistical analyses.

6.2: Shuffle Row Order

How to Do It: In the bottom right corner of your multiple-choice grid question, click on the three dots

Red arrow pointing towards the three-dot menu at the right bottom of a Google Form question.

Select “Shuffle row order”:

 Red arrow pointing towards the “Shuffle row order” option from the three-dot menu.

Impact: This randomizes the order of the rows for each respondent. This is particularly useful for quizzes or surveys where you want to minimize the order bias.

6.3: Add Section Headers and Descriptions

How to Do It: Use the "Add section" option from the sidebar to create different sections within your form. Each section can have its own header and description:

Red arrow pointing towards the “add section” option from the sidebar of a question in a Google Form.

Impact: This helps in organizing the form, especially if it's lengthy. It guides the respondent through the form, making it more user-friendly.

6.4: Customize the Confirmation Message

How to Do It In the “Settings” tab, go to the “Presentation” section, And edit the confirmation message:

One red arrow pointing towards the “Settings” tab. One red arrow points toward the “Presentation” section. One red arrow points towards the “Edit” button

3 Template confirmation message for Google Forms

  • Hooray! Your answers are zipping through cyberspace to us. Thanks for sharing your thoughts! Keep an eye out for what's next!
  • You've sparked our curiosity! Thanks for completing our quiz. We're already diving into your answers. Stay tuned for more adventures!
  • Your input is the seed of our growth. Thank you for taking the time to fill out our form. Watch out for how your ideas take root!

Impact: This allows you to provide a tailored message to respondents once they have submitted the form. Potentially directing them to additional resources, thanking them for their time, or providing the next steps.

6.5: Enable Quiz Mode

How to Do It: In the “Settings” tab, toggle the “Make this a quiz” button to turn the form into a quiz:

One red arrow pointing towards the “Settings” tab. One red arrow points towards the “Make this a quiz” toggle button

Impact: This is useful if you are using the multiple-choice grid for a quiz or assessment, as it allows you to assign point values to each option and provide automatic feedback to respondents.

FAQ

  • Q: What’s the difference between a multiple-choice grid and a multiple-choice checkbox?

    A: Multiple-choice grids in Google Forms allow only one selection per row, ideal for single-answer questions. Checkbox grids enable multiple selections per row, fitting 'select all that apply' queries.

  • Q: How do I create a multiple linear scale in Google Forms?

    A: To create a multiple linear scale in Google Forms, click the plus sign next to your question, and change the question type to 'Linear Scale' from the dropdown menu in the 'Multiple Choice' box.

  • Q: How do I format a checkbox grid in Google Forms?

    A: Format a checkbox grid in Google Forms by selecting 'Checkbox' in the Fields tab. Customize by adding rows/columns, editing options, and changing labels using the drag-and-drop builder.

  • Q: How do I add an image to a multiple-choice grid in Google Forms?

    A: To add an image to a multiple-choice grid in Google Forms, open your form, click on the desired question or answer, and then click 'Add image' on the right. You can then upload or choose an image and click 'Select' to finalize.

Vector