Monday, May 26, 2014

Google Drive - Surveys and public spreadsheets

A real quick how to on setting up a spreadsheet for public editing and setting up a quick form for data entry....

Public Spreadsheet

  1. go to
  2. click create and make a new spreadsheet
  3. Top left will say "untitled spreadsheet" - click there and give it a name.
  4. Edit your spreadsheet as required
  5. Goto File menu then select Share...
  6. Middle of the pop-up should say "Private only me" with a link to the right "change"
  7. Click change 
  8. Change to visibility to "Anyone with the link"
  9. Change access to "can edit"
  10. Click save
  11. Click gmail icon near the top to email out the link


Sometime you want to get one-way input...  Fairly straight forward - it's less steps

  1. go to
  2. click create and make a new form
  3. It will pop up to ask for a title and a template
  4. Add questions for everything you want to track some tips:
    1. Make sure to pay attention to the "required question" option on each question
    2. Don't forget to ask for the name
    3. Multiple choice works even for yes/no/maybe questions as it forces one answer
  5. Click send form when finished
  6. It will ask for a email to send to and then click done.
  7. It will automatically create a spreadsheet to store all the responses

No comments:

Post a Comment