How can I show the name or email address for responses to form survey in the results spreadsheet? We want to see each other's responses but results sheets seem to be anonymous and only show time stamps of responses, but no identifier.

  • Could you link to the form? – batpigandme Jul 10 '13 at 1:36

One way is to add a name/email-id field at the start of your survey. This helps identifying the responses.


Only Forms for Google Apps for Work or Education have an option to automatically record the username of the respondent but it's is limited to users of the same domain as the form creator 1.

One alternative is to add a question asking for the name of the respondent or any other information to identify them properly.

1: Additional forms options for Google Apps users - Docs editors help


You would need to create a field asking for a name or email address from the respondents.

Google Forms provides an Email validation if you want to an email address field.

enter image description here

For email:

  1. Select "text" for question type
  2. Click "Advanced Settings"
  3. Check "Data Validation"
  4. Select "Text" and "Email Address"
  1. In the top right hand corner of the screen, click the gear/cog icon to enter Settings:

enter image description here

  1. Next, tick the box next to the option Collect email addresses:

enter image description here

  1. Click Save.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.