Google Forms Checkbox Grid: How to Build One (and When Not To)
Dvir Atias
Jul 14, 2026
Google Forms Checkbox Grid
A checkbox grid is a Google Forms question type that lays out a table of rows and columns and lets each respondent tick as many boxes per row as they want. It is the tool you reach for when a single row can have more than one true answer, such as asking which days each student is available, or which topics each parent wants covered at conferences. If every row should have exactly one answer, you want a multiple choice grid instead, which is the near-identical question type that uses radio buttons and allows only one selection per row.
That single difference, many answers per row versus one, is the whole decision. This guide shows what a checkbox grid does, how it differs from the multiple choice grid, how to build and constrain one, when it is the wrong choice, and how the answers land in your responses spreadsheet.
Checkbox grid vs multiple choice grid
These two question types look identical while you are editing them. Both give you a list of rows down the side and a list of columns across the top. The difference is entirely in what a respondent can do:
- Multiple choice grid shows a radio button at each intersection. A respondent can select only one column per row. Use it when each row is a single decision, like rating "The pace of the lesson" as one of Poor, Fair, or Good.
- Checkbox grid shows a checkbox at each intersection. A respondent can select several columns in the same row, or none. Use it when a row can be true in more than one way, like "Monday" being both a day the student has practice and a day they can stay late.
A quick test: read one row aloud and ask "could more than one answer here be correct at once?". If yes, use a checkbox grid. If the row is a single choice, use the multiple choice grid so respondents cannot accidentally pick two.
How to build a checkbox grid, step by step
- Open your form and add a new question with the plus button.
- Open the question type menu on the right and choose Checkbox grid.
- Fill in the Rows. Each row is one item you are asking about, such as a student name, a day, or a topic.
- Fill in the Columns. Each column is an option that can apply to any row, such as a time slot or a category.
- Type your question text at the top so respondents know what the grid is asking.
That is the entire build. The grid renders as a clean table, and respondents tap the boxes that apply.
Requiring a response and limiting columns
Two settings turn a loose grid into a disciplined one, and both live in the question:
- Require a response in each row. Toggle "Require a response in each row" so no row can be left blank. This is essential when an empty row would be ambiguous, because otherwise you cannot tell "not selected" from "skipped".
- Limit to one response per column. Open the three-dot menu on the question and turn on "Limit to one response per column". This stops two respondents from choosing the same column, which is exactly what you want for sign-up sheets where each slot can only go to one person. Once a column is taken, later respondents cannot select it.
You can also shuffle the row order from the same three-dot menu, which is useful when you do not want the row order to hint at an expected pattern.
When a grid is the wrong choice
Grids are tidy, but they are easy to overuse. A grid is the wrong choice when:
- You have more than a handful of columns. On a phone, a wide grid forces horizontal scrolling and respondents miss options off the edge of the screen. Long grids get abandoned.
- The rows are unrelated. A grid implies every row shares the same set of column options. If your questions each need different answer choices, use separate questions instead.
- You are building a graded quiz. A checkbox grid cannot be auto-graded cleanly, and packing several quiz items into one grid makes the answer key murky. For an assessment, keep each item as its own question. If you need a fresh set of quiz questions on a topic, a multiple choice test generator will produce individual, auto-gradable questions rather than one crowded grid.
When a grid starts feeling cramped, the honest fix is almost always to break it into a few plain questions.
How grid data looks in the responses Sheet
This is where grids surprise people, so it is worth previewing before you send the form. When you link responses to a Google Sheet, a grid does not become one column. Instead:
- Each row becomes its own column in the spreadsheet, with a header that combines the question and the row label.
- For a checkbox grid, a single cell can hold several column values separated by commas, because a respondent could tick more than one box in that row.
- For a multiple choice grid, each cell holds exactly one value, because only one column per row was allowed.
The practical consequence is that a checkbox grid with five rows adds five columns to your sheet, and any cell might contain a comma-separated list. If you plan to sort or filter the data later, know this ahead of time, because splitting comma-separated answers after the fact is tedious. When you only need one answer per row, the multiple choice grid gives you far cleaner, one-value-per-cell data to work with.
Quick answers
What is a checkbox grid in Google Forms? A table of rows and columns where respondents can tick multiple checkboxes in each row.
What is the difference between a checkbox grid and a multiple choice grid? A checkbox grid allows several selections per row. A multiple choice grid allows only one selection per row.
How do I require an answer for every row? Turn on "Require a response in each row" in the question settings so no row can be left blank.
How do I stop two people from picking the same option? Turn on "Limit to one response per column" in the question's three-dot menu, which locks each column once it is chosen.
Can a checkbox grid be graded automatically? Not cleanly. Grids are built for surveys and sign-ups, so use individual questions for anything you need to grade.
How does grid data appear in Sheets? Each row becomes its own column, and checkbox grid cells can contain several comma-separated values.
Ready to transform your documents?
Convert Google Docs, PDFs, and spreadsheets into Google Forms in one click.
Start free →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator
The bottom line
Reach for a checkbox grid when one row can have several true answers, and reach for a multiple choice grid when each row is a single choice. Keep the column count small enough to read on a phone, turn on "require a response per row" so blanks are never ambiguous, and use "limit one response per column" for sign-ups. Above all, remember that a grid is a survey tool, not a quiz tool. If you are assessing students, give each item its own question and keep your answer keys clean.
Ready to transform your documents?
Convert Google Docs, PDFs, and spreadsheets into Google Forms in one click.
Start free →Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator