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. We need to check each of the websites in the list and log the following data:

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 12 rows 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 e removed completely.

Thanks
Warren