Monthly weather for 60 world cities, 2025

Temperature, precipitation, humidity, wind and solar radiation for 60 cities, month by month, from NASA POWER.

Downloads are included in the $19.85 yearly membership. Sign in

XLSXCSVODSXMLNumbers

	A	B	C	D	E	F	G	H	I	J	K	L
1	Monthly weather for 60 world cities, 2025
2	Source: NASA POWER POWER Monthly and Annual API v2.10.0 · Retrieved 2026-10-08 · Licence: NASA open data, citation requested
3	City	Country	Latitude	Longitude	Month	Mean temperature at 2 m (°C) [T2M]	Highest hourly temperature in month (°C) [T2M_MAX]	Lowest hourly temperature in month (°C) [T2M_MIN]	Precipitation, daily average (mm/day) [PRECTOTCORR]	Precipitation, month total (mm) [PRECTOTCORR_SUM]	Relative humidity at 2 m (%) [RH2M]	Wind speed at 2 m (m/s) [WS2M]
4	Accra	Ghana	5.56	-0.20	Jan 2025	27.75	31.71	25.10	1.34	41.64	81.14	2.44
5	Accra	Ghana	5.56	-0.20	Feb 2025	27.84	32.45	25.27	3.43	96.12	84.10	2.95
6	Accra	Ghana	5.56	-0.20	Mar 2025	28.03	31.00	26.24	4.87	150.84	84.52	3.22
7	Accra	Ghana	5.56	-0.20	Apr 2025	27.86	30.49	26.04	4.93	148.05	85.86	2.81
8	Accra	Ghana	5.56	-0.20	May 2025	27.50	29.87	25.22	7.13	220.89	85.63	2.54
9	Accra	Ghana	5.56	-0.20	Jun 2025	26.54	29.05	24.44	10.67	320.02	87.46	2.75
10	Accra	Ghana	5.56	-0.20	Jul 2025	24.38	27.43	22.06	0.98	30.36	89.10	3.10
11	Accra	Ghana	5.56	-0.20	Aug 2025	23.88	26.52	22.09	1.45	44.98	89.95	3.03
12	Accra	Ghana	5.56	-0.20	Sep 2025	25.18	28.27	22.39	4.29	128.75	87.83	2.97
13	Accra	Ghana	5.56	-0.20	Oct 2025	26.16	28.98	24.09	6.84	212.12	87.51	2.49
14	Accra	Ghana	5.56	-0.20	Nov 2025	26.92	29.74	25.00	4.85	145.61	85.83	2.18
15	Accra	Ghana	5.56	-0.20	Dec 2025	27.19	29.71	25.27	3.38	104.72	85.77	2.46
16	Addis Ababa	Ethiopia	9.02	38.75	Jan 2025	15.21	26.03	4.00	0.01	0.35	53.27	2.17

Showing the first 16 of 723 rows and 12 of 13 columns. Cells with formulas show the formula on hover.

	A	B	C	D	E	F	G	H	I	J	K	L
1	Annual summary by city, 2025 (calculated from the Monthly tab)
2	Source: NASA POWER POWER Monthly and Annual API v2.10.0 · Retrieved 2026-10-08 · Licence: NASA open data, citation requested
3	City	Country	Mean temperature (°C)	Warmest month	Warmest month mean (°C)	Coldest month	Coldest month mean (°C)	Highest hourly temperature of the year (°C)	Lowest hourly temperature of the year (°C)	Total precipitation (mm)	Wettest month	Wettest month (mm)
4	Accra	Ghana	26.6	Mar	28.0	Aug	23.9	32.5	22.1	1,644.1	Jun	320.0
5	Addis Ababa	Ethiopia	16.3	Jun	19.2	Nov	13.1	29.8	2.9	1,564.3	Aug	425.8
6	Algiers	Algeria	19.0	Aug	28.7	Dec	11.0	41.4	3.5	452.9	May	92.7
7	Anchorage	United States	2.6	Jul	13.7	Dec	-12.8	21.0	-22.6	962.8	Sep	157.1
8	Antananarivo	Madagascar	17.1	Jan	20.4	Jul	12.3	27.8	4.1	2,443.1	Feb	625.0
9	Athens	Greece	18.6	Jul	29.6	Feb	8.7	40.0	2.1	633.0	Feb	122.5
10	Auckland	New Zealand	16.4	Feb	20.9	Aug	11.3	26.7	5.4	1,560.6	Jul	242.0
11	Baghdad	Iraq	24.7	Jul	38.1	Feb	9.6	50.6	-3.9	173.5	Mar	91.7
12	Bangkok	Thailand	27.8	Mar	30.5	Nov	24.4	40.5	12.3	1,602.4	Sep	365.4
13	Beijing	China	11.9	Jul	27.4	Jan	-3.5	38.6	-16.2	1,001.8	Jul	313.7
14	Berlin	Germany	10.4	Jul	20.2	Feb	0.5	37.9	-10.2	556.6	Jul	141.0
15	Bogotá	Colombia	18.8	Feb	19.3	Jul	18.1	26.4	10.7	2,063.8	Apr	475.9
16	Buenos Aires	Argentina	18.7	Feb	26.0	Jun	11.0	35.1	3.5	1,020.4	Mar	170.0

Showing the first 16 of 65 rows and 12 of 16 columns. Cells with formulas show the formula on hover.

	A	B	C	D	E	F	G	H	I	J
1	The 60 cities: location and grid elevation
2	Source: NASA POWER (grid elevation) and GeoNames (coordinates, city elevation) · Retrieved 2026-10-08 · Licence: NASA open data; GeoNames CC BY 4.0
3	City	Country	ISO2	Continent	Role	Latitude	Longitude	POWER grid elevation (m)	City elevation (m, GeoNames DEM)	GeoNames ID
4	Accra	Ghana	GH	Africa	National capital	5.56	-0.20	27.8	33	2306104
5	Addis Ababa	Ethiopia	ET	Africa	National capital	9.02	38.75	2,349.7	2,405	344979
6	Algiers	Algeria	DZ	Africa	National capital	36.73	3.09	415.6	113	2507480
7	Anchorage	United States	US	North America	Major city	61.22	-149.90	296.0	16	5879400
8	Antananarivo	Madagascar	MG	Africa	National capital	-18.91	47.54	1,425.1	1,274	1070940
9	Athens	Greece	GR	Europe	National capital	37.98	23.73	140.0	84	264371
10	Auckland	New Zealand	NZ	Oceania	Major city	-36.85	174.76	50.2	43	2193733
11	Baghdad	Iraq	IQ	Asia	National capital	33.34	44.40	38.4	41	98182
12	Bangkok	Thailand	TH	Asia	National capital	13.75	100.50	4.5	12	1609350
13	Beijing	China	CN	Asia	National capital	39.91	116.40	221.6	49	1816670
14	Berlin	Germany	DE	Europe	National capital	52.52	13.41	49.0	43	2950159
15	Bogotá	Colombia	CO	South America	National capital	4.61	-74.08	1,790.4	2,582	3688689
16	Buenos Aires	Argentina	AR	South America	National capital	-34.61	-58.38	6.6	31	3435910

Showing the first 16 of 63 rows and 10 of 10 columns. Cells with formulas show the formula on hover.

	A	B
1	About this dataset
2	Source: NASA POWER · Retrieved 2026-10-08 · Licence: NASA open data, citation requested
3
4	What this workbook is
5	Summary	Monthly weather for 60 cities in 59 countries on 6 continents, January to December 2025, from NASA's POWER project: temperature, hourly temperature extremes, precipitation, relative humidity, wind speed and solar irradiance. 720 monthly re…
6	Cities	National capitals plus well-known non-capital cities (for example Istanbul, New York, Mumbai, Lagos, Sydney, São Paulo), chosen to cover every inhabited continent and a range of climates: equatorial, desert, monsoon, Mediterranean, highlan…
7
8	What a value represents
9	Grid cell, not a station	POWER does not report weather stations. Meteorological variables come from NASA's MERRA-2 reanalysis, a global model that assimilates satellite and surface observations, on a grid of 0.5 degrees latitude by 0.625 degrees longitude (about 5…
10	Grid elevation	Meteorological values are for 2 m above the average elevation of the grid box (POWER methodology). The elevation POWER returns for each point is shown on the Cities tab next to the city's own elevation from GeoNames, and can differ a lot:…
11	Time standard	The POWER response header lists the time standard as LST (local solar time).
12	Latest data	Meteorological data cover the whole of 2025. POWER appends near-real-time model output to MERRA-2 and states that MERRA-2 values are typically updated every several months, so recent months can be revised in later downloads. The response h…
13
14	Tabs
15	Monthly	Long table, 720 rows: one row per city and month, sorted by city then month. Month is the first day of the month (displayed 'mmm yyyy').
16	Annual summary	One row per city, all formulas: averages and sums via AVERAGEIF and SUMIFS, extremes via MAX and MIN over the city's 12-row block, month names via INDEX and MATCH.

Showing the first 16 of 54 rows and 2 of 2 columns. Cells with formulas show the formula on hover.

About this dataset

This workbook holds monthly weather for 60 cities in 59 countries on 6 continents for 2025, taken from NASA's POWER project. For every city and month it lists mean temperature, the highest and lowest hourly temperature, precipitation (daily average and month total), relative humidity, wind speed at 2 m and solar irradiance in kWh per square meter per day.

The Monthly tab is a long table of 720 rows, ready to filter, pivot or chart. The Annual summary tab calculates, with formulas, each city's mean temperature, warmest and coldest month, total precipitation, wettest and driest month and annual averages of humidity, wind and sunshine. The Cities tab gives coordinates, country, continent and elevation.

POWER combines the MERRA-2 reanalysis (grid of 0.5 by 0.625 degrees) with satellite solar data, so each value describes a grid cell around the city and not a weather station. The About tab explains each variable, the unit conventions and the citation NASA asks for. Nothing is estimated or filled in.

What’s inside

60 cities in 59 countries on 6 continents, from equatorial to subarctic climates
720 monthly records for 2025, all complete, with 8 POWER variables
Precipitation as both a daily average and a month total, as published by POWER
Annual summary calculated with AVERAGEIF, SUMIFS, MAX, MIN, INDEX and MATCH
Coordinates to 2 decimals plus POWER grid elevation and city elevation
Citation text from NASA POWER included on the About tab

Tabs

Tab	What it holds
Monthly	720 rows: one row per city and month with temperature, precipitation, humidity, wind and solar irradiance.
Annual summary	One row per city with formula-based annual means, totals, warmest, coldest and wettest months.
Cities	City, country, ISO2, continent, coordinates, POWER grid elevation and city elevation.
About	Variable definitions, units, method, sources, license and the NASA POWER citation.

How to use it

Open the Monthly tab and filter by city, country or month with the header drop-downs.
Select a city's 12 rows and insert a line or column chart to see its year.
Read the Annual summary tab to compare cities by mean temperature, rainfall total or sunshine.
Use the Cities tab for coordinates, ISO2 codes and elevation, and join on city or country name.
Copy the credit line from the About tab when you publish results.

Columns and units

Column	Unit	Meaning
City	text	City name; coordinates rounded to 2 decimals from GeoNames.
Latitude / Longitude	decimal degrees	Location used for the POWER request.
Month	date (first of month)	Month of 2025, displayed as mmm yyyy.
Mean temperature at 2 m	°C	T2M: average air temperature at 2 m over the month.
Highest hourly temperature	°C	T2M_MAX: maximum hourly air temperature at 2 m in the month.
Lowest hourly temperature	°C	T2M_MIN: minimum hourly air temperature at 2 m in the month.
Precipitation, daily average	mm/day	PRECTOTCORR: MERRA-2 bias-corrected precipitation, monthly average of daily values.
Precipitation, month total	mm per month	PRECTOTCORR_SUM: accumulated corrected precipitation for the month (POWER labels its unit mm/day).
Relative humidity at 2 m	%	RH2M.
Wind speed at 2 m	m/s	WS2M: average wind speed at 2 m above the surface.
Solar irradiance	kWh/m²/day	ALLSKY_SFC_SW_DWN: global horizontal irradiance under all sky conditions.
POWER grid elevation	m	Elevation returned by POWER for the point (Cities tab).

Source and licence

NASA Langley Research Center, Prediction Of Worldwide Energy Resources (POWER), POWER Monthly and Annual API v2.10.0, licensed NASA open data policy (free and open sharing; citation requested by POWER). Retrieved 8 Oct 2026.

Cite as: The data was obtained from National Aeronautics and Space Administration (NASA) Langley Research Center's Prediction Of Worldwide Energy Resources (POWER) project funded through the NASA Earth Science Division. The data was obtained from the POWER Project's Monthly and Annual API 2.10.0 version on 2026/10/08 (https://power.larc.nasa.gov/).

Monthly point API, community RE, year 2025; meteorology from MERRA-2 (0.5 x 0.625 degree grid), solar radiation from CERES SYN1deg (1 degree). City coordinates, city elevations and IDs from GeoNames cities15000 (CC BY 4.0, https://www.geonames.org/). Values are unmodified; the 13th (annual) record of each response is excluded from the monthly table. POWER asks to be notified of publications and redistribution ([email protected]).

Good for

Comparing climates of cities for travel or relocation planning
Teaching material on seasons, monsoons and the Southern Hemisphere
Solar and heating or cooling feasibility screening
Charts and maps of temperature or rainfall by city
Sample data for pivot tables and dashboards

Questions about this sheet

Are these weather station readings?

No. POWER values come from the MERRA-2 reanalysis on a grid of 0.5 by 0.625 degrees and from satellite solar data, so each number describes a grid cell around the city and can differ from a station, especially near coasts and mountains.

Why are the highest and lowest temperatures so extreme?

POWER's monthly maximum and minimum are the single highest and lowest hourly temperatures in the month, not averages of daily highs and lows. Use the mean temperature column for typical conditions.

What unit is precipitation in?

Two columns are provided: the daily average in mm per day and the month total in mm. POWER labels the total's unit as mm/day, but the values are monthly sums, which the About tab shows.

Why 2025 and why one year only?

2025 is the latest complete calendar year in POWER at the time of retrieval. It is a single year of weather, not a long-term climate average.

How should I credit the data?

NASA asks users to state that the data came from the POWER project, with the service version and date accessed. The ready-to-use wording is on the About tab.