Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementHR Analytics & DashboardsDiversity and Inclusion Metrics Tracker

SpreadsheetHR Analytics & DashboardsFree

Diversity and Inclusion Metrics Tracker

Measure representation by level, compare hiring and promotion rates, and track progress against your DEI targets.

Shown with sample data

Colour

Diversity and Inclusion Metrics Tracker

Measure representation by level, compare hiring and promotion rates, and track progress against your DEI targets.

Total headcount
310
Women overall
48%
Women in leadership
33%
Executive and senior leadership
Ethnic diversity overall
31%
Levels behind target
3
Women share of hires
39%
Women share of promotions
39%
Applicant-to-hire rate (all)
2.3%
Women representation by level
  • Executive25%
  • Senior leadership36.4%
  • Manager43.5%
  • Senior professional42.6%
  • Professional51.2%
  • Frontline and support54.2%
Women share at each pipeline stage
  • Applicants45.4%
  • Interviewed41.3%
  • Offers made38.7%
  • Hires38.9%
  • Promotions39.3%
  • Leavers46.3%

How to use it

  1. 1Export headcount and voluntary self-identification data from your HR system for each level.
  2. 2Enter counts (not percentages) on the Representation sheet and set a target for women at each level.
  3. 3Enter counts for each stage of hiring and promotion on the Pipeline sheet.
  4. 4Review levels marked Behind and pipeline stages where the share falls, and agree actions.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Turn diversity data into a clear picture of representation and progress. Enter headcount by level with the number of women, ethnically diverse employees and people who self-identify as disabled; the tracker calculates representation percentages, compares women’s representation with your target at each level, then follows the pipeline from applicants to hires and promotions so you can see where under-represented groups drop out.

Who it’s for

  • Quarterly DEI reporting to leadership or the board
  • Setting and tracking representation targets
  • Finding pipeline stages where diverse candidates drop out

What’s included

  • Representation sheet: Headcount and representation at each level.
  • Pipeline sheet: Representation at each stage of hiring, promotion and leaving this year.

How to use it

  1. 1Export headcount and voluntary self-identification data from your HR system for each level.
  2. 2Enter counts (not percentages) on the Representation sheet and set a target for women at each level.
  3. 3Enter counts for each stage of hiring and promotion on the Pipeline sheet.
  4. 4Review levels marked Behind and pipeline stages where the share falls, and agree actions.

Tips

  • Self-identification data must be voluntary and confidential; explain why you collect it and how it is protected.
  • Do not report groups smaller than five people: individuals could be identified.
  • Look at movement (hiring, promotion, leaving) as well as snapshots; representation changes only when the flows change.

Questions

What DEI metrics should we track?

Representation by level and department, hiring and promotion rates by group, turnover by group, pay equity and inclusion survey scores. Start with representation and pipeline, then add others.

How do I calculate representation?

Number of people in a group ÷ total headcount in that level or team. For example, 12 women out of 30 managers is 40% representation.

Is it legal to collect diversity data?

In many countries yes, on a voluntary basis with appropriate privacy safeguards; some data (such as US EEO-1 reports) is required for larger employers, while some countries restrict collecting ethnicity data. Check local law.

How should we set DEI targets?

Base them on your current position, the available labour market and realistic hiring and promotion volumes over the target period. Targets should drive action, never quotas for individual decisions.

Related searchesdiversity metrics templatedei dashboard exceldiversity and inclusion trackerworkforce representationdei metricsdiversity report template

Details

Format
Spreadsheet
Category
HR Analytics & Dashboards
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHR Analytics & DashboardsFree

Diversity and Inclusion Metrics Tracker

Measure representation by level, compare hiring and promotion rates, and track progress against your DEI targets.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
HR Analytics & Dashboards
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More hr analytics & dashboards templates

View all
HR Metrics Dashboard2 sheets

Headcount now

89

Annualised turnover

26%

Voluntary share of leavers

87%

Headcount at end of month
SpreadsheetHR Analytics & Dashboards

HR Metrics Dashboard

Headcount, joiners, leavers, turnover and absence by month, with the year’s rates worked out.

10 min setupPreview

Employee Engagement Survey

This survey is anonymous and takes about five minutes. Please answer honestly.

Department *

EngineeringSalesMarketing

How long have you worked here? *

Less than 1 year1 to 3 yearsMore than 3 years

I understand how my work contributes to the company’s goals *

Strongly agreeAgreeNeutral
Submit survey
FormHR Analytics & Dashboards

Employee Engagement Survey

Fifteen questions on purpose, manager, growth, workload and belonging, plus the eNPS question.

10 min setupPreview
Employee Turnover and Retention Analysis5 sheets

Current headcount

226

Annual turnover

21%

Voluntary turnover

17%

ABCD
1MonthNew hiresVoluntary leaversInvoluntary leavers
2Jan 2027631
3Feb 2027420
4Mar 2027841
5Apr 2027552
Monthly
SpreadsheetHR Analytics & Dashboards

Employee Turnover and Retention Analysis

Track monthly headcount, hires and leavers, and calculate voluntary, involuntary and annualised turnover and retention.

25 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ