I have a survey created in Google Docs used in several classes. Each class has its data in a separate Google spreadsheet. Now I want to collate all the data into a single spreadsheet. If I simply copy and paste the data into one spreadsheet, it is not recognized. How can I compile that data from the separate spreadsheets without having to re-enter it all manually?

closed as unclear what you're asking by Rubén, ale, Eight Days of Malaise, serenesat, user79865 Mar 17 '16 at 20:23

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What do you mean by "it's not recognized"? Did get an error or the filters/charts/reports doesn't include the pasted data? – Rubén Mar 17 '16 at 10:41
  1. Bring all info, using sheets, into one spreadsheet. This makes it much easier to handle.
  2. Use one last sheet to bring all relevant info together.

Otherwise you need to use Google Apps Script or Import functions.....

By classes, you mean school classes I recon?

  • 1
    One sheet to rule them all?...Sorry, couldn't resist. – OnenOnlyWalter Jan 23 '13 at 18:56

Have you tried reading the documentation on reading and writing information through Scripts?


There's also a StackOverflow thread about how to write to multiple sheets, I think you can use the same approach to read from multiple and write to 1:



Working with scripts, apps could be one way, how about checking out this one. CollateBox can bbe an ideal solution. I am sure u'll be amazed with its data collation ability. For more read http://blog.collatebox.com/blog/2012/01/are-you-using-google-docs-to-share-and-collaborate-your-data-online.html


Evangelist @ CollateBox

  • Please disclose your affiliation with the service in your answer, otherwise it will be considered spam and treated accordingly. Thanks! – Alex Jan 23 '13 at 11:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.