Skills Matrix Template (Free - for Bids, Tenders & Team Capability)
Download this template - free
Create a free SUNAGO account to download this template (Word & PDF) from your Templates library - and generate your own, pre-filled from your live project data.
A skills matrix template is a single grid that maps your team’s competencies against the skills a project or tender demands - people down one axis, skills across the other, a rating in every cell. It is free to download: create a free account to get the PDF and the editable Excel version, then use the guide to fill it in and turn it into capability evidence for your next bid.
Get the skills matrix template - free to download:
- The print-ready PDF - A4 and US Letter.
- The editable Excel version - the .xlsx (rating legend and example team included), and the option to generate your own matrix from your live team data.
Every file is free. Create a free account to download - that is the only step.
Once you have the editable version, prefer Google Sheets? Upload the .xlsx to Google Drive and open it with Sheets - the grid, formulas, and conditional formatting convert cleanly. The file ships with a filled-in team skills matrix from a fictional engineering consultancy, so you adapt a working example rather than build a grid from scratch.
Is there a free skills matrix template?
Yes - this is a genuinely free skills matrix template, not a locked preview or a time-limited demo. Both the PDF and the editable Excel version cost nothing; the free SUNAGO account is what unlocks the download, and it also generates a bid-ready matrix from your own team data. It comes from the same free suite as SUNAGO’s free capability statement software, which shares one project and people database.
What this skills matrix is for - a bid capability matrix, not an HR scorecard
Two very different documents share the name “skills matrix,” and mixing them up wastes a submission. The first is an internal HR tool: a competency matrix template used to rate staff privately for appraisals, pay, and training plans. The second - the one this template is built for - is external capability evidence: a grid that proves to a client or tender evaluator that the specific team you propose holds every discipline, certification, and sector skill the contract requires.
Buyers increasingly ask for it directly. A tender that requests CVs for key personnel is really asking a team-level question - does this group, together, cover the work? A capability matrix answers that in one scannable page, which is why firms that sell expertise now submit one alongside individual CVs and their capability statement. This page’s template is scoped for that use: every rating is meant to be shared, and every high rating is meant to be backed by a reference a buyer can check. The matrix itself is one view of a broader skills inventory - your firm’s full record of who holds which skills - filtered down to the people and requirements a specific bid names.
What’s inside the template
The template is one grid with a fixed structure, because a fixed structure is what makes a matrix scannable:
| Element | Content | What it proves |
|---|---|---|
| Skill rows | Competencies grouped by category (discipline, software, certification, sector) | The capabilities the buyer named |
| People columns | Named staff you would propose, plus bench depth | Who holds each capability |
| Rating cells | 0-4 proficiency score per person-skill | Depth, not just presence |
| Rating legend | The published meaning of each score | That ratings are consistent and honest |
| Evidence column | Link to CV, certificate, or project reference | That each rating is verifiable |
| Requirement column | The tender criterion each skill answers | That the team covers the whole scope |
The rating legend and the evidence column are the load-bearing parts. A team skills matrix without a defined scale is a wall of numbers a reviewer cannot trust; the same matrix with a published 0-4 scale and a reference behind each expert score reads as evidence.
How to build a firm-wide skills matrix
- List the competencies that win your firm work. Start with the skills a buyer actually screens for - disciplines, software, certifications, and sector experience named in the tenders you pursue. List them down the rows, grouped by category, not every skill an HR system could track.
- Add your people as columns. Put each named staff member across the top. For a bid matrix, include the specific people you would propose, plus the wider team that proves depth and resilience behind them.
- Rate each competency on a defined scale. Score every person-skill cell on a simple, published scale - for example 0 (none) to 4 (expert, can lead) - and write the scale into the legend so an external reviewer reads the ratings the same way you do.
- Attach evidence to every high rating. For each expert-level score, link the CV, certificate, or project reference that proves it. A rating with no evidence is an assertion; a rating with a reference attached is capability a buyer can verify.
- Map the matrix to the bid’s requirements. Add a column that ties each competency to the specific tender requirement or selection criterion it answers, so the evaluator sees your team covers every capability the contract demands.
- Export to PDF and keep the source current. Export a clean PDF on A4 or Letter for the submission, and keep the working Excel or Google Sheets version as the single source you update as people, certifications, and projects change.
Skills matrix example: filled in
The template ships with a complete example from Meridian Engineering Consultants, a fictional 45-person civil and environmental engineering firm bidding for a municipal water framework. Here is how one slice of the filled grid reads:
| Competency | Requirement it answers | A. Osei | R. Vance | L. Duarte | Team peak |
|---|---|---|---|---|---|
| Process design (water treatment) | Lead designer, 10+ yrs | 4 | 2 | 1 | 4 |
| Hydraulic modeling (InfoWorks) | Named modeling capability | 3 | 4 | 0 | 4 |
| Chartered engineer (CEng) | Mandatory for design lead | 4 | 0 | 3 | 4 |
| Construction-phase engineering | Site supervision experience | 2 | 3 | 4 | 4 |
| Environmental permitting | Regulatory liaison | 1 | 2 | 4 | 4 |
Legend: 0 = none · 1 = aware · 2 = working · 3 = proficient · 4 = expert, can lead. Every 4 in the live file links to the person’s CV and a project where they held that role. The “team peak” column is what an evaluator scans first: it shows the firm fields at least one expert against every requirement, with a second name behind each - the capability-matrix pattern that survives screening.
How the skills matrix maps to bid requirements
A team skills matrix earns its place in a submission when it answers the tender line by line. Read the selection criteria, pull out each named capability, and make it a row. The requirement column then does the evaluator’s job for them: beside “hydraulic modeling capability” sits the person rated 4 and the project reference that proves it. Where a requirement is mandatory - a chartered lead, a specific certification - the matrix shows both the primary holder and the backup, which is how you demonstrate resilience rather than a single point of failure. Presented next to individual capability statement content and CVs, the matrix is the bridge from “our firm can do this” to “this named team does.”
Where each rating comes from - build it from a CV & skills database
The slow way to produce a capability matrix is to rebuild the grid every deadline, chasing certifications and project roles across old proposals. The reliable way is to store each rating once and treat the matrix as an output. Map the template’s cells to your records:
| Template field | Where it should live |
|---|---|
| Skill rows | A shared competency framework, defined once for the firm |
| Rating cells | Each person’s skills profile, rated and dated |
| Evidence column | The CV and project references tied to that person |
| Requirement column | The specific tender’s selection criteria |
Store competencies once and you regenerate a tailored competency matrix template for any bid in minutes; skip it and every submission restarts from a blank grid. A project reference sheet per person-project is the minimum viable evidence layer behind the ratings.
What the evaluator checks first
Before anyone weighs your numbers, reviewers screen a capability matrix for a few disqualifiers. Public procurement makes the expectation explicit: EU rules let buyers require evidence of “the educational and professional qualifications” of the team and a list of relevant works (Directive 2014/24/EU, Annex XII), and US federal buyers verify capability and past performance through SAM.gov. On a skills matrix, that first pass looks for:
- Coverage - an expert against every mandatory requirement, not gaps hidden in a wall of 2s.
- Depth - a second name behind each critical skill, so the firm is not one resignation from non-compliance.
- Honesty - a defined rating scale and no suspiciously perfect column; inflated ratings collapse at interview.
- Verifiability - a CV or reference behind every top score, because an unevidenced 4 counts for nothing.
Build those four checks into the grid and the matrix strengthens the whole submission instead of raising questions.
Keep the matrix current - regenerate, don’t rewrite
A skills matrix is out of date the moment a certification lapses or a new hire arrives. The free CV and skills management tool from SUNAGO stores each person’s competencies, ratings, CVs, and project references once, then regenerates a bid-ready skills matrix - filtered to the people and skills a specific tender names - from the live data. Update a certification once and every matrix that uses it updates too. Create a free account to download the template and generate your own matrix from your team data.
Related templates and guides
- Project portfolio template - pair the team matrix with a track record of comparable projects
- Capability statement template - the one-page firm summary the matrix supports in a bid
- What a capability statement is and how to write one - the full guide to the companion firm document
- Best skills management software 2026 - when a spreadsheet skills matrix stops scaling
- Project reference sheet - the per-project evidence behind each expert rating
Frequently asked questions
What is a skills matrix?
A skills matrix is a grid that maps competencies against people: skills down one axis, team members across the other, and a proficiency rating in each cell. Firms use it to see where capability sits, where the gaps are, and - in bids and tenders - to prove that the team they are proposing covers every skill the contract requires.
What is the difference between a skills matrix and a performance review?
A performance-review or HR competency matrix rates individuals privately to guide pay, training, and appraisals. A bid skills matrix is external evidence: it shows a client or evaluator that your firm holds the disciplines, certifications, and experience a contract demands. This template is built for the second job - capability evidence, not internal appraisal - so ratings are backed by CVs and project references you can share.
Is this skills matrix template really free?
Yes. Every file is free: the print-ready PDF and the editable Excel version cost nothing. Creating a free SUNAGO account is the only step - it unlocks the download and lets you generate the matrix from your own team data; it opens in Google Sheets if you upload it to Google Drive. The file carries a small one-line credit link you may keep or remove.
How do you use a skills matrix in a bid or tender?
Match the matrix to the requirement. Read the selection criteria, list the competencies the buyer names, rate your proposed team against each one, and attach a CV or project reference to every expert-level score. Presented alongside CVs, the matrix answers the buyer's real question - does this team, not just this firm, hold the capability to deliver - in a single scannable page.
Is there free skills matrix software?
Yes. SUNAGO's free CV and skills tool stores each person's competencies once and regenerates a bid-ready skills matrix from the live data, so you are not rebuilding the grid every deadline.