Readers: 44 | Updated: 03-22

Creating Forms with Google Spreadsheet [Office Tweaks]

Translate Into:

I always love doing things interactively, it helps me handle my daily tasks smoothly and with ease. Technology indeed has lots of things to offer in terms of automation, that’s why they are created.

Recently, I had this project that requires me to gather some substantial data from selected respondents to aid my proposed business plan. I know that there are paid survey forms online but I am looking for a free one. Arrghh, and free is everywhere but I feel not liking this free services. But, until I found out that Google Spreadsheets allows me to do that thing; in a clean, instant, and interactive approach. Oh, it’s free definitely.

Google Spreadsheet has this cool feature of creating forms, some sort of survey forms, that directly feeds respondent’s results to the spreadsheet.

The following are the simple steps on how to create a form. I also included some screenshots showing each steps to help you visually. The steps are taken from Google Docs Help Center:

  1. Open/Create a new spreadsheet.
  2. Save the spreadsheet.
  3. Click the Share tab.
  4. Under ‘Invite people:’ choose the radio button to fill out a form.google-docs-forms.jpg
  5. Click Start editing your form… In the form template that opens, you can add any questions and options you’d like.create-form.jpgdemo-form.jpg
  6. Click the Next, choose recipients tab. Here, you can add email addresses, a custom confirmation message, and choose whether you want people to see the responses.
  7. When you’re finished, click Send.

form-results.jpg

As you can see with the screenshot provided above, the results are populated in the spreadsheet you created. Thank you and I hope you too can try this one. Enjoy!

Tags: , ,



From The Blogs

Personal Growth, Career Planning

2007
Ten Recipes for Office Workers to Make a Fortune
1.       Extract a portion of money from your salary to deposit in the bank, it will be ok for 5%, 10% or 25%, nonetheless, do deposit;2.       Make clear where your money flow to every day, every wee... 查看全文

The Design blog

04-12
Teo stool and office nap system
Is it just me or is the market really flooded with stuff to help people sleep better in the office? Gosh, whatever happened to work ethics! If you are one of those people who are able to sleep much be... 查看全文

LifeDev

04-22
How to Take Great Breaks at the Office
photo credit: Adrià garcía Post written by Albert from Headspace. Most of us feel that we work too hard and that we dont have enough breaks during our working day. The time between 8am and 7pm is a bl... 查看全文

Success Begins Today

04-14
5 Quick Tips For Word 2007
When you first open Word 2007 for the first time, you’ll probably be surprised by the changes that Microsoft made to the user interface. Instead of the usual icons and menu selections, you are present... 查看全文

Coolbuzz

03-18
Addictive face morpher helps you kill valuable office time
I just spent the last three hours adding ungodly details to my boss’s already ungodly face with this amazing new Morphases Editor that lets you morph people’s faces. And I found that it was really... 查看全文

Internet Observation

05-22
Word2007的5个小窍门
当您首次打开应用软件Word2007,您可能会为微软公司在用户界面上所做的改变而惊讶不已。展现在您眼前的不再是过去通常用的图标和目录选择,取而代之的是崭新而流畅的界面,这个界面叫做Ribbon。用Of... 查看全文

Ririan Project

05-20
7 Painless Ways to Stay Healthy In The Office
So many people spend their health gaining wealth, and then have to spend their wealth to regain their health.- A. J. Reb Materi Note: This guest post was written by Ali Hale. Check out her website her... 查看全文

Personal Growth, Career Planning

06-03
Four Necessary Conditions for Office Workers to Ask for
Four Necessary Conditions for Office Workers to Ask for A Pay Rise in Foreign EnterpriseWhen begin to be an employee in foreign enterprise, many people will receive an employee rules book, one of whic... 查看全文

Personal Growth, Career Planning

03-29
13 Commandment For Office White Collars
Aiming at white collars,a notable boss of foreign corporation concludes 13 commandment,separately imaging with a kind of animal or object.Contrast it and see if you are the one threeinto. 1.Parrots th... 查看全文

The Design blog

03-09
Meguro Office Space by Nendo -- Eliminating the concept of partition
Aneezshaikh:The real idea behind Nendos Meguro Office Space concept is to provide a large, extensive and almost undivided office floor. Each module is separated from the other module with a thin parti... 查看全文
More Articles