I noticed that on windy.com current temperature is displayed by default below names of cities (screenshot is attached below). I was wondering if someone could point me in the right direction on how to achieve that without manually defining all locations and pulling weather data for them?

I am trying to find the best source for weather history by specific locations. I’m trying to compare weather conditions with the affect on our businesses. everal spots, dump it into Excel, & compare historical weather data by location.
For instance - examining sunny days in year 1 vs year2.

We have multiple locations so I cant create it manually. Am looking for something that can be pulled automatically.

Weather Underground used to provide this info but it looks as if they have ceased. I don’t mind paying a little fee if the information is easily accessible.

Any ideas would be appreciated.