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: