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

Sample Data 2

  • At least two column should be there in selected a sheet.
  • Sheet data must match the following pattern i.e first column contains questions/fields and second column contains types and third column onward applicable only when if you want types as Checkbox, Dropdown or Multiple choice then it expects options refer the sample data 1 or If you want type as Image then it expects image URL refer the sample data 2.

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

  • Select source as "Google Sheet"
  • After selecting Google Sheet you can see a Choose Sheet Button
  • 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 Choose Sheet 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 or Quiz pattern
  • Enter range, default range will be A2:E10 i.e first 9 rows of a selected tab
  • check/select the Data include type column checkbox
  • We can use delimiter only when one cell has multiple options with a separator (example: ",")."
  • click on 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.
  • 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

  • Select the source Sheet from drop-down
  • select the Range and enter the range, default range is A2:F10 i.e first 10 rows of your sheet.
  • Select the Q & A's pattern
  • check/select the Data include type column checkbox.
  • We can use delimiter only when one cell has multiple options with a separator (example: ",")."
  • click on 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.