Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
  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?

share|improve this answer
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:


share|improve this answer

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

share|improve this answer
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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