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

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 days—2027-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

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

Case studies

How teams put this to work

Published ClearPoint customer stories, matched to this tool.

Winnebago County Public Health

Public health · six divisions, 50 staff

Problem

Division plans written in late 2019 never launched after COVID-19. Each division kept its own Excel files, with no shared place to review data across the department.

Implementation

The department adopted ClearPoint and named a Performance Management Champion in every division, who presents dashboards at leadership meetings and shares HTML exports with staff.

Impact

Six divisions in one shared view

Trends that were split across divisions are now visible together, and the department plans to bring its Community Health Improvement Plan into the platform.

Read the Winnebago County story →

City of Dublin, Ohio

Local government · 50,000 residents

Problem

Each department built its own PowerPoint, so reporting was inconsistent and the same data was read in different ways. The City Manager kept asking, "How are we winning?"

Implementation

From 2020, the performance analytics team built a framework around sustainability, connectedness and resilience, coached departments to write concise measures and linked each measure to a strategic goal.

Impact

One source of truth for leadership

Automated data collection replaced manual gathering from many sources, and a public community dashboard is the next step.

Read the Dublin story →

City of Olathe

Local government · Parks & Recreation

Problem

The department measured its community parks and had no data on neighborhood parks. Staff could not take giant Excel files into meetings with the director.

Implementation

Staff designed a park usage survey, revised it after early errors and loaded the results into ClearPoint as usage, amenities and weather measures that chart automatically through the Data Loader.

Impact

Two new indices from one survey

The data produced Livable Neighborhood Scores and a Healthy Communities Index, answering questions beyond the survey's original scope.

Read the Olathe story →

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.

Customer stories on this page

Winnebago County Public Health · City of Dublin, Ohio · City of Olathe

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

Method

How the numbers are built

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.