17
The Center for Instruction and Technology
Last Updated: 6/7/2017
Edit Form in Spreadsheet
• Choose Form > Edit Form.
See Revision History in Spreadsheet
If you have edited the form data in the spreadsheet view, and would like to review the revision
history, choose File > See revision history.
Duplicate Form in Spreadsheet
Sometimes, you might want to use an existing form as a base template, where you can modify it
slightly and save it for another purpose. In this case, you can duplicate the form.
1. In your form, choose File > Make a Copy to copy the existing form.
2. Then, Rename your form. Select ‘Share it with the same people’ if desired.
Spreadsheet Data
If you remove a question from the form, the previous data and the column will NOT be deleted
from the spreadsheet, but of course, the column will no longer be filled with any new data.
If you add a new question to your form, a new column with new form data will be added into the
spreadsheet automatically.
Monitor for Multiple Submissions
As you're reviewing the responses, keep in mind that you can't prevent users from submitting a form
more than once (unless you have required login for response), so the same person may have
submitted multiple responses. If you use Google Apps, however, you can choose to record the email
addresses of people who fill out your form, and then easily identify any duplicate responses.
Share Spreadsheet data
1. From your spreadsheet top menu, choose File > Share.
2. Add collaborators emails to allow them to View, Edit or Comment on your form data in
the Sharing Settings.