how to create drop down list in google sheets

Add Options in Dropdown Lists & Multiple Choice QuestionsĬreate a Google Spreadsheet and add the question titles in the first row of the sheet, one per column. You can even create a time-trigger that runs every hour, day or month to dynamically update your form using the most current data available in the spreadsheet. The app will read the data from this Google Sheet and auto-populate the choices in the form with one click. We’ll have a Google Sheet that will be the data source and have all the answer choices for various questions in the Google Form.

In the previous example, some teachers may move out, new teachers may join in and the drop-down list in the form has to be updated manually every time there’s a change in the staff.Īuto-Populate Questions in Google Forms with Google SheetsĪs with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.

The question choices in the form may change with time.

For instance, the country down-down alone has a list of 250 countries and it would take some work for the form editor to manually type each choice in the question.

There’s too much data to enter and type in the form.

It is easy to create such a form inside Google Forms - here’s a sample form - but there are two issues:

The form would have a drop-down list of countries, the names of class teachers as a multiple choice question and a checkbox style question where students can pick one or more of their favorite subjects. Learn how to bulk add options in dropdown lists and multiple-choice questions in Google Form using values from Google SheetsĪn international school is building a Google Form where students can register their details.

How to create drop down list in google sheets