Use Google Forms to Auto Fill Google Sheets with Data
HTML-код
- Опубликовано: 6 июл 2024
- Learn how to collect data from a predefined form using google docs Forms. In this tutorial, I show you how to use a Google form to collect data and have google auto collect the data into a spreadsheet, this is brilliant if you need to use a simple form so mistakes cannot be made and then collect this information for further processing in a spreadsheet. Google docs are only getting more powerful and with functionality being added regularly to the platform it makes it a great free tool to utilise.
Welcome to my RUclips channel "TheComputerLab" I created this channel to help others with everyday computer problems. It has slightly changed throughout the years and has gone from basic fixes to lots of different help videos which have been added to from iPhone tutorials, game system fixes to Mac and Windows tutorials and lots more - Please do subscribe even if you only visited my channel just for one video as your help by subscribing helps my small channel.
#TheComputerLab, #ComputerLab, #GoogleSheets, #GoogleForms, #GoogleAutoFill
🔴 Please subscribe here: ruclips.net/user/Thecomputer... Хобби
Thank you so much. After typing 150 forms comprising 46 questions I would be devastated if I couldn't get that in spread sheet.. this surely helped me❤️
As of 3/5/22 I don't see the "preferences" button discussed in the video, however, creating or adding to a spreadsheet as discussed starting at the 12 minute mark works great! Love that it will automate once set up. Thank you!!
Deeply appreciated. Thanks for your intelligence & clarity!
Im new at this. One of my staff dying made me find ways to digitally carry out examination . This is good help
Great job! Thank you. Very clearly explained.
12:00 tells you how auto-record google form responses on a spreadsheet. Thanks a lot!
thank you for saving me time. been watching the whole thing and didnt get the method till the end
I wish I saw this 12 minutes ago 😅
Brilliant, thank you.
Thanks so much for your help on this, it is perfect and just what I need!
Great James - glad it helped
Just what I was looking for! Thank you!
Thanks Jan - Glad it helped
1:19 Form part
10:38 Sheet part
I'm interested in inserting this into a set of sheets that I already have built.
Thanks for showing us this much!
Is it possible to copy the data of the existing sheet and paste them in the spreadsheet?
@@fungria
Don't know. Will try and experiment later today.
Have a good one!
@@fungria Okay, I'm just getting to this.
So, now that I read your question, I'm wondering why I didn't know the answer. Yes, it is possible to copy data from one sheet to another sheet. I do this weekly.
🖱Hi-lite the cells you want to copy and press the "CTRL" + "C" keys.
🖱Put your cursor in the top left cell where you want it to land and right click.
🖱Hover over "paste special" then you get a fairly detailed menu of stuff you can copy.
🖱Choose the one you want. If you want to choose more than one, you have to right click and repeat each time.
At least that's how I've been doing it. If there's a quicker way, I'd like to know too.
Did that answer your question?
Have a good one!
☕🥯
@@DarkMoonDroid Thank you so much!
You da man
Cheers. This was a great primer to get in before I start messing about with it myself. Nice one.
Great video with clear explanations! Thank you!
Thanks Bad Kitty glad it helped
Very helpful!
FANTASTIC Tutorial ! Thank you ... you have my subscription for sure! Thumbs Up!
Thanks Krista - I really really really appreciate your comment and thanks for the sub.
That was actually helpful :)
Thank you so much. Thoroughly explained the whole process.
Thanks buddy
Really helpful video, I am doing a market survey & this video is going to make my stuff done.
Great stuff - glad it helped
My comment similar to many others I see! I just "Subscribed" too. Thank you for your time!
Thanks Stanley I appreciate that.
Thank you mate.
Awesome thanks for sharing
Very good and clear explanation organized and pleasant!
Thanks Stelios appreciated
Many thanks for that !
No problem Franck - glad it helped.
MANY THANKS!!!
No problem- I’m glad it helped
For weeks I was trying to do this and now I know how to
Thanks
Thanks Ahsan- Glad it helped
@@TheComputerLab
Thanks to you Sir made my life easier 💐💐💐
Thank You. My head is spinning. Can info be entered into a form. Moved to a sheet and then inported into contacts? I want to rename or create custom fields in contacts.
Very helpful. Thank you
Thank you
I need to create a purchase order form to send to vendors. I created the sheet with drop down menu and vlookup to fill in the form but i want to know if i can make the form seperate so that other people at the company can use the purchase order but not have access to the google sheet. Does this make sense?
Very Helpful. I also have a question and I will ask it in my next comment. Thank you.
oh my gosh!!!! I am now a genius, thanks to you!
Fantastic!
Thank you so much
This was so great and thorough thank you! Connecting the form to the google sheet was the part I needed.
Thanks Jai, I’m glad it helped you
@@TheComputerLab one question... how do you get the google sheet that has collected all the information from the form to notify the user (the account that made the form and sheet) each time a new form submission arrives?
Great video, thank you. Random (unrelated) question: which mac app are you using for quick snapping/docking windows?
Hey thanks I’m glad it helped - the app I use is called “magnet” is a paid for app but it’s not expensive.
thanks this works
Thanks 👍👍🏿
😀Thanks!
Thank you for the video! I have a question: is it possible to do something similar with google docs? I mean, my goal is to pull data form my google docs’ bullet lists and transfer them to excel. Is it possible?
Thank you Sir!! Great video!!
Very welcome
AMAZING... YOU ARE AN ANGEL !
And you sir are Amazing.
thanks very much
Excellent-thx!!
Hey Jesse - thanks
Is it possible to auto-assign continuous numbers in a field of the google form so I make sure the numbers run in sequence?
TY
Thanks
Hi thanks for the video, Is it possible to have a Google Form Populate a Excel calculation Spreadsheet, what I am trying to achieve is to have a "New" - "Independent" google Sheet that has independent customer info and data on said sheet
This is great stuff and pretty much what I am looking for. However, I have a question on my form and the answer will determine what sheet my response will be stored in. My google sheets has 5 tabs (Sheets) and I would like my responses to be stored in the correct tab. How do I do this?
Yes looking for an answer to this, also a dropdown in google sheets which when selected determines the set of questions which are suppose answered.
Good Job, Thank you.
Thank you too!
ty
Thanks it was very helpful but what If I need the same information in google sheets but in a transpose automatically , Can you help with that too?
Great video tutorials but is there a way to auto populate answers from an excell sheet unto a google form?
nice videeo, please tell me. will new data be automatically populated in to the existing spreadsheet?
EDIT: i see that it does, thank you. awesome video
thanks homie
Np
Thanks!
No problem
Can we do dthe other way around? Redisplaying the Google Sheets data in Google Form?
Great video!
When I have a multiple choice question in forms, it will collect in google sheets the marked boxes separeted by "comma".
I would like to collect the unmarked ones in another columns in google sheets. Is it possible?
Did you find out the answer to this yet? I am trying to do the same thing
Thanks this is great! Any idea how to assign form inputs to different tabs inside one google sheet?
Did you ever find out how?
Thank you Sir
Most welcome
Thanks for this video. I'm trying to figure out how to get the data from the Forms(Responses)sheet into an existing sheet automatically. The existing sheet uses all the data plus extra columns ( like validating and calculating the incoming data). Do you know how to map that data?
Is it possible to copy the data of the existing sheet and paste them in the spreadsheet?
Importrange and query
I don't think you can do that, just make a separate sheet and link it to the google form. After all the response it updated paste it on the existing sheet you want. You don't have to do this if you start creating a new sheet from the form.
Hello! is there any way to get the data from the forms into the sheet, vertically?
Thanks....
Welcome
Is there an option in forms that will create multiple tabs in sheets?
I created a form step-by-step along with the video. When I got to the incognito part I was prompted to log in. I'm not sure what I did wrong since I followed each step exactly unless there have been changes to Google Forms since this tutorial was made.
i hope you got it by now.....
Thanks and great video; does everyone have to have a google account to complete the form; it keeps asking for a log in on the link that I'm using?
Yes you do
thanks for the video!
You have a tutorial that works the other way around?
Google sheets to autofill Google forms?
Sorry I don’t but will look into it
@@TheComputerLab cool! Thanks a lot!
i create a formula to link when data from google form but the cell that have formulas going down. please what to do not the formula not going to another cell
Is there a way to make it so just the names show on the sheets
can any please help me with this question
if i enter 12+13+14 in google forms and retrieve this data to sheets how can i expect a result in sheets?
🤩
Is it possible to link a form to two different spreadsheets?
so loooooooooooooooooooooooooooooooooooooooooooooooong haha good job boss
Indeed thanks Ziga
00:02 Automate data import into Google Sheets using Google Forms.
02:18 Replicate Google Sheets data in Google Forms
04:13 Using Google Forms to collect user data with various field types
06:11 Google Forms can be used to collect contact information from customers.
08:10 Using Google Forms to generate a form and a link for data collection.
10:08 Use Google Forms to collect data and submit the form to Google Forms.
11:55 Use Google Forms to auto-fill Google Sheets with data.
13:52 Use Google Forms to auto-fill Google Sheets with data
15:45 Create a form to auto populate a sheet in Google Docs
You should like the guy who reviews ships in Space Engineers.
HAHA dont know if thats good or bad.
Help me in google spreadsheets.. I need google form data in spreadsheets in vertically... usually we get all data in horizontally....
Just make a pivot table on another tab that formats the data that you want to see it.
Can I also do that in mobile?
How to auto align the data on sheet after I input data on Google form?
hello how i can rename google sheet before submit button if i have 5 class A-B-C-D-F how create sheet for every class ( google sheet named Form_responce_1 ) I not need to this i want take name class A example how i can do it thanks
wow
please help i deleted the google form spredhee file i cant crate new one
How do you add different data within the form to different tabs in the sheet?
How shall we bring responses on 2 box rather than on 25th box
My Sheets are not updating from form responses for 12+hours after submission.. How can I fix this?
why does it say I already responded when I try to add another entry
i had to click the 3 dots and create a spreadsheet to link it in the end
How to save it as desktop use personal.
are google forms, google drive and google spreadsheet safe from data theft?
As much as it can be, I recommend using a Titan Key to secure your google account - there is a review on my channel.
Just watched a 16 minute video that could've been done in 3.. more time of my life wat
This comment-section before I commented had 69 comments ha
Boom
This video could have been about 10 minutes shorter, and it would have been much better - I probably would have subscribed and liked too.
Oh well - thanks for watching anyway - I have been doing tutorials on RUclips a long time now and realised a long time ago - you can’t please everyone. I’m sure there’s someone on RUclips who does computer based tutorials to your liking. Good luck.
It's not linking
Go to 11:36 if you want to know how to have data go to a sheet. I watched 11 mins for a 10 second answer ... *face palm*
Too much talk dude. Keep comments few. Explain once and demonstrate. We don’t need a play by play description. 16 minute video that could been done 5 minutes.
Hey GuitarMyke - Thanks for watching my Google Sheets video, I appreciate you feedback, apologies if you felt it was to long.
12:00 Thank me later
Sir, if I have 1,000 quizzes and want to give $10 as gift to my those subscribers who have completed all 1,000 quizzes then How can I track those subscribers?
I'll be very glad if you help me!
By the way your video is very helpful and amazing.
Just going blah blah blah....
impossible to see with monitor size less than 27". thumbsdown.
waste of time
Hey Jackie Lim thanks for watching the video. Why do you feel it’s a waste of time?
Hi thanks for the video, Is it possible to have a Google Form Populate a Excel calculation Spreadsheet, what I am trying to achieve is to have a "New" - "Independent" google Sheet that has independent customer info and data on said sheet