Collect Data into Google Sheets | Forms, Quizzes, Surveys

You can gather data into your spreadsheet from users without them ever seeing or using your spreadsheet. Learn how to use Google Forms to get the data and bring it into Google Sheets for analysis.

🕒 Timestamps:
0:00 Intro
0:35 Create a Form
1:07 Create your questions (different types)
4:37 Send the survey
5:14 Send by email
6:00 Send by link
6:17 Embed
7:05 Back to Sheet

Send me a message for your unique 20% off code at
Twitter: @ProlificOaktree
This code is valid in "The Americas."

The first link in the description is an affiliate link. If you sign up for Google Workspace using this link, I will receive a commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!

Learn more from Prolific Oaktree:

#googleforms #googlesheets #survey

[LazarusStr]

Thank you so much for doing this! With this whole Covid-19 situation, a lot of people are trying to learn how to create things to make their remote work easier and organized. I was going to do a very bare-bones spreadsheet but wanted to push myself to learn something new. You explained everything clearly and made me feel at ease with the process. Truly, thanks a bunch!! 🤗💐

[pamkrueger]

Thank you for taking the time to explain how to use Google Forms. Very helpful!

[nhnka]

Thank you so much! You taught everything I didn't know. Terima kasih ❤

[laureng]

Thank you! Can one individual fill out more than response? Trying to create a daily checklist that records the answers each time.

[by]

Thank you for this tutorial! Saved me so much time.

[maluborja]

This was really very helpful! Thank you very much for sharing this. For some reason, I could not view the excel spread sheet where the responses go. Please teach where to find it. Thank you.

[elizabethhughart]

OMG!!! What an awesome, clear, succinct

[ravikiran]

Its Very Good Understandable Video. Thank you very much sir

[sreehari]

Thanks for making this video and it's very helpful

[MrViciousway]

Thanks! 🙏 Have a potential client that wanted to know if it was possible to add a questionnaire/survey to a website, that exports data to a spread sheet. Straight forward video, Everything you want and more 👍🏼

[BethMHB]

Thank you for this. Is there any way to format how the data appears on the Google Sheet? For example, the answers I send through my Form show up on the Sheet as Arial font, size 10. I'd like the font to automatically be larger for staff accessibility. Is that possible?

[theharrisenglishlearningpo]

Thank you for the video. Is it possible to import grades from a multiple-choice Google quiz into a spreadsheet? If so, could you make a video on that?

[JamesBHL]

Very useful video. Just a question, can the same respondent fill-in the form multiple times with different data? Will it still be captured in Google Sheet? I'm trying to gather info about hundreds of premises which are managed by dozens of managers. One manager might managed 10-20 premises. So, can one manager key-in the info for multiple premises?

[catherinenamoc]

How to create dashboard by that data? can you make a video?

[jamiemorse]

I have a question. I have 7 rows (day of the week) and 3 columns (three different weeks). When opening the data in a spreadsheet it does not differentiate between the data in column 1, 2 and 3. It lumps them all together on one row. How do I get a separate response for each column? Thanks!

[harshavardhanreddy]

Hey Buddy your video is very helpful Thanks for the video
I have one doubt, is there anyway that when user select multiple check boxes for one question, I have to get all the answers in spread sheet into single cell by cama( ', ' ) separated

[staninjapan]

Thank you.
About the form-in-an-email function...
If the recipient has email other than Google Mail, does this function work?
It is dependent upon recipients being Google account holders?

[mjngltn]

Great video, thank you. Is there any way to get additional information if the user answers No to a question?

[Ken-tsex]

If I just wanted to use the form to collect my own personal data would I need to email it to myself everyday or is there a better way.

[nanasuryana]

Thank you for share the video.... Did you have script for "sms to spreadsheet"?. I want to receive sms only on spreadsheet