Using Google Docs to create an online survey
Fabian Piau | Monday September 24th, 2012 - 10:01 PM
Recently, a friend of mine asked me how to create a survey easily for free. All the tools he has found were limited in their free version. I remembered that Google Docs provides such a feature. I used it some time ago and it worked pretty well.
That’s also a good idea for a new article. I will show you how to create a survey on Google Docs and how to consult its results.
First of all, go on the Google Docs application. Of course, you need at least a Google account. Then, create a new form.
Your new form shows up in edition mode. You can build your form by adding different type of answers to your questions :
- Short text
- Long text (paragraph)
- Multiple choice
- Checkboxes
- Choose from a list
- Scale
- Grid
Questions can be personalized, depending on the user’s answers. In my example, if the user answers that he likes computing, I’m asking him what programming language he prefers. You can do that by using pages into your form. If computing is selected, the next page is specific about computing, otherwise it is the next page.
In few minutes, I have finished my sample survey, let’s see how does it look! Simply click on the link generated below.
Here we are, you can test but don’t submit the form on the last page. This is not simply a preview, but the final survey!
Default plain theme is not very sexy, you can change it by returning to the edition mode and click on “Theme: Plain”. At this time, about a hundred themes are available, you will certainly find one that matches your needs.
Ok, let’s choose the disco theme.
That’s far better!
Your survey is now ready and you can send the link to all your friends.
Some days have passed, what about the participation? You can check the answers by opening your form again in Google Docs. It will open in the spreadsheet mode. The number of lines tells you how many people have answered to your survey. If you want to go back to the survey, click on Form → Go to live form. Note that it is still possible to modify the survey’s structure (Form → Edit form). Be very careful with that. Especially if some people have started to reply, you risk to mess up your data and the final result will not be good…
4 people have replied, Google provides a statistical preview of the result with some useful graphs. To access it, click on Form → Show summary of responses.
The results page is read-only. If you are not satisfied with this, you will have to export the results table, open it with your favorite spreadsheet processor and create your own graphs.
Other features exist such as making a question mandatory, adding an help text, sharing your survey on social networks, closing it, etc.
You can try the sample survey I have created for this post.













Follow me!