Weather Functions by Visual Crossing

Turn your spreadsheets into intelligent workflows and analyses. With this Excel add-in, you can access accurate forecasts and historical weather data for any location worldwide—all with just a few simple formulas. Whether you're managing logistics, insurance claims, retail, solar energy, agricultural production, or any other weather-related activity, real-time weather insights are now just a cell away.

Built by Visual Crossing, this Excel add-in connects directly to the Visual Crossing Weather API - one of the industry’s most trusted sources for accurate and high-resolution weather data. Each Excel function uses secure API calls to fetch live, forecast, and historical weather data for any location worldwide. The add-in is designed for professionals who need reliable environmental data for business analytics, reporting, logistics, and planning.

The add-in provides a set of powerful custom Excel functions designed to make working with weather data simple and flexible.

VISUALCROSSING.GETWEATHER – Inserts a range of weather data (such as temperature, wind, precipitation, and more) for one or more locations across one or more dates or times.

VISUALCROSSING.GETWEATHERVALUE – Retrieves a single weather value (e.g., high temperature, humidity, etc.) for a specific location and point in time, perfect for use directly within formulas and calculations.

VISUALCROSSING.RETRIEVESTOREDDATASET – Accesses data from your previously stored datasets in the Visual Crossing Weather platform, allowing you to integrate custom or curated weather data into your workbooks.

These functions are designed to be both easy to use and powerful enough to support complex analysis and automation within Excel.

This add-in requires a free sign up available at https://www.visualcrossing.com/