[Request] Current Hourly UK Weather Forecasts By Location?

Good morning all,

My hobbies are spreadsheets and painting minatures. I’m currently trying to make a spreadsheet to predict when it would be a good time to go outside and prime some miniatures to paint them (this can only be done outside due to it being rattlecan).

Ideally I’m looking to filter based on location, and then have columns for day, time, precipitation chance, windspeed. I’m hoping to connect to it from excel, such as grabbing it via RSS, CSV or even (dare I dream) SQL.

If I get stuck, my plan is to grab it via the web front end, from BBC, but that can be a bit clunky. Anyone know if there’s something more elegant out there?

So far, Ive tried BBC, Netweather and Met Office, but nothing quite suits yet.