Creating Forms with Google Spreadsheet

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.
5. Click Start editing your form… In the form template that opens, you can add any questions and options you’d like.
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.

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!