@@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! ☕🥯
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!!
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.
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?
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
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?
@@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?
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?
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?
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.
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?
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.
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
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
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
Oh well - thanks for watching anyway - I have been doing tutorials on TH-cam a long time now and realised a long time ago - you can’t please everyone. I’m sure there’s someone on TH-cam who does computer based tutorials to your liking. Good luck.
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.
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.
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
Im new at this. One of my staff dying made me find ways to digitally carry out examination . This is good help
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 😅
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
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!!
Cheers. This was a great primer to get in before I start messing about with it myself. Nice one.
oh my gosh!!!! I am now a genius, thanks to you!
Fantastic!
Thank you so much. Thoroughly explained the whole process.
Thanks buddy
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.
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.
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 💐💐💐
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?
Thank you Sir!! Great video!!
Very welcome
AMAZING... YOU ARE AN ANGEL !
And you sir are Amazing.
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
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
Very helpful. Thank you
My comment similar to many others I see! I just "Subscribed" too. Thank you for your time!
Thanks Stanley I appreciate that.
That was actually helpful :)
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.
Excellent-thx!!
Hey Jesse - thanks
Good Job, Thank you.
Thank you too!
Deeply appreciated. Thanks for your intelligence & clarity!
Thank you mate.
Thanks 👍👍🏿
Can we do dthe other way around? Redisplaying the Google Sheets data in Google Form?
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!
Great video tutorials but is there a way to auto populate answers from an excell sheet unto a google form?
Brilliant, thank you.
Hello! is there any way to get the data from the forms into the sheet, vertically?
Just what I was looking for! Thank you!
Thanks Jan - Glad it helped
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
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?
Great video with clear explanations! Thank you!
Thanks Bad Kitty glad it helped
Very good and clear explanation organized and pleasant!
Thanks Stelios appreciated
Thank you so much
MANY THANKS!!!
No problem- I’m glad it helped
Thank you Sir
Most welcome
Thanks so much for your help on this, it is perfect and just what I need!
Great James - glad it helped
Thanks!
No problem
thanks homie
Np
Is it possible to auto-assign continuous numbers in a field of the google form so I make sure the numbers run in sequence?
Very Helpful. I also have a question and I will ask it in my next comment. Thank you.
thanks very 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?
😀Thanks!
thanks this works
Many thanks for that !
No problem Franck - glad it helped.
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.
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?
Great job! Thank you. Very clearly explained.
Thanks
Is there an option in forms that will create multiple tabs in sheets?
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
TY
Really helpful video, I am doing a market survey & this video is going to make my stuff done.
Great stuff - glad it helped
Is it possible to link a form to two different spreadsheets?
Thanks this is great! Any idea how to assign form inputs to different tabs inside one google sheet?
Did you ever find out how?
Very helpful!
so loooooooooooooooooooooooooooooooooooooooooooooooong haha good job boss
Indeed thanks Ziga
Thanks....
Welcome
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.....
Can I also do that in mobile?
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.
You should like the guy who reviews ships in Space Engineers.
HAHA dont know if thats good or bad.
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.
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
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
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
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?
My Sheets are not updating from form responses for 12+hours after submission.. How can I fix this?
ty
please help i deleted the google form spredhee file i cant crate new one
How to save it as desktop use personal.
How shall we bring responses on 2 box rather than on 25th box
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.
wow
why does it say I already responded when I try to add another entry
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 TH-cam a long time now and realised a long time ago - you can’t please everyone. I’m sure there’s someone on TH-cam who does computer based tutorials to your liking. Good luck.
How do you add different data within the form to different tabs in the sheet?
i had to click the 3 dots and create a spreadsheet to link it in the end
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
It's not linking
12:00 Thank me later
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.
impossible to see with monitor size less than 27". thumbsdown.
Just going blah blah blah....
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.
waste of time
Hey Jackie Lim thanks for watching the video. Why do you feel it’s a waste of time?
Awesome thanks for sharing
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