We are often asked how to import weather data from the OpenWeatherMap API directly into Google Sheets. To help you with this, we would like to refer you to the detailed guide “Import OpenWeatherMap Data to Google Sheets”, written by Mixed Ana...

Our API takes the name of any global location or zip code, and converts it into a list of coordinates (known as direct geocoding) as well as converting a geolocation into a list of place names (reverse geocoding).