A cheap way to build forms on a webpage that then add a data to a row in excel cloud file

For a sports league.

The user selects the league, the team, and players from a restricted list. Then enters scores for each player. Then submits. This then updates or adds a results record onto an excel table.

This is easy to do in a standalone spreadsheet, if the user was sitting next to me!

However, I want to give team captains the ability to perform the above remotely, as we have a lot of matches and this saves time for the league administrators (=me!). This is the main requirement, ie labour saving. There could be 100 or so team captains, or even more.

I am assuming a webpage is the best way to do this. However, I'm not finding anything online that particularly helps, even though this must be a common requirement for other applications?

Perhaps there is another way other than a webpage, eg on-line collaboration.

My request is I'd like to have a steer as the best technological route to go down, rather than have to experiment with lots of options. This route has to be cheap - I understand there are options like appsheets, caspio but these are way too expensive.

Thanks in anticipation.

Excel 365 online version can do what you want. Are you using that version ?

thank you! I've had a look at this option.
A couple of issues. Users are not familiar with Excel (albeit I could develop macros etc to make this easier). Users would be updating the same part of the spreadsheet, potentially at the same time. Its possible to work around both these things but it would be clunky.
This has helped develop my thinking, thank you.

My next thought is that, (going back to the web-interface option), we need embedded interactive EXCEL within a webpage, where once the user has input certain details, there is an option to SUBMIT the form which pushes it back to the EXCEL cloud file. (The option of a real-time link would presumably have the same user conflicts as with shared EXCEL, hence discounted).

So the question NOW is, how to PUSH form information, derived from an EXCEL cloud solution (using validation lists,etc) BACK TO an Excel file in the cloud.
Thanks
John

So the question NOW is, how to PUSH form information, derived from an EXCEL cloud solution (using validation lists,etc) BACK TO an Excel file in the cloud.

Admittedly, this is above my pay grade. Hopefully someone on the Forum with Excel/Internet experience can assist.

Site says: "Important: Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint.
We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps."

Not sure what that means for me, as using MS365 not SharePoint.