Visual Crossing Weather API provides instant access to both historical weather records and weather forecast data
MicroWeather API – An all-in-one weather API: Get the most accurate information, generate invaluable insights, and drive actions – in just a few lines of code.
An advanced weather API to power all of your business needs, from the basic to the most complex weather influenced solutions.
The Solcast API is a solar radiation and solar energy forecasting data service that is designed to be easy to use and to integrate with other systems that are looking for live solar radiation and solar PV energy output data.
Global hyperlocal real-time air quality API for 1M+ postcodes. Test an API call. Get accurate & actionable air quality data.
In this API collection, you’ll find available weather APIs that allows developers to access historical data for weather conditions (like historical rainfall data) around the world.
Search by city, zip code, airport code, date range, and more. These are some of the best historical weather databases around.
An API (Application Programming Interface) is a set of definitions and protocols that allow technology products and services to communicate with each other via the internet. A weather API allows you to connect to large databases of weather forecasts and historical information. Check out some of the top weather APIs.
To get this data in a spreadsheet, you might be interested in the RapidAPI Google Sheets Add on. Using RapidAPI, you can pull in API data into Google sheets. Check out this simple guide.
Check out the docs here.
According to this blog post, the best free weather APIs are: