Book a 30-min demo

Free tool ·

All

Gap analysis template, already filled in — and it does the math

Objective, current, target, owner, due date. Gap, gap type and priority calculate as you type. Start from ten example gaps or paste yours. Free to use; email only to export.

Free to use. No account. Email only to export.

Preview of the tool and its export

83%

of metrics have no owner assigned at all · 272,360 of 327,582 · Jan 2026

61.9%

of named owners never wrote a status update · n = 55,222

9.2 months

median strategic project — the horizon a gap plan should fit · n = 114,927

52.0%

of 10,046,276 status records carry no result · Jan 2026

ClearPoint platform data · January 2026 snapshot

What is a gap analysis template?

A gap analysis template is a table that compares the current value and the target for each objective and sizes the difference. A usable one also types the gap — capability, resource, performance or timing — and puts an owner and a due date on it. This tool does the sizing and typing for you; you supply the names. On the ClearPoint platform, 83% of metrics have no owner (January 2026).

Show the full register as text

Example gap analysis — City of Metropolis (illustrative). Ten objectives with a current value, a target and a due date; four still without an owner. In the tool, gap, gap type and priority are calculated from these columns.

ObjectiveCurrentTargetUnitOwnerDue
Reduce priority-1 emergency response time8.47.0min (90th pct)Lance Cummins2026-12-31
Increase affordable units permitted210400units / yrClarice Strong2027-06-30
Cut median permit turnaround2310business days2027-06-30
Raise resident satisfaction score3.64.2/ 5Maggie Sawyer2027-03-31
Reduce water main breaks1912per 100 milesRon Troupe2027-09-30
Public dashboard measures updated on time6195%2026-12-31
Reduce voluntary staff turnover139%2027-06-30
Grow assessed value1.43.0% / yrClarice Strong2027-09-30
Close pending audit findings110open findingsJimmy Olspon2026-10-31
Increase recycling diversion rate2435%2028-06-30

The four gap types, and how the tool assigns them

  • Timing — the due date has passed and the gap is still open.
  • Capability — the gap is at least half the distance to target: the organization cannot do this yet, and needs a project.
  • Resource — the gap is 20–50% of target: the capability exists, the capacity does not.
  • Performance — the gap is under 20%: execution, not capacity.

Priority: Do first when the gap is 30%+ and due within a year (or already past due); Do next when 30%+ and further out; Monitor otherwise.

Blank Gap Analysis Tool template (copy-ready)

Reuse freely with attribution. Canonical source: https://www.clearpointstrategy.com/free-tools/gap-analysis

| Objective / capability | Current | Target | Unit | Gap (target − current) (calculated) | Gap type (calculated) | Owner | Due | Priority (calculated) |
|---|---|---|---|---|---|---|---|---|
|  |  |  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |  |
Source: ClearPoint Strategy — https://www.clearpointstrategy.com/free-tools/gap-analysis
{{wf {"path":"custom-section-html","type":"PlainText"\} }}

Why gap analyses end up in a drawer

What is a gap analysis?

A gap analysis template compares where you are and where you need to be on each objective, with the difference sized, typed and given an owner and a date. The template is the easy part. The hard part is the column most templates leave out: whose name is on the gap.

Why do gap analyses fail to close gaps?

Because the gap gets sized and nobody gets assigned. On the ClearPoint platform, 83% of metrics have no owner at all, and of the 55,222 that do, 61.9% never received a written update from that owner (January 2026). A gap with no owner is a finding. A gap with an owner and a due date is a plan.

A gap with no owner is a finding. A gap with an owner and a due date is a plan.

Gap analysis template vs. gap analysis tool — which do you need?

A template (Excel, Miro, Confluence) gives you the columns; this tool fills them for you — gap, gap type and priority recalculate as you type — and will not export until you have looked at who owns what.

Gap analysis templateThis tool
Gap = target − currentYou type itCalculated
Gap type (capability / resource / performance / timing)You decideAssigned from size and due date
PriorityYou decideDo first / Do next / Monitor, recalculated
Owner on each gapOptionalCounted; flagged
ExportDownload the fileCSV + one-page summary
Email requiredTo downloadOnly to export

How long should it take to close a gap?

Plan within the horizon you can measure: the median strategic project on the platform runs 9.2 months (n = 114,927). A gap due in three years with no milestone before then is a wish. The tool marks gaps due within a year as Do first when they are 30% or more of target.

Trusted by the teams whose plans are public

“We had a twelve-page gap analysis nobody had opened in a year. Ten lines with a name and a date on each did more in a quarter.”

[Cleared client quote — same vertical only] — name, title, organization

City of Fort Lauderdale · Durham County · City of Coral Springs · City of Goldsboro · JEA

Questions people ask before they start

Is the gap analysis tool free?

Yes. Add your objectives, current values and targets in the browser without an account. Email is asked only when you export.

What is a gap analysis?

A gap analysis compares where you are (current) with where you need to be (target) on each objective, sizes the difference, and decides what kind of gap it is — capability, resource, performance or timing — so the right response follows.

What are the four types of gap?

Capability (you cannot do it yet), resource (you can, but not at this scale), performance (you can, but execution lags) and timing (the deadline has passed). The tool assigns one from the size of the gap and the due date.

How is priority calculated?

Do first when the gap is 30% or more of target and due within a year or already past due; Do next when 30% or more but further out; Monitor otherwise. Change a target or a date and the priority changes.

What do I get when I export?

A CSV of every gap with current, target, gap, type, owner, due date and priority, and a printable one-page summary with your counts.

Where do the numbers come from?

ClearPoint platform data, January 2026 snapshot: 327,582 metrics (ownership), 114,927 projects (duration), 55,222 owned metrics (owner activity).

All answers ship as text in the DOM — the accordion only hides them visually.

Method

How gap type and priority are assigned

Relative gap = |target − current| ÷ |target|. Timing if the due date has passed; Capability at ≥ 50%; Resource at 20–50%; Performance under 20%. Priority: Do first at ≥ 30% and due within 365 days (or past due); Do next at ≥ 30% otherwise; Monitor below 30%. These thresholds are practice judgments from ClearPoint’s strategy team, not measured optima — change a target and watch them move.

Platform figures

Ownership: 272,360 of 327,582 metrics with no owner, January 2026. Owner activity: 55,222 owned metrics, written updates only. Duration: n = 114,927 projects with start and end dates. Status records: 10,046,276, keyword flag — a floor.

You’ve sized the gaps. Now see them close.

Thirty minutes, your objectives, a plan that gets updated.

Book a 30-min demo