Collect Form Data in Google Sheets

You can use Google Drive to create public forms for collecting and organizing data:

From within a Google Docs spreadsheet, click on the Tools menu and select Create a form.

Click image to enlarge

Click image to enlarge

You can create your form question by question using the prompts provided:

Click image to enlarge

Click image to enlarge

When you’re done, Google Sheets will offer you the chance to save the form and mail it to a list of people, and/or share it via social media:

Click image to enlarge

Click image to enlarge

Your email subscribers will find the active form directly in their inbox, along with a public URL they can alternatively use to find the form:

Click image to enlarge

Click image to enlarge

Each completed and submitted form will populate a new row on the original spreadsheet. (Note that the form responses will be in their own separate tab on the spreadsheet – see image).

Click image to enlarge

Click image to enlarge

Now you can use all of the spreadsheet’s tools to work with the incoming data in any way you wish.

You might want to now check out this post on validating user data in your forms.

In this post we’ll look further into forms, specifically, storing forms in your Gmail account.

UPDATE: If you’re now using the new version Google Sheets, the screenshots may differ in some minor ways from what you see on screen; the sequence is pretty much the same, however.