Can all the data you collect from the forms be collated into a spreadsheet?

Yes, you can integrate all submission with Google Spreadsheet. For information on how to integrate, please check this guide https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets.

Let us know if you have any questions or if you need further assistance.