Import the data from 4 integrated sheets into a 5th google spreadsheet.

  • Profile Image
    jonnybode
    Asked on September 13, 2016 at 01:55 AM

    Hello I love your service. I have 4 schools and 4 forms Monday tuesday wednesday thursday. 

     

    I have a google sheet for each form but i would also like to have a master copy with all of the enrolments. In essence i would like to create 5 sheets for 4 schools with one of the sheets being a copy of everyone's information so i can email all of the students at once. I don't want to use mail chimp because of the double opt in. Is there any other possibility?

     

    Thanks 

     

    Jon Bode

  • Profile Image
    Chriistian
    Answered on September 13, 2016 at 04:55 AM

    Hello John and thank you for your feedback. I believe you can achieve your requirement by using the ImportRange function of google sheets. With this function, you can simply create the 5th form and add the importrange function there to import the data from the 4 other integrated google sheets. Here are a couple of guides that you can check out:

    Import Range: how do I use it? Instructions and tips
    Using IMPORTRANGE in Google Sheets

    Alternatively, you choose to install the free "Import Sheet" add-on to automatically import the data from your other sheets into the 5th google sheet. Here's the link: https://importsheet.com/ 

    Please let us know if you need further assistance.
    Regards.