Polls made easier with Google Docs Spreadsheet

Google Docs Spreadsheet makes it easy to create and run polls.

There are quite a lot of polling applications available on the web. Some of them are really useful but many of them are not and can be cheated. Instead of maintaining another account for running polls how about using Google Spreadsheet to create and run polls if you already have a Google account (you might already!)?

In this walk-thru let’s create a sample poll to get the opinions of some of DemoGeek.com’s readers to see if they would really prefer to see more of screencasts than screenshot based posts at DemoGeek.com and also to find out which topic they prefer the most.

Step-1: Sign in to Google Docs Account

Google Docs Sign-i

The basic, sign in to Google Docs.

Step-2: Create a New Form

New Form at Google Docs

Start by creating a new form by clicking on the “New >> Form" menu option.

Step-3: Poll Title and Description

Poll Title and Description

When the page loads up you should be able to see a similar page like the above screenshot. Couple of things make up a poll, a title, a description, the questions and answers. Start by giving the poll a title and a decent description.

Step-4: Create Questions and Answers

Questions and Answers for the poll

Now, it’s time to fill out the questions and the possible answers. Type-in a question title and help text and then choose the type of answers from the "”Question Type” dropdown list.

The possible Question Types are,

Question Types

For this example, let’s choose Multiple Choice as Question Type and type-in the answers as above. Once done click the “Done” button. If you want to make this question a required question then check the “Make this a required question” option.

Step-5: Add More Questions

Add More Questions

Let’s add one more question to our poll. Click on the “Add Question” button at the top of the page and then choose the type of question you want to add. Let’s choose Checkboxes question type this time.

Checkboxes type question

Once again, type-in the title, text and then type-in the answers for each choice. Once done click on the “Done” button.

Sample Poll at Google Spreadsheet

By now, your poll will look like the screenshot above and is ready to be send out.

Step-6: Send the Poll out

Email the Poll

Click on the “Email this form” button at the top of the page.

Email the Poll

Fill-in the email address to whom you want to send the poll and hit the “Send” button. The poll will now be emailed to the recipients and the sender will get an email from Google Docs acknowledging the sent poll.

Recipient View

Recipient View of the Poll

The recipient will receive an email similar to the above and will be able to pick their choice and can submit the poll by clicking on the “Submit” button.

Warning from Google Mail

You might get a warning similar to the above screenshot, just click on the OK button to continue submit the poll. That’s all you have to do to respond to the poll.

See the Poll Responses

After a while, the poll creator will obviously be interested to see the responses. It’s very simple to check the responses, sign-in again to your Google Docs account and then open the spreadsheet that has the poll title.

Form(1) menu at Google Docs

Click on the “Form(1)” menu and then click on the “Edit Form” menu option.

See Poll Responses

When the poll gets loaded click on the “See responses” button and then click on the “Summary” menu option.

Poll Response displayed at Google Docs

Google Docs will display the responses in a neat format with graphs to visually give you an understanding of the response.

Running polls with Google Docs is pretty simple and straight-forward. I hope you find it useful. If you have any questions regarding this please let us know in comments.

Technorati Tags: ,Google Docs and Spreadsheet,Create Polls,Polls with Google Docs,,,Google Docs Tips
Related Posts with Thumbnails


Subscribe to our free RSS feed to keep up with what's happening at DemoGeek.com

At DemoGeek.com we try to explain the tech stuffs in as much detail as we can to help the not-so-tech-savvy of our friends understand and follow the tech stuffs.

Share/Save/Bookmark

Subscribe to DemoGeek.com
Undo sent emails with Gmail’s Undo Send feature Tree Style Tabs reinvents Firefox Tabs

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

Leave a Reply





XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

8 Trackbacks/Pings

About DemoGeek.com

DemoGeek.com brings you high quality articles, tutorials and how to's on everything related to Microsoft Windows, Mac OSX, iPhone, Useful Websites, Browsers, Software and Programming.

At DemoGeek.com you'll find step-by-step explanation of the technical issues explained in detail with screenshots and screencasts. Read More...

Contact |  FUG |  Disclaimer

Creative Commons License

Canonical URL by SEO No Duplicate WordPress Plugin