Use multiple choice when respondents should select exactly one option and the list is short enough to show on the page.
Multiple choice from Sheets
Google Forms multiple choice from Google Sheets
Google Forms multiple-choice options can come from a Google Sheets source list, but Forms does not keep them live-linked by default. Use this page to choose between manual paste, Apps Script, and FormRanger's no-code update path.
Quick answer
Put the options in one clean Sheets column, map that column to one Google Forms multiple-choice question, run Preflight, click Update now, and check the respondent-facing preview before sharing the form.
When multiple choice is the right field
Good examples include class rosters, teams, locations, departments, sessions, categories, products, or program names.
Multiple choice keeps the options visible, which helps when respondents need to compare a few choices quickly.
If respondents can select several values, use a checkbox question instead of multiple choice.
Three ways to update the options
Manual paste
Simple, but easy to forget
Copy values from Sheets and paste them into the multiple-choice question. This works for one-time forms, but every spreadsheet change requires another manual edit.
Apps Script
Flexible, but needs an owner
A script can update choices, but someone must maintain spreadsheet IDs, form IDs, authorization, triggers, and error handling.
FormRanger
No-code update path
FormRanger lets you select the source spreadsheet, choose the sheet tab and column, link a question, run Preflight, and update the choices.
First-run proof
Verify before production
Use a copied form first. A good test ends with the public preview showing the expected sheet values, not just a saved mapping.
FormRanger first-run path
- Create a copied Google Form with one multiple-choice question.
- Create one Google Sheets column with obvious values such as Alpha and Beta.
- Open FormRanger in the Google Forms editor and select the spreadsheet source.
- Choose the sheet tab, source column, and multiple-choice question.
- Run Preflight and fix any source, access, empty-column, or question-type warning.
- Click Update now and confirm the report says the question was updated.
- Open the public respondent preview and verify the choices match the sheet values.
Troubleshooting checklist
Check whether Update now actually ran. A saved mapping does not update the form by itself.
Re-select the sheet tab and source column, especially if columns moved or the header row changed.
Confirm the question is still multiple choice and was not deleted, duplicated, or changed to another type.
Open the public respondent preview after the update. The editor view is not the final proof.
Limits and cautions
FormRanger updates owner-controlled Google Forms choice lists. It is not a booking system, inventory lock, payment flow, or respondent-time dependent dropdown engine. If each option has a hard capacity, pair the choice list with a separate capacity-control workflow.
FAQ
Can Google Forms automatically sync multiple-choice options from Sheets?
Not natively as a live link. You can copy values manually, maintain Apps Script, or use FormRanger to run a controlled update from a selected Sheets column.
What is the safest first test?
Use a copied form, one multiple-choice question, and a Sheets column with Alpha and Beta. Run Preflight, update, then check the public respondent preview.
Can I use the same sheet for dropdowns and checkboxes too?
Yes. FormRanger supports dropdown, multiple choice, checkbox, multiple-choice grid, and checkbox grid choices.
Should I ask users to review the add-on after installing?
Wait until one real update succeeds and the public preview shows the expected choices. Successful setup is the right moment for an honest Marketplace review.