Form Builder for Sheets
Setup
Demo Video: Form Builder for Sheets
How to setup Form Builder for Sheet
Note: If you prefer watching videos, please check our videos at How it works?
In order to start Form Builder for Sheet
Open a Google Sheet
click on Extensions => Add-ons => Get add-ons from the menu bar
From Extensions choose Form Builder for Sheets.
Click on Start to start Form Builder for Sheet
Build Form from Google Sheet
Consider you have the questions/fields for the form in a Google Sheet. And you want to build a Google Form using that data.
Choose any sheet from the drop-down to build a new Form or add new fields to the existing one.
You can refresh the sheet names by clicking on the refresh button
There are 2 type of Range type i.e Full(entire sheet range) and Range(given range).
If you want specified number of questions from the the sheet, you can select the Range and if you do not know the range then select Full.
There are 3 type of pattern i.e Questions, Question and Answer and Quiz
Below are the steps how to import from Questions, Question and Answers and Quiz
How to import from questions?
Choose any sheet from the drop down to build a new Form or add new fields to the existing one.
Select the Range type i.e 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:A10 i.e first 9 rows from column A of selected tab
Select the Questions from pattern
Click Get button
In questions pattern type every cell in a sheet is consider as question.
Form Builder lists all fields and makes fields available for you to import.
You can change the range and hit GET button to refresh the list of fields/ questions.
Below is the sample data you can see the pattern.
Hitting on the Get Button will automatically create questions.
Choose any Form or create a new Form to build a new Form or add new fields to the existing one.
After selecting the Form you can see the Form name just below the Change and Create button.
You can access the selected Form by clicking on the Open in New icon.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option type items from the listed question to some other options type you can achieve this by selecting options from the Make options as drop-down.
The default type of each question is the short answer in the question pattern
If you want to change the type you can change it in two ways
The first method is by simply selecting from drop down.
The second method is by clicking the setting icon.
You can import individual fields by clicking on the Action button.
You can also import the selected fields by clicking the Import Selected button.
You can Preview the questions and answers by clicking on the Preview Button.
There are some types in the Form API such as VIDEO, and FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
Sample sheet data
In questions pattern type every cell in a sheet is consider as question.
First row to be expected as header in a sheet.
If you select the range type as Range, by default the first 9 values of column A cell values will be selected excluding header.
If you select the range type as Full by default the entire sheet cell values will be selected including header.
Default type of every question is short answer in questions pattern.
How to set Configuration
Configuration example:
For example, consider the question type is a short answer and if you want to change to multiple choice you can easily change its type or even its option values also can be easily changed.
If the question is fully configured then the setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its considered as fully configured.
If you want more fields, you can get them by selecting another Sheet and doing the same steps again.
That's it, your Form is ready.
How to Import from questions and answers?
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 the default range will be A2:F10 i.e. first 9 rows from the selected tab.
Select the Questions and Answers from the pattern.
Select the Questions column from the dropdown.
If your sheet has a types column then select the types column from the dropdown.
If your sheet has a 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 has a 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.
You can change the range and hit GET button to refresh the list of fields/ questions.
choose any Form or create new Form to build a new Form or add new fields to the existing one.
After selecting or creating the Form you can see the Form name just below the Change and Create button.
You can access the selected Form by clicking on the Open in New icon.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
The default type of each question is either short answer or multiple choice in question and answer pattern.
If question has options then its type is multiple choice else short answer.
If you select the type column then specified type will to set to the questions.
If you want to change the type you can change in two ways
First method is by simply selecting from drop down.
Second method is by clicking setting icon.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
There are some types in the Form API such as VIDEO, FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
If you want more fields, you can get it by selecting another sheet and do the same steps again.
That's it, your Form is ready.
Sample 1: sheet data
Form Builder automatically lists all fields. you just need to tell the Form Builder which column is what in sheet.
Select "Range include header" to apply Automatic Mapping. This will set fields configuration automatically.
In the above sample data column B contains the all the questions.
You can see column C contains different types. if type is not matched then default type will be short answer.
Column D is staring column of answer.
Column F is ending column of answer.
Column G is required column.
If sheet have Type as Scale. It expect 4 comma separated value from answer started column of first cell. syntax is [lower-bound, upper-bound, lower-label,upper-label]. you can see the Rating question is type of scale it is having 4 comma separated values in one cell.
Lower-bound value is either 0 or 1 and upper-bound values will be between 3 to 10.
If sheet have Type as Grid(Multiple choice grid) or Checkbox Grid. it expect rows and column values.
Provide comma separated row value in first column of answer start cell and column values comes immediate next cell as above sample data
Sample 2: sheet data having multiple answer in one cell
It is also possible that one column have all options.
You can see the column B have multiple value separated by comma.
To import this format you need to check the delimiter and provide the delimiter.
In this sample data delimiter is "," and default delimiter is also ",".
You just need to check this delimiter and enter whatever delimiter you have in your sheet. Before clicking the GET button .
If you did not check the delimiter or enter wrong delimiter it will make only one option.
How to set Configuration
Configuration example:
Example consider question type is multiple choice and you want to change to Drop down you can easily change its type or even its option values also can be easily change.
You can change the type either in main GUI just by selecting any type from drop down or in configuration setup drop down.
Using configuration is best practice. you can see the all the configuration before import.
If the question is fully configured then setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
That's it, your Form is ready.
How to Import from Quiz
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 A1:k10 i.e first 9 rows from the selected tab.
Select the Quiz 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: ",")."
Form Builder lists all fields. you just need to tell the Form Builder which column is what in sheet.
For example type column. In the sample data type column is present at Column B. Like this you need to configure however you needed such as points, correct answer etc.
If you want to set advance properties such as correct answer feedback, incorrect answer feedback, correct answer URL and incorrect answer URL.
Click on advance button to set these properties and select the appropriate column.
click on GET button to lists all fields.
Form Builder lists all fields and makes fields available for you to import
choose any Form or create new Form to build a new Form or add new fields to the existing one.
After selecting or creating the Form you can see the Form name just below the Change and Create button.
You can access the selected Form by clicking on the Open in New icon.
Select the Overwrite Form Content. All existing content from the form will be overwritten when you import fields.
If you like to change option types items from listed question to some other options type you can achieve by selecting options from Make options as drop-down.
You can change the range and hit GET button to refresh the list of fields/ questions
If you want to change the type you can change in two ways
First method is by simply selecting from drop down.
Second method is by clicking setting icon.
You can import individual field by clicking on the Action button
You can also import the selected fields by clicking Import Selected button
There are some types in the Form API such as VIDEO, FILE_UPLOAD. these are unsupported types in Form Builder so you can not import these fields.
If you want more fields, you can get it by selecting another tab and do the same steps again.
That's it, your Quiz Form is ready.
How to set Configuration
Configuration example:
Example consider question type is multiple choice and you want to change to Drop down you can easily change its type or even its option values also can be easily change.
You can change the type either in main GUI just by selecting any type from drop down or in configuration setup drop down.
Using configuration is best practice. you can see the all the configuration before import.
If the question is fully configured then setting icon color will change.
Example of fully configured. Consider the question has multiple choice and its required is checked then its consider as fully configured.
If you want more fields, you can get it by selecting another tab or by changing the Sheet itself and do the same steps again.
Sample 1: quiz sheet data
Form Builder automatically lists all fields. you just need to tell the Form Builder which column is what in sheet.
Select "Range include header" to apply Automatic Mapping. This will set fields configuration automatically.
In the above sample data column A contains the all the questions.
You can see column B contains different types. if type is not matched then default type will be short answer.
Column C is staring column of answer.
Column F is ending column of answer.
Like this you need to configure however you needed such as points, correct answer etc.
If you have multiple correct answers in a sheet put "," comma between correct answer.
If you have multiple correct URL links or incorrect URL links in sheet put "," comma between URL links.
"," comma is default delimiter or separator in correct answer and URL links.
If sheet have Type as Scale. It expect 4 comma separated value from answer started column of first cell. syntax is [lower-bound, upper-bound, lower-label,upper-label]. you can see the 8th question is type of scale it is having 4 comma separated values in one cell.
Lower-bound value is either 0 or 1 and upper-bound values will be between 3 to 10.
Enjoy simplified Google Form Building !