How to add a multiple choice grid in Google Forms

Last updated September 2026 · ~8 minute read

Short answer: Click Add, type the question, choose Multiple choice grid, then fill in the rows (the things being rated) and the columns (the scale). Google documents three rules for it — Require a response in each row, Limit to one response per column and Shuffle row order. The middle one is not what most people assume, and it is the reason grids get sent out broken.

A grid — a matrix question, if you learned surveys somewhere else — asks one scale of every row at once. It is the most compact question type in Forms and the most expensive one for the person answering, so it is worth knowing exactly what it does before you put twelve rows in it.

Add the grid, step by step

1. Click Add to insert a question.
2. Type the question into the Question field. This text has to carry the instruction for the whole grid — “rate each statement” — because nothing else will.
3. Choose Multiple choice grid as the type. Pick Checkbox grid instead if a single row may legitimately have more than one answer.
4. Add your row options — the statements, items, sessions or people being judged.
5. Add your column options — the scale, applied identically to every row.
6. Open the rules and turn on only the ones you actually mean. They are covered below.

One scale serves the entire grid. If one of your rows needs a different set of columns, it is not a row in this grid — it is a separate question.

Multiple choice grid vs Checkbox grid

Google's question-type page is unhelpful here, and we would rather say so than tidy it up: it gives both grids the same one-line description — “You can create a grid where responders can select one or more answers per row.” The rules page is no better: the sentence “In multiple choice grid questions responders can only choose one column per row” opens both the Rules for Multiple choice grid questions section and the Rules for Checkbox grid questions section, unchanged, still naming the multiple choice grid. We checked it on the page. So Google nowhere states plainly that a checkbox grid takes more than one answer per row — build one, preview it, and tick two boxes in a row to see it for yourself.

If you are weighing up a checkbox grid against plain checkboxes for a single question, the checkbox question guide covers the non-grid version.

The two rules, and the one that surprises people

Require a response in each row

This is “required”, scoped to rows: every row must be answered, not merely one of them. Google's documented consequence is blunt — “If they don't, they get an error message and can't continue.” Use it when a blank row would ruin the analysis, and think about it twice on a long grid, because a fifteen-row wall that refuses to submit is a common place for people to abandon a form entirely.

Limit to one response per column

This is the one people copy in blindly and regret. It does not mean “one answer per row” — that is already how a multiple choice grid behaves. It means a column can only be used once in the whole grid. Google's documented consequence: “If they check multiple rows in a column, they get an error message.”

Combined with one-answer-per-row, that turns the grid into a one-to-one assignment: each row takes a different column, each column is claimed by one row. That is genuinely useful for a narrow class of question — assigning each person a different time slot, seat, shift or presentation order, where two people cannot have the same one.

It is wrong for almost everything else. On a satisfaction grid it tells a respondent who thought three things were “Excellent” that they may only say it once. They cannot answer honestly, they get an error they did not earn, and you never hear about it. If your columns are a scale, leave this off.

Shuffle row order

Google documents this for grids too. It randomises the order of the rows per respondent, which helps with order bias in long lists. Two cautions: it makes your form harder to talk about (“question 4, third row” no longer means anything), and shuffled rows are harder to follow non-visually.

Grading a grid in a quiz

Both grid types are in Google's list of question types that can be automatically graded — the full list is Short answer, Multiple choice, Checkboxes, Dropdown, Multiple choice grid, Checkbox grid. So a grid works as a quiz question: you set the correct column for each row and Forms marks it.

What Google does not document on that page is the per-row mechanics — how points divide across rows, or how a partly-correct grid scores. We are not going to invent it. Set your answer key, submit one test response yourself, and read the score before the class does.

What a grid looks like in the spreadsheet

The usual claim is that a grid becomes one spreadsheet column per row of the grid. We cannot source that to Google. Its help pages document grid questions in one place and the linked spreadsheet in another, and neither states how a grid maps onto columns. So: Google does not document it. The five-minute version of certainty is to link a test form to a sheet, submit one response, and look — that answers it for your form, which is the only form that matters.

When not to use a grid

This section is ours, not Google's. Google documents the grid as a question type and gives no guidance on when it is a bad idea. The following is our recommendation.

If your respondents may use a screen reader, split it

A grid is the hardest control in Forms to operate without sight. It asks somebody to hold a row label and a column label in mind simultaneously while navigating in two dimensions, and the row label is announced far from the option being chosen. A grid is almost always a convenience for the author — it makes a long survey look short — paid for by the respondent.

If the grid runs to more than a handful of rows and the audience might include screen reader users, split it into separate multiple choice questions, each carrying its full row wording in the title. The form gets longer and considerably easier to answer, and nothing about your data changes. Our Google Forms accessibility guide goes into this and into the documented alt text gap that sits behind it.

A wide grid means sideways scrolling on a phone

Most responses arrive on a phone. Seven columns that look balanced on a laptop become a grid that has to be scrolled horizontally on a 390-point screen, with the row label sliding out of view as the respondent reaches for the far column. They then answer from the wrong row. Keep columns to about five, preview the published form on an actual phone, and cut a column rather than shrink the question.

When the rows do not share one scale

If you find yourself writing a column set that fits eight of your ten rows, the grid has stopped being a grid. Two questions is not a defeat. And if the real job is constraining what people can type rather than what they can pick, response validation is the tool, not a matrix of options.

Frequently asked questions

What is the difference between a multiple choice grid and a checkbox grid?

Not from Google's documentation, which never says. The sentence “In multiple choice grid questions responders can only choose one column per row” opens the rules sections for both grid types, unchanged. A checkbox grid is the version that accepts more than one column in a row, but you will have to preview one to confirm it. Confusingly, Google's question-type list gives both grids the same one-line description — “You can create a grid where responders can select one or more answers per row” — so the difference is documented on the question-editing page rather than the question-type page.

What does Limit to one response per column actually do?

It stops a column being used twice in the same grid. Google's documented consequence is that “If they check multiple rows in a column, they get an error message.” That makes the grid a one-to-one assignment — one row per column and one column per row — which is right for allocating time slots or seats, and wrong for a rating scale, where every row is supposed to be able to score the same value.

Can a grid question be graded in a Google Forms quiz?

Yes. Google lists Multiple choice grid and Checkbox grid among the question types that can be automatically graded, alongside Short answer, Multiple choice, Checkboxes and Dropdown. Google does not document the per-row mechanics of a grid answer key on that page, so set the key in the editor and test the quiz with your own submission before you rely on the score.

How does a grid question appear in Google Sheets?

Google does not document this. Its help pages describe grid questions and the linked spreadsheet separately, and neither states how a grid maps onto spreadsheet columns. Rather than repeat a guess, link a form with a small test grid to a sheet, submit one response, and look — it takes a minute and it is the only answer that is true of your form.

Should I use a grid if my respondents may use a screen reader?

This is our recommendation, not Google's: split it. A grid asks somebody to hold a row label and a column label in mind at once while moving in two dimensions, which makes it the hardest control on a form to operate without sight. Separate multiple choice questions, each carrying its full row wording in the title, ask exactly the same thing and cost only length.