I have an excel template that I want to make available on the internet for data collation

We do have a spreadsheet widget that you can use.

https://www.jotform.com/widgets/spreadsheet

Please check it out and let us know if this fits your requirements.