How to implement so that each user fills in the table after and in the end it is possible to sort them by items?

Question

Google Sheets

1) There is a table where each user scores his numbers (there is so much polled, so much done, so much has passed, etc.)
2) Users are divided into groups (for example: district - city (village, village, etc.) d.) - school - class)
3) It is necessary that the tables filled in by users can be downloaded in excel format
4) Also, in order to be able to upload general data on the school, city, district - something, so much has been done; in the city, accordingly, it collects data from all schools, classes, etc.)

What is the easiest way to implement this?

Answer 1

Everything that you have indicated is really possible to implement using tables using only their internal functionality (well, or almost).
The only thing you may need is hosting / vps of the minimum configuration. You can do without it, for example, a telegram bot (here we are talking about how this data will be obtained)
Your task boils down to the following: we take the data from the table > select everything you need from them > send it somewhere in the desired format (as you have, for example, in table) (you will need to create a file for this, and connect Google App Script to the disk, fill the file with the necessary data, and give a link to download the file, or just send the file wherever you need it.
A person sees an already completed table and wants to download data, it is necessary to place somewhere either a site or a bot through which he will receive this data. Having gone to the site, he presses the receive button by entering the input (eg his name) and the table begins to download.
The same with the bot - wrote to the bot - he sent a table
What will we have under the hood - a web service on Google App Script that
- selects data when accessed according to criteria
- creates a table on your disk and sends data there
- receives a link / file to the table
- gives the table as a link or file to the user
Bot or website
- sends information to the service
- the service gives the data
- download occurs
In short, this is what you need
ps, hosting is here for proxying - if you send requests directly from the site to the Google service, it will swear at cors. If you don't need hosting to use a telegram bot

Answer 2

The easiest way is to pay a specialist.