This post was updated on 3rd January 2022 with the latest data
The government requires all organisations employing 250 or more employees to submit gender pay gap data. All data is available to the public and can be found on the government’s gender pay gap website. I have downloaded this data and created a spreadsheet tool to present the data in a more user-friendly and visual format.
Download my spreadsheet!
You are very welcome make use of the charts and tables within this spreadsheet but I would appreciate it if you could credit me with the creation of the charts.
IMPORTANT! – The workbook is currently optimised for Excel in Windows. It does work in Excel for a Mac but I am aware of some features not working as intended on a Mac. I am in the process of trying to correct the Mac issues.
I will make a point of keeping this spreadsheet up to date as employers upload new data so please bookmark this page and come back to see if the version number has changed. Alternatively why not subscribe to my newsletter to be notified of updates (details are at the bottom of the page). I will also let you know via my twitter feed if changes have been made.
What data is included?
This spreadsheet includes data submitted by 12,000+ employers for the April snapshot pay period for the years of 2017, 2018, 2019, 2020 & 2021. So far 1100+ employers have submitted 2021 data.
From the end of April 2021, employers can submit their 2021 data and not wait for the deadline of April 2022.
Update 3/1/22 – The Government Equalities Office has done a lot work to resolve inconsistencies in employer names. I had already done most of this work in the past but it is possible that an employer you used to look for in earlier versions of the downloadable spreadsheet is now appearing under a different name.
Update 20/2/21 – The Equalities & Human Rights Commission the deadline for submitting 2020 data to 5th October 2021. Employers are required to submit 2020. The deadline for submitting 2021 data is still 5th April 2022.
Update 24/3/20 – On 24th March, the government suspended enforcement of the deadline for reporting 2019 gender pay gaps due to the coronavirus outbreak. Just over 60% of employers reported their 2019 data and the remainder are no longer required to do so.
Overview of Spreadsheet
The EMPLOYERSUMMARY sheet summarises an employer’s gender pay gap data as shown in the graphic below for the latest year’s data submitted. You can select the employer you want to view from the dropdown box (please note there can be over 12,000 employers!). There are also some calculations of year on year trends and these provide clues as to whether the employer has entered its data correctly and you can find out more about this in my article “Year on Year Trends, the Good, Bad & Unilever“.
The COMPAREEMPLOYERS sheet is a feature that allows you to choose 20 employers for a specific year and compare them side by side. It is currently preloaded with the 20 teams from the English Premier League for the 2019/20 season but you can overwrite with your chosen employers. A full list of employers in given in column R of this sheet. On the EMPLOYERSUMMARY sheet you can restrict the list of employers in the menu box to just your chosen list of 20 employers. Instructions are given in the HELP and COMPAREEMPLOYERS sheet.
There is an ISSUES sheet which highlights some organisations that appear to have made errors.
There is a HELP sheet which youth can read for more information. The spreadsheet contains links which provide more explanation of what is being presented but you will find most of this information in my article “7 ways to misuse gender pay gap data“.
Where can I find older versions of this spreadsheet?
Older versions of this spreadsheet for previous years are listed below.
— Would you like to comment on this article? —-
If you have any comments or questions about my spreadsheet, please do contact me.
— Subscribe to my newsletter to receive more articles like this one! —-
If you would like to receive notifications from me of news, articles and offers relating to diversity & pay gaps, please click here to go to my Newsletter Subscription page and tick the Diversity category and other categories that may be of interest to you. You will be able to unsubscribe at anytime.
— Want to know more about pay gaps? —
You will find a full list of my pay gap & diversity related articles here which are grouped by theme.
— Need help with understanding your pay gap? —
I offer the following services. Please click on the headings for more details.
- Analysis – I can dig deep into your data to identify the key drivers of your pay gaps. I can build a model using a large number of variables such as pay band, seniority, job function, location, etc and use this to identify the priority areas for closing your gaps.
- Training – I run training courses in basic statistics which are designed for non-statisticians such as people working in HR. The courses will show you how to perform the relevant calculations in Microsoft Excel, how to interpret what they mean for you and how to incorporate these in an action plan to close your gaps.
- Expert Witness – Has your gender pay gap data uncovered an issue resulting in legal action? Need an expert independent statistician who can testify whether the data supports or contradicts a claim of discrimination? I have experience of acting as an expert witness for either plaintiff or defendant and I know how to testify and explain complex data in simple language that can be easily understood by non-statisticians.
If you would like to have a no-obligation discussion about how I can help you, please do contact me.