We need to scrape data from a website into an excel spreadsheet. The website is found at:
[url removed, login to view]
The steps to take are the following:
* On the left hand side of the homepage select the blue link 'FE Colleges'.
* You will be presented with a list of 567 colleges listed alphabetically
* For each of the colleges select 'info'
* We then need: School name, street, town, county, postcode, headteacher/principal, school website, telephone number, type and LEA - each in a separate column in an excel spreadsheet.