Import Specific Field Types from Google Sheets

Google Form Question/Field Types

Google Form Provides different types of questions/fields that you can include in a form.

The following types are

  • Short answer

  • Paragraph

  • Multiple choice

  • Checkbox

  • Dropdown

  • Date

  • Time

  • Date Time

  • Linear scale

  • Multiple choice grid

  • Checkbox grid

  • Title and Description

  • Section

  • Image

  • Video

  • File Upload

Setup Google Sheet for Importing Specific Field Types

Sample Data :1

Supported List of Field Types

Field Type can be one of the following (Case insensitive)

Form Builder support following questions/fields type

  • TEXT

  • PARAGRAPH

  • CHECKBOX

  • DROPDOWN

  • MULTIPLE CHOICE

  • DATE

  • TIME

  • DATETIME

  • SCALE

  • TITLE

  • SECTION

  • IMAGE

Steps for Importing into Form using "Form Builder" add-on

  • Click on "Google Sheets"

  • After clicking "Google Sheets" Google Picker opens where you can choose any Sheet to build a new Form or add new fields to the existing one.

  • After selecting the sheet you can see the sheet name just below the apps button.

  • You can access the selected sheet by clicking on the Open in New icon

  • After choosing sheet, Form Builder will list all the tab name in Choose Tab, now you need to select the one of the tab name form Choose Tab

  • Select the Question and Answers pattern

  • Default range will be A2:E10 i.e first 9 rows of a selected tab

  • Select the Question and Answers from pattern.

  • Select the Questions column from the dropdown .

  • If your sheet have types column then select the types column from the dropdown.

  • If your sheet have descriptions column then select the descriptions column from the dropdown.

  • Select the Starting answer column from the dropdown .

  • Select the Ending answer column from the dropdown .

  • If your sheet have required column then select the required column from the dropdown.

  • Choose the Add other at column to add the Other options to the multiple choice and checkbox fields.

  • We can use delimiter only when one cell has multiple options with a separator (example: ",")."

  • You can refer the sample data below.

  • You can change the range and hit GET button to refresh the list of fields/ questions

  • Form Builder lists all fields and makes fields available for you to import.

  • If you enter proper or supported type it will get correct question otherwise invalid type will be consider as Text.

  • Form Builder have an option to configure rapidly type (for example If you want drop down , in place of Multiple choice.

  • Choose the position where the fields need to be imported.

  • You can import individual field by clicking on the Action button.

  • You can also import the selected fields by clicking import Selected button.

  • That's it, your Form is ready.

Steps for Importing into Form using "Form Builder for Sheets" add-on

  • Choose any sheet from the drop down to build a new Form or add new fields to the existing one.

  • Select the Range type Full or Range.

  • Full is selected by default i.e full range of the sheet. If you select the Range then default range will be A2:F10 i.e first 9 rows from the selected tab.

  • Select the Question and Answers from pattern.

  • Select the Questions column from the dropdown .

  • If your sheet have types column then select the types column from the dropdown.

  • If your sheet have descriptions column then select the descriptions column from the dropdown.

  • Select the Starting answer column from the dropdown .

  • Select the Ending answer column from the dropdown .

  • If your sheet have required column then select the required column from the dropdown.

  • You can use delimiter only when one cell has multiple options with a separator (example: ",")."

  • Choose the Add other at column to add the Other options to the multiple choice and checkbox fields.

  • Below is the sample data you can see the pattern.

  • Form Builder lists all fields. you just need to tell the Form Builder which column is what in sheet.

  • Click Get button

  • Form Builder lists all fields and makes fields available for you to import.

  • If you enter proper or supported type it will get correct question otherwise invalid type will be consider as Text.

  • Click on Choose button to add question/fields to the selected form.

  • Click on Create button and enter the form name to build a new Form and adds questions/fields to the new form.


  • After Selecting/Creating the form you can see the form name appearing just below the Choose/Create button.

  • You can access the selected/created form by clicking on the Open in New icon

  • You can import individual field by clicking on the Action button

  • You can also import the selected fields by clicking Import Selected button.

  • That's it, your Form is ready.


Form generated with above data sample

Data Sample:

Form Builder For Sheet

Imported Form