0

I wanted to know if there was a way to collate data from different forms in google forms.

My question is simple: Is there a way so that once a user completes and submits a set of forms, is there a way for the data to be automatically collated into one spreadsheet ?

Zig Mandel
  • 19,571
  • 5
  • 26
  • 36
James
  • 91
  • 1
  • 6
  • Maybe this helps: http://stackoverflow.com/questions/21783279/updating-existing-data-on-google-spreadsheet-using-a-form – Vincent Apr 20 '16 at 08:00
  • Need some more details on your current setup / code. You tagged Excel - are you using Google Sheets or trying to make an excel file? – Vincent Apr 20 '16 at 08:01
  • 1
    just use the importRange spreadsheet function. a sample that consolidates many sheets using importRange is here https://zigmandel.blogspot.com/2015/09/how-i-crowd-translated-my-product-tour.html last section "consolidating status" – Zig Mandel Apr 20 '16 at 13:44

0 Answers0