Skip to Content

Forms-Creating, Editing and Viewing Results

Creating forms

Creating a form from your Docs list
Creating a form from a spreadsheet

Editing forms

Add items to your form
Adding pages
Allowing navigation to a specific page and adding general page navigation

Your form questions

Embedding a form

Viewing form responses

Viewing the summary of responses
Editing the spreadsheet with the responses


Creating forms

You can create a form from the Docs list or from any spreadsheet.

Creating a form from your Docs list:

1. Click Create new > Form.
2. In the form template that opens, you can add any questions and options you’d like.
3. Click Email this form once you’ve finished adding your questions.
4. Add the email addresses of the people to whom you want to send this form.
5. Click Send.

Creating a form from a spreadsheet:

1. Click the Tools drop-down menu, scroll to Form, and select Create a form.
2. In the form template that opens, you can add any questions and options you’d like.
3. Click Email this form once you’ve finished adding your questions.
4. Add the email addresses of the people to whom you want to send this form.
5. Click Send.
6. The next time you open the form, a Form menu will appear in the menu bar.

Back to Top


Editing forms

Add items to your form

You can add different types of questions to your forms by clicking Form in your spreadsheet and Add item at the top of the editing page. Here are some of the question types you can choose: checkboxes, grid, drop-down lists with options, multiple choice, paragraph text, which allow for long answers, and scale, to ask your invitees to grade something in a scale from 1-5, for instance.
Add section headers if you’d like to divide your form in sections to make it easier to read and complete. Simply select Section header from the Add item drop-down menu.

Each section header can have a title, which appears in a larger font, and a section description.

Adding pages

If you’ve created a long form, for example, and would like to make it easier for your respondents to fill it out, you can add page breaks. From the Add item drop-down menu, select Page break.

Once you’ve created a form with multiple pages, you can add different sets of questions based on a previous answer within the form, and allow people to skip irrelevant sections.
Multiple choice questions with the ‘Go to page based on answer’ option enabled direct form respondents to particular pages based on their answer, whereas page navigation automatically routes form respondents to a specific page based on your selection. For example, you can create a form asking your respondents to select their language and then direct them to questions written in their language. Then, they can all be automatically routed back to the same page using page navigation in page breaks.

Click here for steps to allow navigation to a specific page (by including a “Go to” question in your form )
Click here for steps to include page navigation in your form

Once you’ve set up these options, you can send out your form, and your form respondents will navigate to different pages on your form based on their answers in the “Go to” questions or your selections in the form page breaks.

Back to Top


Your form questions

Here are some of the things you can do with your questions:

  • Edit: To edit an existing question, just click the Edit button to the right of the question you want to edit.
  • Delete: To delete a question, click the Delete button to the right of the question you want to delete.
  • Duplicate: To duplicate a question, click the Duplicate button to the right of the question you want to duplicate.

Back to Top


Embedding a form

If you’d like to embed your form in a website or blog, after you create and save your form, click the More actions drop-down menu at the top of the form, select the Embed option, and paste the URL into your site or blog.

Editing tips:

  • You can edit the confirmation message that people filling out your form see after submitting their responses. Click the More actions drop-down menu at the top-right of the form, and select Edit confirmation.
  • If you’ve edited a form and need to send it again, click the Edit and resend button in the lower-left corner of the Share tab.

Back to Top


Viewing form responses

Viewing the summary of responses

To see the spreadsheet with the form responses, click See responses at the top-right of the form and select Spreadsheet. It’s a good idea to use the same name for the form and the spreadsheet, so you can quickly find both of them in your Docs list.
To quickly see how many users filled out a form and what their responses are, you can check the response summary. From your spreadsheet, go to Form > Show summary to view it.

The response summary page opens in a new window.
Note: As you’re reviewing the responses, keep in mind that you can’t prevent users from submitting a form more than once, so the same person may have submitted multiple responses. If you use Google Apps, however, you can choose to record the email addresses of people who fill out your form, and then easily identify any duplicate responses.
You can allow those who filled out your form to see a summary of the responses. Select the option ‘Let everyone see response summary’ in the ‘Edit confirmation’ window to make the summary viewable to everyone.


If you’d like to print your form responses summary, open your browser’s Print menu.

Back to Top


Editing the spreadsheet with the responses

Here are some changes you can make to the spreadsheet:

  • Insert columns to add your own content, such as calculations, notes, or lookups, next to form responses.
  • Add response data directly to the spreadsheet by adding rows above, below, or between your existing response rows. You can add data one row at a time, or paste it in in bulk. Rows you add will be absorbed into the table that stores your form’s data.
  • Insert new sheets or move sheets. Responses will continue to be automatically entered in the same sheet.

Some changes to your spreadsheet aren’t allowed, once your spreadsheet is storing form responses in a table. This is so that you don’t make changes that would stop your spreadsheet from being able to read your form responses properly. For example, you can’t move columns in the table from side to side, since doing so would disrupt the structure of the table.

Back to Top

Leave a Reply

You may authenticate with your DuckID to leave a comment

Leave a Reply

You're logged in as (). Log Out
Posts will be attributed to , but your email is private.

Your email address will not be published.