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
You can use Google Sheets and Forms for your business inside of Google Workspace (goo.gl/RhbaPv). Some benefits of Workspace include custom email, user administration, and more storage in Google Drive.
Send me a message for your unique 20% off code at
email: [e-mail]
Twitter: @ProlificOaktree
This code is valid in "The Americas."
Google Workspace Pricing: bit.ly/gsuitepricing
Google Workspace Editions: bit.ly/geditions
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:
🌳 Next Video - Google Sheets - Create an Interactive Task List - • Google Sheets - Create...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials
#googleforms #googlesheets #survey

[@pamkrueger493]

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

[@ProlificOaktree]

You're welcome. I'm glad you liked it.

[@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!! 🤗💐

[@ProlificOaktree]

No worries. I'm working on a bunch more distance learning related videos now!

[@LazarusStr]

@@ProlificOaktree Can't wait to check them out! 💖

[@vincentdomingo3484]

What happens if you submit 6 times into the google form? Will your email appear 6 times too?

[@sikimsuseni1801]

This was so helpful. I run an Influencer Marketing agency and I have been looking for a sign-up form for those that are interested in working with my company. This helped a lot, thank you so much for sharing.

[@ProlificOaktree]

Thanks, I’m glad you liked it.

[@nhnka]

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

[@iwansetiabudi1]

Sama sama

[@ravikiran2931]

Its Very Good Understandable Video. Thank you very much sir

[@keithevanson4448]

Easily understood, Thank you.

[@ProlificOaktree]

That's what I was going for. Thanks!

[@maluborja5939]

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.

[@by1907]

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

[@ProlificOaktree]

Glad to hear it!

[@laureng7523]

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

[@elizabethhughart6319]

OMG!!! What an awesome, clear, succinct tutorial!!!!!!!!!!!!!!!!

[@vincentdomingo3484]

What happens if you submit 6 times into the google form? Will your email appear 6 times too?

[@justinebatchelder728]

Super helpful!

[@jamiemorse3804]

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!

[@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 👍🏼

[@sreehari157]

Thanks for making this video and it's very helpful

[@ProlificOaktree]

Glad you liked it.

[@peaceforpetsdogadventures7417]

Do you know if I can "Sort" this spread sheet in Reverse Chronicle order? - Meaning that the most recent submission would be listed first?

[@ProlificOaktree]

You can always sort tables either way, ascending or descending. Just pick the different direction when you choose the sort from the menus.

[@seeasif]

Easy Peasy. Great. Thanks.

[@ProlificOaktree]

Lemon squeezy.

[@harshavardhanreddy6558]

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

[@adamsteinfurth9315]

Yes, that is how the values come into the spreadsheet when the user selects more than one checkbox, for example. One cell per questions, separated by commas if multiple answers.

[@denaehemminger4752]

I have a question my sheet always has the “request for edit” button and I do not know how to get rid of that off my form

[@ProlificOaktree]

You've gotta go to File then Make a copy. It's probably not in your Drive yet.

[@annavorisek9950]

This Video was perfect! Thank you

[@ProlificOaktree]

Glad it was helpful!

[@catherinenamoc8126]

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

[@staninjapan07]

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?

[@ProlificOaktree]

No, the surveys can be sent to any email address and the recipient does not have to have a Google account to enter data into Forms unless you chose that users can only submit one response. In order for that to work, users will have to sign in so Forms can know who they are.

[@staninjapan07]

@@ProlificOaktree Thanks

[@386rio]

after input in google form and showing spreadsheet, can the input combining with vlookup function?

[@ProlificOaktree]

Yes, you have full control of the resultant spreadsheet.

[@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?

[@ProlificOaktree]

I just tested and it doesn't seem to work. It appears the new results come in as size 10 Arial regardless.

[@dianamjeshtri1368]

I’ve accidentally deleted the section with questions from google form. Is there any method find witch response matches with which question?

[@ProlificOaktree]

I would try to open it from Forms again and see if they happen to be in the same order. Otherwise, consider using VLOOKUP.

[@JamesBHL7]

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?

[@ProlificOaktree]

Yes, there is an option to limit respondents to one response. Leave that unchecked.

[@Ken-ts6ex]

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.

[@ProlificOaktree]

Just let it accumulate in the form and look at it whenever you want. No need to email.

[@mjngltn]

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

[@ProlificOaktree]

Yes, it's called Branching. See here kzbin.info/www/bejne/qp7Ve6CKgdysp6c

[@maintainapplication4427]

if you want to evaluate the given answers and be notified if someone answers "No", please have a look at the following Google Sheets Add-On: gsuite.google.com/marketplace/app/maintainapp/842811037884

[@franzfms86]

Does this forms automatically create an excel file for the master list of a survey or registration forms? Or I have to create new form under google account?

[@ProlificOaktree]

It automatically creates a spreadsheet in Sheets, not Excel.

[@franzfms86]

@@ProlificOaktree thanks for the info.

[@palomeke]

Hi! Is there any way of gathering data from Google Slides? I want my students to fill in a kid of pdf form and gather the PDFs. Is it possible? Thank you!!!

[@ProlificOaktree]

Not that I'm aware of. It's not designed for that.

[@rexryanmalbacias6865]

Thank you!

[@ProlificOaktree]

Anytime!

[@danmalone2330]

Great video!

[@ProlificOaktree]

Thanks!

[@nanasuryana7876]

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

[@ProlificOaktree]

I don't know of a way to do that.

[@nanasuryana7876]

@@ProlificOaktree that is ok... Thank you for reply...

[@theharrisenglishlearningpo5953]

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?

[@ProlificOaktree]

If you used Google Forms, it has built in functionality to export to Sheets. I think it's in the area where you look at the grades. Not in Classroom but in Forms.

[@theharrisenglishlearningpo5953]

@@ProlificOaktree Thank you for the reply, I appreciate that. I'll check it out.

[@theharrisenglishlearningpo5953]

@@ProlificOaktree Thank you!

[@vincentdomingo3484]

What happens if you submit 6 times into the google form? Will your email appear 6 times too?

[@sentb5744]

Very helpful

[@ProlificOaktree]

Glad you think so!

[@MrMosoani]

is there a way it will automatically capture the employee's email? how can we recover the data that were accidentally deleted while retaining the new entries?

[@ProlificOaktree]

Capturing emails is a setting when you create the form. You could also create a field and ask for it.

[@MrMosoani]

@@ProlificOaktree thanks. I wonder if it's possible to restore previous version but can also retain the new entries.

[@002sprinkles]

Hello, my supervisor shared a google sheet with me a couple of weeks ago with the form linked to it. He asked me to update the responses on the sheet as more people have filled out the form since then. I asked for access but he said I do have access as the google form is linked on the sheet. However when I click on edit form it says on the bottom request edit access and when I click on show summary of responses it's locked and says I need access. Is there a way that I can extract the data from the form (that he created) so I can populate the spreadsheet with the most recently submitted answers?

[@ProlificOaktree]

No, it sounds like you have a permissions problem.

[@002sprinkles]

@@ProlificOaktree Thank you for getting back to me so quickly! When he does grant me permission would I just click on form --> show summary of responses and then pull the updated data? I've never done this on a Google form that I didn't create

[@ProlificOaktree]

@@002sprinkles Yes, assuming the owner of the Form has given you the right permissions.

[@002sprinkles]

@@ProlificOaktree Thank you so much!!

[@asadmehmood6173]

Easily understood.

[@ProlificOaktree]

Thank you!

[@janellegibson3286]

How can you transfer data from a google form ( survey) to google sheets, but instead pie data, display numbers. For instance, how many people said yes or no to certain answers.

[@ProlificOaktree]

You can see the charts before you export. If you want them in Sheets after the export, you would have to insert them from Sheets.

[@janellegibson3286]

@@ProlificOaktree I was asking more about Pivot. I am having trouble doing Pivot. Is it because I have many questions in my survey that are long and not just a yes and a no? If I want to pivot the edit asks for names. I just want to have the questions and a tally of the answers, yes, no maybe.

[@ProlificOaktree]

@@janellegibson3286 May check out a few basic pivot table videos...

[@janellegibson3286]

I have, but I think there are limitations. It will not allow me to do certain functions. Like only the questions and then just the simple answer. For example, do you like bananas? Yes, no maybe. It will allow only one question, but when I add the next one it moves the first question and messes up the whole format.

[@David-fq5un]

Why is there no NUMBER field? e.g. to enter wages

[@ProlificOaktree]

I think any of the fields that allow characters would accept numbers. However, I don't see any that would limit the input to a number if that's what you're looking for. Good luck!

[@goldysharma73]

Hello I am from India Can you tell us how we can search or sequenced the name alphabetically ? Please let me know this one

[@ProlificOaktree]

You can use SORT.

[@jmafanador6248]

I created the report, but I erased it, and when I try to view it, the system does not allow me to do it. Is there a way to create again the report, after deleting the previous one? Thanks in advance.

[@ProlificOaktree]

It will create a new Sheet if you fill out the form again. If you want the old spreadsheet back, look in the Trash in Google Drive.

[@martinafanador3859]

@@ProlificOaktree thanks for the answer. The problem is that I also deleted from the trash :( If you know any other options I would really appreciate it. Thanks in advance.

[@ProlificOaktree]

@@martinafanador3859 If you're in an organization account, contact your admin ASAP. The files will be gone in 20 days. If you're in your own account, the file's probably gone.

[@chaymaaelmoutarabbi2757]

@@martinafanador3859 hello friend I just had the same problem happen to me yesterday hhhhh and spent 3 hours refilling a new questionnaire with the answers I got from people on the first one I only did 50 so far and there are over 100 answers left😢 I'm struggling with it now

[@zunairaakram8786]

Thanks 👍

[@ProlificOaktree]

Welcome 👍

[@vaishnavis70]

i have gathered data but i dont how to score it

[@ProlificOaktree]

Thanks to your questions, I made a new video about how to grade a quiz here: kzbin.info/www/bejne/nWnXhWWNf7eUbK8

[@whkrause]

After 8 minutes I still don't know how to link a Sheet to a Form, which was the title of this video. Tons of irrelevant info though.

[@ProlificOaktree]

That's not the title.

[@abahiduh3246]

the sheets is automatic

[@gameKing20245]

dude, IT DIDNT WORK BECAUSE I DONT HAVE THE SCRIPT

[@ProlificOaktree]

The script for the form? Not sure what you're talking about.

[@sibastoune]

Thank you!

[@ProlificOaktree]

You're welcome!