Have Multiple Forms feed information to a Single Sheet

Used forms for feedback? Ever wanted all the data Collated into a singe spreadsheet? This is how you can do just that!

Have multiple Forms all feed info and data into a single spreadsheet!

-----------

As always if you found this helpful, subscribe today and find us on one of the following websites:

Looking to create your own videos like this to 'flip' you class?
I use Techsmith Camtasia and Snagit and love it!

[DarrenFlemingAus]

Thanks for a great video. Unlike most other educational videos out there you're not trying to show us how smart you are and or how stupid we are. You just give great succinct info that is useable. Well done you. There was nothing to skip over!> THANKS SO MUCH

[henrydeluca]

Great! This saved me from transferring data manually! Now i got all my responses on one sheet. Your tutorial is right to the point, and you show the steps again even if it was simple. Thanks!

[ede]

What would be truly awesome is if one sheet contained responses from multiple forms on the same TAB, adding responses across the rows by the same student names.

[jameslentsoane]

Brilliant, Brilliant, Brilliant...just exactly what I was looking for. Thank you.👌👌👌👌

[felknowl]

Thanks very much for your clear, helpful instructions and demos. So useful. F

[christophmeirich]

Thx!!! Very helpfull!!!! Greetings from germany Christoph 👏 👏 👏 👏 👏

[stacieball]

This was amazing, and exactly what I was looking for!

[tonytorres]

What drop down in the Form would I use if I have multiple schools sending in their meal count totals for breakfast lunch and supper?

[calebm]

Is there any way to automate the naming of the sheets generated by each form? For example, instead of it being "Form responses n" each time, can you just make it have the name of the form (like "workshop two feedback")?

[ambientdave]

Really nice tutorials, first time user of Google sheets, hoping to create my home budget and get to grips with my finances!

[meziahmariefabre]

Thank you for sharing. It would solve my problem.

[credithonor]

You simplified my life! Thank you so much!

[annoury]

Thank you for the simple to understand tutorial. It was really a great help.

[madmed]

Hi, I have a problem with converting forms into sheets, I have a form that has a lot of sections, because I run a delivery start-up, so I have provinces (cities) and then based on the answer it'll take them to a different sections (as many as provinces) that include the departments of the respective province, so my problem is that when i convert the form into spreadsheet, I have all the rows for departments that are empty except the ones that the client answered, how do I merge all of them into one row in sheets so that I have only two rows (province-departement) and not and so on), would appreciate any help! Thank you.

[gailt.benson]

I have two identical forms - one in English and one in Spanish. I would like them to link to the same sheet on a Google Spreadsheet. Is that possible?

[nicholaslacovara]

But can you get multipal forms to one sheet and one tab?

[WasefAlHakim]

Really nice Tutorials, The best thing it is for FREE :)

[nasar]

Brilliant. Straight to the point and easy to follow. Thanks

[nitindubey]

Same thing I wish to in office 365 pendrive form. How can we get multiple responses in one excel using office platform

[jbmr]

I would like to have multiple forms feed into one spreasheet and the same sheet, in your video there are one sheet for each form evendo in one spreadsheet. I would like multiples forms feed in one spreadsheet AND one sheet, Is it possible?