GLA Population Projections - Custom Age Tables

Excel age range creator for GLA Projections data

This Excel based tool enables users to query the raw single year of age data so that any age range can easily be calculated without having to carry out often complex, and time consuming formulas that could also be open to human error. Each year the GLA demography team produce sets of population projections. On this page each of these datasets since 2009 can be accessed, though please remember that the older versions have been superceded. From 2012, data includes population estimates and projections between 2001 and 2041 for each borough plus Central London (Camden, City of London, Kensington & Chelsea, and Westminster), Rest of Inner Boroughs, Inner London, Outer London and Greater London.

The full raw data by single year of age (SYA) and gender are available as Datastore packages at the links below.

How to use the tool: Simply select the lower and upper age range for both males and females (starting in cell C3) and the spreadsheet will return the total population for the range.

Tip: You can copy and paste the boroughs you are interested in to another worksheet by clicking: Edit then Go To (or Control + G), then Special, and Visible cells only. Then simply copy and 'paste values' of the cells to a new location.

Warning: The ethnic group and ward files are large (around 35MB), and may take some time to download depending on your bandwidth.

Find out more about GLA population projections on the GLA Demographic Projections page

BOROUGH PROJECTIONS

GLA 2009 Round London Plan Population Projections (January 2010) (SUPERSEDED)

GLA 2009 Round (revised) London Plan Population Projections (August 2010) (SUPERCEDED)

GLA 2009 Round (revised) SHLAA Population Projections (August 2010) (SUPERCEDED)

GLA 2010 Round SHLAA Population Projections (February 2011) (SUPERCEDED)

GLA 2011 Round SHLAA Population Projections, High Fertility (December 2011) (SUPERCEDED)

GLA 2011 Round SHLAA Population Projections, Standard Fertility (January 2012) (SUPERCEDED)

GLA 2012 Round SHLAA Population Projections, (December 2012)(SUPERCEDED)

GLA 2012 Round Trend Based Population Projections, (December 2012) (SUPERCEDED)

GLA 2012 Round SHLAA Borough Projections incorporating DCLG 2011 household formation rates, (June 2013) (SUPERCEDED)

GLA 2013 Round Trend Based Population Projections - High (December 2013)

GLA 2013 Round Trend Based Population Projections - Central (December 2013)

GLA 2013 Round Trend Based Population Projections - Low (December 2013)

GLA 2013 Round SHLAA Based Population Projections (February 2014) Spreadsheet now includes national comparator data from ONS.

GLA 2013 Round SHLAA Based Capped Population Projections (March 2014) Spreadsheet includes national comparator data from ONS. This is the recommended file to use.

WARD PROJECTIONS

GLA 2008 round (High) Ward Projections (March 2009) (SUPERSEDED)

GLA 2009 round (revised) London Plan Ward Projections (August 2010) (SUPERCEDED)

GLA 2010 round SHLAA Ward Projections (February 2011) (SUPERCEDED)

GLA 2011 round SHLAA Standard Ward Projections (January 2012) (SUPERCEDED)

GLA 2011 round SHLAA High Ward Projections (January 2012) (SUPERCEDED)

GLA 2012 round SHLAA based Ward Projections (March 2013) (XLS) (SUPERCEDED)

GLA 2012 round SHLAA Ward Projections (March 2013) (XLS) (SUPERCEDED)

GLA 2013 round SHLAA Ward Projections (March 2014)

GLA 2013 round SHLAA Capped Ward Projections (March 2014) This is the recommended file to use.

ETHNIC GROUP PROJECTIONS FOR LOCAL AUTHORITIES

GLA 2012 Round SHLAA Ethnic Group Borough Projections - Interim (May 2013) (SUPERCEDED)

GLA 2012 Round Trend Based Ethnic Group Borough Projections - Interim (May 2013) (SUPERCEDED)

GLA 2012 Round SHLAA Based Ethnic Group Borough Projections - Final (Nov 2013) (SUPERCEDED)

GLA 2012 Round Trend Based Ethnic Group Borough Projections - Final (Nov 2013) (SUPERCEDED)

GLA 2013 Round SHLAA Capped Ethnic Group Borough Projections (August 2014)