Nominal vs. Real GDP: Build a Clear Comparison Table

Nominal GDP measures output at the prices prevailing during the period. Real GDP adjusts for price changes so you can compare output over time. If you’re publishing a GDP spreadsheet, put them in separate, explicitly labeled columns: a rise in nominal GDP does not necessarily mean more goods and services were produced. BEA’s GDP explainer makes this distinction.

Which measure should your table use?

GDP measures the value of final goods and services produced within an economy, avoiding double counting of intermediate goods and services. BEA’s definition provides the basis for its U.S. series.

Reader’s question	Measure to use	Label to preserve
What was the value of output at that period’s prices?	Nominal GDP	Current prices, currency, and scale
Did output grow after removing price changes?	Real GDP or real GDP growth	Constant-price or chained-volume basis; growth interval
How did prices for domestic output change?	GDP implicit price deflator	Index reference year = 100

“Current-dollar” and “current-price” are other names for nominal estimates. Real estimates exclude the effects of price changes. For U.S. data, BEA uses chain-weighted quantity measures rather than simply pricing every year’s output with one fixed set of prices. Preserve the source’s terminology: “billions of chained 2017 dollars” is more informative than “GDP in dollars.” BEA’s definitions and statistical conventions explain these labels and methods.

Calculate the difference in a sample spreadsheet

The GDP implicit price deflator is nominal GDP divided by its corresponding real GDP, multiplied by 100. Rearranging gives:

Real GDP = Nominal GDP / GDP deflator × 100

This requires the corresponding implicit deflator expressed as an index with its reference year equal to 100—not an inflation rate such as 10%. Match the geography, period, and data release, and preserve the deflator’s reference year. The calculated real GDP retains the nominal input’s currency and scale, with prices adjusted to that reference basis. BEA’s deflator definition establishes this relationship.

Here is an illustrative dataset, not observed country data. GDP values are in millions of hypothetical currency units; Year 1 is the reference year.

Period	Nominal GDP	GDP deflator (Year 1 = 100)	Real GDP	Real GDP growth (%)
Year 1	1000	100	1000	—
Year 2	1155	110	1050	5.0

Nominal GDP rose 15.5%, but real GDP rose 5%, while the deflator rose 10%. These changes combine multiplicatively: 1.05 × 1.10 = 1.155. The real-GDP calculation is 1155 / 110 × 100 = 1050; subtracting 10 percentage points from nominal growth would only be an approximation.

To reproduce this in Excel or Google Sheets, place the five headers in columns A–E and the observations in rows 2–3:

• In D2, enter =B2/C2*100 and fill down.
• In E3, enter =(D3/D2-1)*100 for the header “Real GDP growth (%).” Format as a number with one decimal place.
• Leave E2 empty because there is no earlier observation. The dash above represents that missing value, not zero.

If you instead use =D3/D2-1, apply percentage formatting and label the column “Real GDP growth.” Don’t multiply by 100 and then apply percentage formatting too.

For an actual publication, prefer the statistical agency’s published real GDP series when available; use this calculation to explain or cross-check the relationship.

Keep the comparison valid

Before exporting your file, check four things:

1. Frequency and growth interval. Keep annual and quarterly observations separate. BEA’s seasonally adjusted quarterly levels and percentage changes are generally reported at annual rates. An annualized quarterly growth rate is not the same as year-over-year growth. BEA’s conventions document this distinction.
2. The price index. Don’t substitute CPI for the GDP deflator. CPI measures consumer prices; the GDP price measures cover domestic production more broadly and exclude imports. BLS’s comparison explains their different scope.
3. Aggregation. Don’t sum chained-dollar components to reconstruct real GDP. They are not additive because the relative weights for a given period differ from those of the reference year. Use the published aggregate. BEA’s chained-dollar guidance explains why.
4. Release consistency. Record the release date and use one data vintage across the table. GDP estimates are revised, including historical observations, so an old nominal download and a newer real download may not align. BEA’s update policy describes these revisions.

Publish the values with their context

Keep numeric cells numeric: store 1155, not 1,155 million. Add fields or accompanying notes for geography, currency, scale, real-GDP reference year, seasonal adjustment, annual-rate status, source URL, release date, and retrieval date.

Export only the reviewed public-data sheet. TablePage accepts CSV, TSV, XLSX, and XLS files and turns an upload into a public dataset page with a shareable link and filterable table. After publication, check that the units and source notes remain visible and that numeric columns behave as numbers. Never include sensitive workbook contents in a public upload.

For the sample above, a useful caption is: “Illustrative nominal and real GDP, Years 1–2; values in millions of hypothetical currency units, with real GDP expressed at Year 1 prices.” For an observed dataset, name the geography, period, units, and source’s price basis instead. For a state-level application, see comparing GDP per state.