Visual Crossing Weather API provides instant access to both historical weather records and weather forecast data
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.
Get accurate historical weather from over 104,000 locations around the world. Daily weather measurements from 1763! Weather information includes: minimum & maximum daily temperature, snow fall, precipitation, evaporation and more!
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 <a href=“https://blog.rapidapi.com/api-glossary/api/”>API</a> (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 <a href=“https://rapidapi.com/collection/top-weather-apis”>top weather APIs</a>.
To get this data in a spreadsheet, you might be interested in the <a href=“https://chrome.google.com/webstore/detail/rapidapi-for-google-sheet/niplaodlmdnbohiabbnknjienppmbpfl”>RapidAPI Google Sheets Add on</a>. Using RapidAPI, you can pull in API data into Google sheets. Check out this <a href=“https://blog.rapidapi.com/api-google-sheets/”>simple guide</a>.
<a href=“https://googlesheets.rapidapi.com/docs/getting-started”>Check out the docs here</a>.
According to <a href=“https://blog.rapidapi.com/access-global-weather-data-with-these-weather-apis/”>this blog post</a>, the best free weather APIs are: