Visual Crossing API Excel Demo
API Page: https://www.visualcrossing.com/weather-api
Documentation: https://www.visualcrossing.com/resources/documentation/weather-api/timeline-weather-api/
This Excel file demonstrates how to use the Visual Crossing API via VBA and Excel formulas. There is a 'Settings' sheet wherein you can enter your API key and adjust the delay between requests (in milliseconds). This sample should work on Excel versions from 1995 and above.