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.
- Bring all info, using sheets, into one spreadsheet. This makes it much easier to handle.
- 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?
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