Where can I find gender pay gap data in the UK?

This post was updated on 6th October 2025. The next update is planned for early January 2026.

The government requires nearly all employers with a headcount of 250 or more on their snapshot date 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 to present the data in a more user-friendly and visual format.

Download my spreadsheet!

Gender Pay Gap Data & Chart Tool – 2025 v8.0

You are welcome to make use of the charts and tables within this spreadsheet but I would appreciate it if you could credit me with the creation of these.

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. As yet, I have not been able to resolve these issues.

I update this spreadsheet at the start of each quarter with more frequent updates in the run up to the deadlines of 30th March/4th April. Please bookmark this page or subscribe to my newsletter to be notified of updates (details are at the bottom of the page).

What data is included?

The spreadsheet includes data submitted by 15,079 employers for the March/April snapshot date for at least one year between 2017 & 2024. As of 5th October 2025, 10,773 employers who are required to report have submitted their 2024 data. This leaves 475 employers who submitted their 2023 data as required and may yet submit their 2024 data provided their 2024 headcount is 250+. If they do submit 2024 data, they will be recorded as late since we are past the deadline.

However, based on the 2022 column in the table here, I expect ~400 employers who reported 2023 data to not report 2024 data. This is because they will have either gone bust, merged with another employer or fallen below the 250 headcount threshold required for mandatory reporting. After adding in the 461 voluntary reporters, the total number of employers eventually reporting data for 2024 should be ~11,300.

A history of updates to the reported data

5/4/25 – My colleagues at Spktral told me the number of employers who submit the same data as they did in the previous years is higher than I had previously thought. It turns out around 300 employers have done this at some point or another so in my spreadsheet download, the error line in row 10 now reads “DuplYr” if the data is the same as the previous year. It is my intention to delete these duplicates at some point but the work involved is complicated.

31/3/25 – I have finally resolved an annoying feature with over 700 employer names. These employers formal company name begins with “The …” such as “The Arsenal Football Club Limited”. Until now, when you looked for Arsenal in an alphabetically sorted list, you would expect to find them near the top but in fact they are near the bottom. From version 2025 v5.0 onwards, such employers have their “The” moved to the end of their name as “(The)”. So “The Arsenal Football Club Limited” is now “Arsenal Football Club Limited (The)”.

13/5/24 – I have finally removed some ~100 duplicate employers from the spreadsheet. This is a task I set myself years ago but I recently realised they were not being removed from the spreadsheet.

1/4/24 – The GEO has finally restored historical data for ~700 employers who had stopped reporting for whatever reason. This reverses the error noted in my update below for 9/7/23. 2023 v4.0 of my spreadsheet had data for 13,462 whilst v5.0 now has 14,188. Most of those restored stopped reporting in 2017 & 2018.

9/7/23 – The GEO have removed around 110 employers who apparently no longer report pay gaps from their downloads. An issue here is this includes employers who have merged to create a new employer. The data for the old employers is then removed from the downloads which is incorrect in my opinion. A high profile example is the Foreign & Commonwealth Office and Department for International Development who merged in 2021 to create the Foreign, Commonwealth & Development Office. The old data can still be found on the GEO website (click the names to see) but not in the downloads and hence not in my spreadsheet. I intend to try and restore the lost data if possible but you can download older versions of my spreadsheet at the bottom of this page which will include these lost employers.

6/3/23 – I have added some new features to the downloadable spreadsheet which flag suspicious data based on a comparison between the median hourly pay for women and the gender swap number per 1,000 employees.

8/4/22 – There appears to be some employers who have reported pay gaps but not the pay quarter data. Curiously this only affects 2020 & 2021. I have been told this is the result of the GEO changing their portal and inadvertently allowing some employers to do this.

5/4/22 – Even more cleaning of names have been done by the GEO and me so you may need to check for your employer under a different name. So far, 9900 employers have reported 2021 data so it looks like 500 to 600 are late reporting. Therefore the 2021 data included may yet change again.

10/2/22 – The Government Equalities Office continues to do 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.

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.

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. 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“.

**Update 6/10/25 – the layout of the year on year trends section of the graphic below was changed and the Pay Half table was added.**

The LISTEMPLOYERS sheet is a list of all 15,000+ employers included in the spreadsheet. There are filters at the top so you can filter out certain employers e.g. public sector employers who last reported in 2023 and state they have 20,000+ employees as shown here. The list includes the median woman’s pay, gender swap number and gender balance for the latest reported year. Finally the last column allows you to search for a specific word (entered in the yellow cell) in the employer name such as NHS as shown here. From this, you can create a list of 20 employer names to be used in COMPAREEMPLOYERS.

The COMPAREEMPLOYERS sheet is a feature which 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 2023/24 season but you can overwrite these with your chosen employers. This list can then be viewed in EMPLOYERSUMMARY if you wish.

There is a HELP sheet which you 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. The value of looking at these is that some employers may have gone back and retrospectively changed what they reported in earlier years. By crosschecking one of the older versions here with the latest version, you can see if that has happened.

Where can I find ONS data for the UK gender pay gap?

The Office of National Statistics (ONS) have been estimating the UK gender pay gap since 1997 using a random sample of HMRC records. This data is not comparable with employer level data published by the GEO but it does provide additional context to debates around the gender pay gap such as pay gaps by occupation. For more details and links to the data, please read this blog.

Where can I find ethnicity pay gap data?

Employers are not required to report ethnicity pay gaps and there is no central database of those employers who do publish. The ONS provides UK level estimates for ethnicity pay gaps between 2012 and 2022 which can be found here.

The government has just closed a consultation on making ethnicity & disability pay gap reporting by employers mandatory. You can read my in-depth response to the consultation here.

— 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.