{"id":6748,"date":"2026-05-04T00:01:39","date_gmt":"2026-05-03T23:01:39","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=6748"},"modified":"2026-05-04T23:28:00","modified_gmt":"2026-05-04T22:28:00","slug":"latest-gender-pay-gap-data","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/latest-gender-pay-gap-data\/","title":{"rendered":"Pay Gap Data #9 – Where can I find gender pay gap data for 2025?"},"content":{"rendered":"

The government requires nearly all employers with a headcount of 250 or more on their snapshot date to submit gender pay gap data.\u00a0 All data is available to the public and can be found on the government’s gender pay gap website<\/a>.\u00a0 I have downloaded this to create a more user friendly and visually informative spreadsheet for you to download and use.<\/p>\n

All data shown here is up to date as of 3rd May 2026.\u00a0 The next update is planned for July 2026.<\/em><\/p>\n

<\/p>\n

Download my spreadsheet!<\/strong><\/span><\/h5>\n
Gender Pay Gap Data & Chart Tool – 2026 v7.0<\/a><\/strong><\/span><\/h5>\n

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.<\/p>\n

**<\/strong> My spreadsheet is currently optimised for Excel in Windows.\u00a0 It does work in Excel for a Mac but I am aware of some features not working as intended on a Mac.\u00a0 As yet, I have not been able to resolve these issues. **<\/em><\/span><\/p>\n

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.\u00a0 Please bookmark this page or subscribe to my newsletter to be notified of updates (details are at the bottom of the page).<\/p>\n

 <\/p>\n

How many employers are included?<\/strong><\/span><\/h5>\n

The spreadsheet includes data submitted by 15,520<\/strong>\u00a0employers for the\"\"\u00a0March\/April snapshot date for at least one year between 2017<\/strong> & 2025<\/strong>.\u00a0 As of 3rd May 2026<\/strong>, 10,468<\/strong> employers who are required to report have submitted their 2025 data.\u00a0 This leaves 765<\/strong> employers who submitted 2024 data as required and may yet submit their 2025 data provided their 2025 headcount is 250+.\u00a0 If they\u00a0 do submit 2025 data, they will be recorded as late since we are past the deadline.<\/p>\n

However, based on the 2023 column in the table here, I expect ~440<\/strong> employers who reported 2024 data to not report 2025 data.\u00a0 This is because they will have either gone bust, merged with another employer or fallen below the 250 headcount threshold required for mandatory reporting.\u00a0 History tells us the employers who stop reporting are usually replaced with ~540<\/strong> new employers who now have to report their data of which 388<\/strong>\u00a0have already done so.\u00a0 Therefore, after adding in an expected ~450<\/strong> voluntary reporters, \u00a0the total number of employers eventually reporting data for the 2025 snapshot date should be ~11400<\/strong>.<\/p>\n

 <\/p>\n

A history of updates to the reported data<\/strong><\/span><\/h5>\n

5\/4\/25<\/strong> – 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.\u00a0 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.\u00a0 It is my intention to delete these duplicates at some point but the work involved is complicated.<\/em><\/p>\n

31\/3\/25<\/strong> – I have finally resolved an annoying feature with over 700 employer names.\u00a0 These employers formal company name begins with “The …” such as “The Arsenal Football Club Limited”.\u00a0 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.\u00a0 From version 2025 v5.0 onwards, such employers have their “The” moved to the end of their name as “(The)”.\u00a0 So “The Arsenal Football Club Limited” is now “Arsenal Football Club Limited (The)”.<\/em><\/p>\n

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

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

9\/7\/23<\/strong> – The GEO have removed around 110 employers who apparently no longer report pay gaps<\/a> from their downloads.\u00a0 An issue here is this includes employers who have merged to create a new employer.\u00a0 The data for the old employers is then removed from the downloads which is incorrect in my opinion.\u00a0 A high profile example is the Foreign & Commonwealth Office<\/a> and Department for International Development<\/a> who merged in 2021 to create the Foreign, Commonwealth & Development Office<\/a>.\u00a0 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.\u00a0 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.<\/em><\/p>\n

6\/3\/23<\/strong> – 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<\/a>.<\/em><\/p>\n

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

5\/4\/22<\/strong> – 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.\u00a0 So far, 9900 employers have reported 2021 data so it looks like 500 to 600 are late reporting.\u00a0 Therefore the 2021 data included may yet change again.<\/em><\/p>\n

10\/2\/22<\/strong> – The Government Equalities Office continues to do a lot work to resolve inconsistencies in employer names.\u00a0 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.<\/em><\/p>\n

20\/2\/21<\/strong> – The Equalities & Human Rights Commission the deadline for submitting 2020 data to 5th October 2021.\u00a0 Employers are required to submit 2020.\u00a0 The deadline for submitting 2021 data is still 5th April 2022.<\/em><\/p>\n

24\/3\/20<\/strong> –\u00a0 On 24th March, the government suspended enforcement of the deadline for reporting 2019 gender pay gaps<\/a> due to the coronavirus outbreak<\/a>.\u00a0 Just over 60% of employers reported their 2019 data and the remainder are no longer required to do so.<\/em><\/p>\n

 <\/p>\n

Overview of Spreadsheet<\/strong><\/span><\/h5>\n

There are three worksheets for you to make use of as well as a HELP<\/strong> sheet.<\/p>\n

EMPLOYERSUMMARY<\/strong><\/span><\/p>\n

This allows you to select an employer from a dropdown box in cell H2 and view a summary for that employer in three parts laid out from left to right –<\/p>\n

    \n
  1. On the left is basic information about the employer.<\/li>\n
  2. In the middle is a chart showing the key statistics of pay gap reporting<\/li>\n
  3. On the right is the data for all statistics for all years since 2017<\/li>\n<\/ol>\n

    A new feature in the 2026 and later versions is shown in the bottom left.\u00a0 This lists all employers who share the same signatory.\u00a0 This is a way of identifying employers are part of a conglomerate or who share the same owners.<\/p>\n

    \"\"<\/p>\n

    There are also some calculations of year on year trends and these provide clues as to whether the employer has entered its data correctly.\u00a0 You can find out more about this in my article “Year on Year Trends, the Good, Bad & Unilever<\/em><\/a>“.<\/p>\n

    LISTEMPLOYERS<\/strong><\/span><\/p>\n

    This lists all 15,300+<\/strong> employers included in the spreadsheet.\u00a0 There are filters at the top so you can filter out certain employers e.g. public sector employers who last reported in 2024 or 2025 and whose headcount is 20,000 or more employees as shown here.\u00a0 The list includes the median woman’s pay, gender swap number<\/a> and %FPRE who are women for the latest reported year.\u00a0 Finally the last two columns allow you to search for a specific word (entered in the yellow cell) in the employer name such as Trust<\/strong> as shown here and to make notes in the NOTES column.\u00a0 From this, you can create a list of 20<\/strong> employer names to be used in COMPAREEMPLOYERS.<\/strong><\/p>\n

    \"\"<\/p>\n

    Please note column A contains a formula read by EMPLOYERSUMMARY which should not be edited or deleted.<\/p>\n

    COMPAREEMPLOYERS<\/strong><\/span><\/p>\n

    This\u00a0is a feature which allows you to choose 20<\/strong> or more employers for a specific year and compare them side by side.\u00a0 It is currently preloaded with the 20<\/strong> teams from the English Premier League for the 2024\/25 season but you can overwrite these with your chosen employers.\u00a0 This list can then be viewed in EMPLOYERSUMMARY<\/strong> if you wish.<\/p>\n

    There are further suggested lists of 20<\/strong> employers shown in column AC.\u00a0 If you want, you can also copy and paste the formulas in columns A to S down to create a longer list with more than 20 employers.<\/p>\n

    HELP<\/strong><\/span><\/p>\n

    This gives you more information about each worksheet.\u00a0 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<\/em><\/a>“.<\/p>\n

     <\/p>\n

    Where can I find older versions of this spreadsheet?<\/strong><\/span><\/h5>\n

    Older versions of this spreadsheet for previous years are listed below.\u00a0 The value of looking at these is that some employers may have gone back and retrospectively changed what they reported in earlier years.\u00a0 By crosschecking one of the older versions here with the latest version, you can see if that has happened.<\/p>\n