Create and share your work online
Features: Creating forms in Google Spreadsheets |
t |
You can create a form from any spreadsheet in Google Just follow these instructions:
- Open a new spreadsheet in Google
- Save the spreadsheet in Google
- Click the Share tab.
- Under 'Invite people:' choose the radio button to fill out a form.
- Click Start editing your form... In the form template that opens, you can add any questions and options you'd like.
- Click the Preview and send tab. Here, you can add email addresses, a custom confirmation message, and choose whether you want people to see the responses.
- When you're finished, click Send.
Here are some additional tips:
- If you've edited a form and need to send it again, click the Edit and resend button in the lower-left corner of the Share tab.
- To see the results of a form, open the original spreadsheet. It's a good idea to use the same name for the form as your spreadsheet, so it's easier to find.
- To turn off a form, go to the Share tab of your spreadsheet and click Turn off form in the lower-right corner.
- Remember, the spreadsheet row, cell and column limits apply to the spreadsheets attached to your forms too.
Use Google Spreadsheets to Conduct Surveys
You can take advantage of the spreadsheet forms feature to conduct surveys and collect other customer data. Here’s the scoop straight from the Google Docs Blog:
Create a form in a Google Docs spreadsheet and send it out to anyone with an email address. They won’t need to sign in, and they can respond directly from the email message or from an automatically generated web page.
Creating the form is easy: Start with a spreadsheet to get the form, or start by creating the form and you’ll get the spreadsheet automatically. Responses are automatically added to your spreadsheet. You can even keep a closer eye on them by adding the Google Docs forms gadget to your iGoogle homepage.