Dataset · Files and open data

Global temperature anomalies, 1880-2025 (NASA GISTEMP v4)

Monthly, annual, hemispheric and zonal global temperature anomalies from NASA GISTEMP, 1880-2025, with warming stripes.

Create an account

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

XLSXCSVODSXMLNumbers
Global temperature anomalies, 1880-2025 (NASA GISTEMP v4)
Source: NASA GISTEMP v4, Land-Ocean tables (tabledata_v4) · Retrieved 2026-10-09 · License: public domain (NASA); citation requested
2025 ANOMALYWARMEST YEAR ON RECORD
1.192024
Last complete year, vs 1951-1980Anomaly 1.29 °C, J-D
ANNUAL ANOMALY, LAST 50 YEARS (BLUE BELOW THE 1951-1980 MEAN, AMBER ABOVE)
YearAnomaly
1976-0.10
19770.18
19780.07
19790.16
19800.26
19810.32
19820.14

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

What does this dataset do?

This workbook holds NASA's GISTEMP version 4 global temperature anomalies for 1880 to 2025, in degrees Celsius relative to the 1951-1980 average. The Land-Ocean tables give monthly, annual and seasonal means for the globe, the Northern and Southern Hemispheres, and annual means for latitude bands. Every published value is kept as the source gives it; missing values stay blank.

The Stripes tab is a set of warming stripes: one narrow column per year, colored from the annual mean. The colors are fixed when the file is built. A Dashboard tab puts the headline figures, the last 50 years, decade averages and the ten warmest years on one page, with bars built from formulas. The Decades tab averages each decade with AVERAGE and shows the change from the decade before.

January to August 2026 is included where NASA has published it. Annual means are used only for complete years, so the last complete year is 2025. Read the About tab for the baseline, the color scales, the citation and the license.

What’s inside

  • Annual Land-Ocean global anomaly for 146 complete years, 1880-2025, plus monthly values for 2026 to August
  • Northern and Southern Hemisphere annual means with an NH minus SH formula
  • ZonAnn latitude-band means as published, with a key to every band
  • Decade averages by AVERAGE, change per decade, and the warmest year in each decade
  • Warming stripes for 1880-2025 with a fixed heat scale and a legend

Which tabs does the workbook have?

TabWhat it holds
DashboardHeadline KPIs, last 50 years of annual anomalies, decade averages, ten warmest years and a 40-year stripe strip.
StripesWarming stripes for 1880-2025, one column per year, with the annual anomaly under each column.
Global monthlyMonthly, annual and seasonal anomalies for the globe, with heat fills on the months.
HemispheresGlobal, Northern Hemisphere and Southern Hemisphere annual means, with NH minus SH.
ZonesAnnual means for 14 latitude bands and the hemispheres, as published.
DecadesDecade averages, change from the previous decade and the warmest year in each decade.
AboutBaseline, scales, sources, citation, license and known limits.

What formulas does this dataset use?

This dataset holds 1,132 formulas in 7,168 cells across 7 tabs, so 16% of its cells calculate. They use 12 distinct functions; the longest formula is 167 characters and 402 of them read from another tab.

FunctionUsesWhat it does
MAX937largest value
ISNUMBER760true for a number
IF754one result when a test is true, another when false
AND468true when every test is true
ROUND465rounds to a number of digits
REPT462repeats text
MIN455smallest value
INDEX36value at a position in a range
MATCH36position of a value in a range
LARGE20nth largest value
AVERAGE17mean of numbers
COUNT15counts numeric cells

Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.

How do you use it?

  1. Open the Dashboard for the headline figures and the last 50 years of annual anomalies.
  2. Use the Global monthly tab to filter a month or season by year, using the header filters.
  3. Read the Decades tab to compare each decade with the one before it.
  4. Copy a year's anomaly from the Hemispheres or Zones tab; each value is the published figure.
  5. Cite the source as given on the About tab when you publish a chart or table.

What do the columns and units mean?

ColumnUnitMeaning
YearyearCalendar year.
Jan to Dec°CMonthly global anomaly relative to 1951-1980 (Land-Ocean index).
J-D°CJanuary to December mean anomaly; blank for incomplete years.
D-N°CDecember of the previous year to November mean anomaly.
DJF, MAM, JJA, SON°CSeasonal mean anomalies as published by GISTEMP.
Global J-D, NH J-D, SH J-D°CAnnual mean anomaly for the globe, the Northern Hemisphere and the Southern Hemisphere.
NH minus SH°CFormula: Northern Hemisphere J-D minus Southern Hemisphere J-D.
ZonAnn bands°CAnnual mean anomaly for each latitude band (key on the Zones tab).
Decade average°CAVERAGE of the annual J-D values in the decade.
Change from previous decade°CDecade average minus the previous decade average.

Where does the data come from?

NASA GISS Surface Temperature Analysis (GISTEMP) v4, licensed Public domain (NASA data are not subject to copyright in the United States); citation requested. Retrieved 9 Oct 2026.

Cite as: GISTEMP Team, 2026: GISS Surface Temperature Analysis (GISTEMP), version 4. NASA Goddard Institute for Space Studies. Dataset accessed 2026-10-09 at https://data.giss.nasa.gov/gistemp/.

Land-Ocean tables GLB, NH, SH (Ts+dSST) and ZonAnn from tabledata_v4; base period 1951-1980; anomalies in degrees Celsius. Missing values (***) are blank. Values are updated monthly and may be revised; the last year may be partial. Methods: Lenssen, N., G. Schmidt, J. Hansen, M. Menne, A. Persin, R. Ruedy, and D. Zyss, 2019: Improvements in the GISTEMP uncertainty model. J. Geophys. Res. Atmos., 124, no. 12, 6307-6326, doi:10.1029/2018JD029522.

What is it good for?

  • Charting the global temperature record for a class or report
  • Comparing a decade, a month or a hemisphere with the 1951-1980 baseline
  • Building warming stripes for a presentation
  • Checking how far the latest year sits above the 1880-1900 average

Questions about this sheet

What does an anomaly of 1.00 mean?

It means the year's mean was 1.00 degree Celsius warmer than the 1951-1980 average. The figure is a departure from that baseline, not an absolute temperature.

Why does the last year have blank cells?

NASA publishes months as they become available. The file includes January to August 2026, and leaves later months and the annual mean blank.

Are the colors in the stripes calculated by formula?

No. The colors are static fills set when the workbook was built from the published annual means. The numbers under the stripes are formulas that read the Global monthly tab.

Can I use this data in a report?

Yes. NASA data are public domain in the United States and NASA asks for the citation given on the About tab.