Advertisement
Tech

Learn How to Create and Use Forms in Google Spreadsheets.

Google Docs makes it easy to survey large groups of people. Create your survey, and then distribute it by email or Web. Google Docs automatically logs data into a spreadsheet. You can then easily track who has answered and what they’ve said. Optional fields ensure recipients can remain anonymous.

By YvetteDavis
Desk Tech
Reading time 3 min read
Word count 467
Google Internet Google desktop
Learn How to Create and Use Forms in Google Spreadsheets.
Advertisement
Quick Take

Google Docs makes it easy to survey large groups of people. Create your survey, and then distribute it by email or Web. Google Docs automatically logs data into a spreadsheet. You can then easily track who has answered and what they’ve said. Optional fields ensure recipients can remain anonymous.

On this page

Google Docs Forms

Google Docs gives users an easy way to gather information from many people at once. By creating a Form, you can write each question one time, and then send the form to each person from whom you need a response. Forms will also help you analyze the information that you receive. Forms are great for research, human resources surveys and event planning

Getting Started

To open Forms and start creating questions:

Advertisement
  1. Log into your Google Docs account.
  2. From the menu, select New - > Forms.
  3. A blank form will open in a new window. In the text box labeled Untitled Form, type your desired Form Title.
  4. In the second text box, type directions for filling out the form and include any special information that the user may need.
  5. Question Title: Type your question here.
  6. Help Text: Add any additional information needed to answer the question.
  7. Question Type: Select the type of question that you need from the drop down menu. The rest of the section will change based on your selection. You can choose from the following question types:
  • Text
  • Paragraph Text
  • Multiple choice
  • Checkboxes
  • Choose from a list
  • Scale

Fill in any additional information like multiple choice answers, lists or items to scale.

multiple choice

Advertisement

If all respondents must answer this question, select the checkbox, Make this a required question.

When you’re finished with this question, click Done.

Advertisement

Adding and Editing Questions

To add questions, click Add Question in the upper left of the window. From the drop down menu, select the type of question that you’d like to add. Type the question information.

To edit a question, move your mouse over the question that you’d like to edit. On the right side of the screen, three icons will appear: a pencil, two overlapping rectangles and a trash can.

Advertisement

Distributing Your Survey and Getting Responses

In order for people to answer your survey questions, you’ll first need to make it available for responses. There are two ways to do this.

  1. Click Email this form in the upper right of the screen. Fill in the email address of each recipient, or select Choose from contacts to select from your Gmail address book. Click Send.
  2. Send recipients the unique Web address for your Form. You’ll find this Web address at the bottom of your screen in the black bar.

Getting responses

Advertisement

As people answer your survey, their responses will automatically be recorded by Google Docs. To access this data, do the following steps:

  • Open Google Docs.

    Advertisement
  • Open the file with the same name as your form

    data response

    Advertisement

    .

You will see results in spreadsheet form.

Advertisement

To access this information in the form of a pie graph, select Form - >Show Analysis.

get piegraph

Advertisement

That’s all there is to it. Taking surveys, asking questions and tracking invitees has never been easier!

pie graph

Advertisement
Keep Exploring

More from Tech

Filed under
Google Internet
More topics
Google desktop
Advertisement