Historical forecast data

Economic forecast data in Excel

Know what professional economists expected, when they expected it, and how those expectations changed.

Structured historical and current Consensus Forecasts data for research, modelling and automation, with monthly updates and a consistent workbook structure.

Inside the historical databank

21 million+

A detailed record of what economists expected.

Each preserved forecast is linked to a survey date, economic variable and contributing forecaster. Together, these records make it possible to follow expectations across economies and market cycles.

The original survey vintages support research into revisions, disagreement and forecasting performance using the information available at the time.

Explore historical databases
THE HISTORICAL FORECAST RECORD 1989 — PRESENT
01 Survey date What economists expected at a particular point in time
02 Economic variable From headline growth and inflation to investment and consumption
03 Individual forecast Underlying estimates and differences between contributors
Consistent structure

Built for repeatable research workflows

Similarly defined variables are kept in consistent spreadsheet columns and consensus data appears in the same rows from survey to survey. The survey date is included, helping clients link the data into models, research systems and automated extraction processes.

  • Individual forecasts plus consensus mean, high, low and standard deviation
  • Historical survey databases for major countries and indicators
  • Consensus series for additional countries and selected exchange rate forecasts
  • Brent oil price forecasts and spot prices on the survey date
Example of historical and current Consensus Economics forecast data in Excel
Consistent spreadsheet structure makes historical databases easier to compare and integrate.
Consensus Forecasts TrendCharts example showing forecast changes through time
TrendCharts lets users visualise changes in consensus estimates across survey dates.
TrendCharts

See how expectations move over time

Regional Excel services include a TrendCharts workbook tab for quickly displaying forecast revisions through time. Users can select countries, variables, survey years and consensus statistics to build an immediate visual history of changing expectations.

Included in regional spreadsheet services TrendCharts has been included in the regional Excel services since late 2006.
What is included

More than a single consensus number

The regional monthly files provide the underlying distribution of professional forecasts as well as additional market series and tools.

Individual + consensus forecasts

Individual panel estimates alongside mean, high, low and standard deviation for the major countries and indicators covered by each regional survey.

Additional economies

Consensus means for selected variables in additional economies covered by the regional forecast publications.

Currency + oil forecasts

Selected exchange rate consensus forecasts plus Brent oil price expectations and the spot price on the survey date.

Historical databases

Past survey releases let researchers examine what professional forecasters expected at each point in time rather than only the latest forecast.

Delivery & access

Choose how you want to access the data

Work directly with Consensus Economics Excel files and databases of archived forecasts, or access selected datasets through established institutional research platforms.

Direct from Consensus Economics

Excel files + historical survey data

Access historical forecast records and ongoing spreadsheet updates for the services you subscribe to, with coverage and available formats varying by publication.

  • Historical survey data extending back to 1989
  • Monthly spreadsheet updates for ongoing research
  • TrendCharts included with regional Excel services
Institutional platforms

Use selected databases in your existing research stack

Selected Consensus Economics databases are also available as premium services through leading institutional data platforms.

Common questions

Practical questions about Excel data

Can the Excel files be used in automated workflows?

Yes. Our Excel datasets use consistent worksheets, field names and series references, making them straightforward to integrate into established analytical workflows. Explore API access.

That makes them well suited to macros, scripts and repeatable data pipelines in Python, R, VBA, Power Query and AI-enabled analytical workflows.

Can the historical data be used for backtesting?

Yes. Historical survey databases preserve the forecasts that were actually available at each point in time, allowing users to backtest models and strategies without reconstructing history from today's revised data. Historical data for institutions.

What sits behind the consensus mean?

The regional monthly files include individual panel forecasts alongside the consensus mean, high, low and standard deviation for major countries and indicators, giving users access to the distribution behind the headline number. How the consensus works.

How far back does the historical data go?

Consensus Economics has collected independent forecast surveys since 1989. Our historical databank contains more than 21 million individual forecasts across a wide range of economies, variables and survey periods. Read our history.

How do Excel data and forecast publications work together?

Excel datasets provide structured forecast figures for analysis and modelling, while the accompanying publications offer economic commentary and specialist survey material. Explore the full forecast publications.

Explore your data options

Find the forecast data that fits your research.

Explore a sample or tell our team which economies, variables and historical periods matter to you. We can help identify suitable datasets and access options.