Excel Mapping Template for London Boroughs and Wards

A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets. * * * Borough maps ------------ * [Map for quantitative data](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/58f59b22-946e-43e9-96fd-c0a4fa27f76a/Mapping-template-for-London-boroughs.xls) * [Map for categorical data](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/49ad2541-74d8-48a9-b147-6bcbede9c25f/Mapping-template-for-London-boroughs-categoric.xls) * [Cartogram that uses squares to represent London Boroughs](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/9f29d8f0-5ce3-447f-b7e3-48d10a9ef4dd/London-squares-cartogram-map.xlsx) * * * Ward maps --------- ### Pre-2014 boundaries * [Greater London](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/b544fbf1-5492-4a79-b890-b5b66197d4e2/Mapping-template-london-ward-map-2013.xls) * Individual Boroughs: [Barking and Dagenham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-B&D.xls), [Barnet](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Barnet.xls), [Bexley](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Bexley.xls), [Brent](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Brent.xls), [Bromley](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Bromley.xls), [Camden](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Camden.xls), [Croydon](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Croydon.xls), [Ealing](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ealing.xls), [Enfield](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Enfield.xls), [Greenwich](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Greenwich.xls), [Hackney](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hackney.xls), [Hammersmith and Fulham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hammersmith&Fulham.xls), [Haringey](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Haringey.xls), [Harrow](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Harrow.xls), [Havering](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Havering.xls), [Hillingdon](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hillingdon.xls), [Hounslow](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hounslow.xls), [Islington](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Islington.xls), [Kensington and Chelsea](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ken&Chel.xls), [Kingston upon Thames](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Kingston.xls), [Lambeth](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Lambeth.xls), [Lewisham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Lewisham.xls), [Merton](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Merton.xls), [Newham](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Newham.xls), [Redbridge](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Redbridge.xls), [Richmond upon Thames](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Richmond.xls), [Southwark](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Southwark.xls), [Sutton](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Sutton.xls), [Tower Hamlets](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Tower-Hamlets.xls), [Waltham Forest](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Waltham-Forest.xls), [Wandsworth](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Wandsworth.xls), [Westminster](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Westminster.xls) ### 2014 boundaries Includes the new ward boundaries for Hackney, Kensington and Chelsea, and Tower Hamlets following changes in May 2014. * [Greater London](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/16d8ca83-c2d8-45a7-aa7f-a584efd1aed6/Mapping-template-london-ward-map-2014.xls) * Individual boroughs: [Hackney](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Hackney-2014.xls), [Kensington and Chelsea](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Ken&Chel-2014.xls), [Tower Hamlets](https://londondatastore-upload.s3.amazonaws.com/Mapping-template-for-wards-Tower-Hamlets-2014.xls) ### 2018 boundaries Includes the new ward boundaries for Bexley, Croydon, Redbridge, and Southwark following changes in May 2018 * [Greater London](https://data.london.gov.uk/download/excel-mapping-template-for-london-boroughs-and-wards/41ef01e0-2c93-4aea-9c99-f0a7258ef988/Mapping-template-london-ward-map-2018.xls) * Individual boroughs: [Bexley](https://londondatastore-upload.s3.eu-west-1.amazonaws.com/Mapping-template-for-wards-Bexley-2018.xls), [Croydon](https://londondatastore-upload.s3.eu-west-1.amazonaws.com/Mapping-template-for-wards-Croydon-2018.xls), [Redbridge](https://londondatastore-upload.s3.eu-west-1.amazonaws.com/Mapping-template-for-wards-Redbridge-2018.xls), [Southwark](https://londondatastore-upload.s3.eu-west-1.amazonaws.com/Mapping-template-for-wards-Southwark-2018.xls) * * * Macros ------ The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet. To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes. In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros. To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these [instructions](https://londondatastore-upload.s3.amazonaws.com/create-excel-map-instructions.pdf). You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords. * * * Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights." NOTE: Excel 2003 users must 'ungroup' the map for it to work.