Data Research, Collecting And Cleansing

We have a large list websites of around 3000 rows that has been exported from one of our online research tools. Most of the data can just be removed as it isn't relevant but we need to check each of the websites in the list and log the following data for the ones that are:

1: Confirmation that it is a UK business by checking the address.
2: The city and region of their office e.g. Manchester, Northwest

We are looking for in person training providers, that either work via training centres or in house programmes. Any other websites in the list can be removed completely.

We have attached a spreadsheet with the first 70 rows cleansed and populated to show the data and how we need it.

This list should shorten down quite considerably as there are many irrelevant websites that can be removed completely.

Thanks
Warren