If only there was someone on here that had taught themselves one of the best and widely used languages to interact with websites, they’d be able to tell you what you need.
Python is the code to use.
Re the back end, if it’s numerical comparison and analysis you require, then excel would work fine. Just make sure the data output is in the best way to utilise the info, country, county, town, school name, year grouping, result 1, result 2, result 3 etc
With Python you would create a table or csv file of info to be populated in to the website, town, school name etc
Python would then open the webpage you specify in the code, read the table or csv file (with the info o be sent to the webpage) a row at a time and populate the webpage accordingly. Python can also click on whatever radio button you require, select downs and click on any button on a page.
With a lot of webpages, the search criteria you enter onscreen then forms the url which os used to retrieve the info to the webpage. So you can create the urls in a table which Python loads and opens the relevant search page result webpages.
Python can then select whatever info is displayed on the screen and extract it as a table or csv file or manipulate the data however you want. It could look at dates the info was loaded on the website and compare that to previously extracted data in an output file to see if you’ve previously extracted that information and therefore not to extract it again.
Once all the info for one school has been extracted, the Python code would then go to the next school in the table / csv file to be queried.
Python is a very powerful tool Soph and better still, it’s free. I then use PyCharm front end to code Python. Again, that’s free.
It would be a good idea if you manually extracted all the info you required for say 3 schools, then put that in to excel and perform whatever analysis on this data that you would with all the data. Just so you know what you need to extract and what you want to do with the data once extracted and if excel is the right tool for the back-end.
You haven’t really mentioned what you want to do with the data once extracted. That would drive what you need at the back end.
But use Python to intereact with the websites and extract the info.