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.
  • 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: ",")."
  • 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.