Free Gap Analysis Template for Excel, Google Sheets, Word and PowerPoint, with Worked Examples (2026)

The council work session is in three weeks. The plan promised priority-1 calls answered in 7.2 minutes. The dashboard says 7.5. A gap analysis explains the difference, and decides who does what about it before the next reading.

Here is the whole template, on this page: one grid with nine columns, from the current state to the due date. Three worked examples fill it in for a city of 38,000 residents, a community hospital and a regional public university. Copy any table into Excel, Google Sheets, Word or PowerPoint, or download the files.

Every gap gets a type.
Every action gets one named owner.
Every owner gets a due date.

Copy the template ↓ · Download the free templates

Built from 20,000+ strategic plans analyzed (2017–2024).

On this page: What to include · The template · How to use it · City example · Hospital example · University example · Four gap types · FAQ · Download

How we built this template

On October 23, 2026, we read the nine other pages on Google's first page for "gap analysis template". Four ask for an account or a form before you get the file. None fills the template in for a city, a hospital or a university. None shows the spreadsheet formulas for the gap, and none says when to re-baseline a target.

This page puts the whole template in the page, fills it for three sectors, and gives every row one named owner. We analyzed over 20,000 strategic plans run on ClearPoint between 2017 and 2024. The shape of the template, from the gap types to the owner column, comes from that work.

What is a gap analysis template?

A gap analysis template is a table that compares where a goal stands today with where your plan said it would be. Each row holds one measure: its current state, its target state and the gap between them. Five more columns turn the reading into work: gap type, root cause, action, owner and due date.

Think of it as a reading, not a report. The target state is what other templates call the desired or future state. The number tells you how far you are. The type tells you why. The owner and the date decide whether anything changes. It often follows a SWOT analysis in the planning cycle: SWOT surveys the landscape, and a gap analysis measures the distance to one target inside it.

What should a gap analysis template include?

A gap analysis template for strategic planning needs nine columns. Four describe the gap: the goal and its measure, the current state, the target state and the gap itself. Five decide what happens next: the gap type, the root cause, one action, one named owner and a due date. A short header records the date and the sources.

• Goal and measure. The plan goal, and the one measure that shows progress on it.
• Current state. The value today, with the date of the reading and its source.
• Target state. The value you planned, its deadline, and the assumption behind it.
• Gap. The difference, its direction, and its trend over the last three readings.
• Gap type. Performance, tracking, definition or strategy. Each needs a different fix.
• Root cause. Where five whys, run once, lead. Stop at something you can change.
• Action. One action that removes the root cause. Not a list.
• Owner. One person's name, with a title. A department is a team, and teams don't send updates.
• Due date. When the action is done, and the date of the next reading.

The free gap analysis template

Two tables make the template. The header records what was measured, when, from which source, and the rule that decides when a difference counts as a gap. The grid holds one row per measure, with the first row showing what to write. Copy them with the buttons under each table, then paste into Excel, Google Sheets, Word or PowerPoint.

Gap analysis header

Gap analysis grid: one row per measure

How to use this gap analysis template in 7 steps

Fill the header first, then one grid row per measure. Pull the current reading with its date and source, write the target with its deadline and assumption, and measure the gap. Name the gap type, run five whys once, then write one action with one named owner and a due date. Review the grid on a fixed day.

1. Pick one goal and one measure per row. Use a measure someone updates at least monthly, owned by a person who controls its inputs. If nobody can say what would move it by 10%, it's a placeholder, not a measure.
2. Write the current state with its date and source. For example: 7.5 minutes, September 2026, CAD export pulled October 3. A number without a date starts arguments, not decisions.
3. Write the target state with its deadline and assumption. “7.2 minutes by June 30, 2027, assuming all patrol positions are filled” tells you what to check first when the gap opens.
4. Measure the gap and name its type. Write the difference and its direction over the last three readings. Then pick one of the four gap types: performance, tracking, definition or strategy.
5. Run five whys once. Ask why the gap exists, then why again, until you reach something your organization can change this year. That answer goes in the root cause column.
6. Write one action, one owner and one due date. Name a person, with a title, who controls the inputs. In ClearPoint plan data, initiatives with a named owner are completed 2.5× as often (21.5% vs 8.7%).
7. Review the grid on a fixed day. Re-read every row on the monthly update day. Close a row when the reading meets its target line. Re-baseline a target when its assumption breaks, and write down why.

Excel and Google Sheets formulas for the gap

Keep the readings as numbers in three helper columns: current value (J), target value (K) and whether higher is better (L, Y or N). The sheet then computes the gap and flags a missing reading. The same formulas work in Excel and Google Sheets, and the downloadable Excel file has them built in.

Example 1: gap analysis for a city of 38,000 residents

This is the template filled in for the council-manager city of our 5-year strategic plan template, one quarter into its plan. Four measures show four different gaps: performance, tracking, definition and strategy. The analysis is dated October 10, 2026, covers the first quarter of FY2027, and goes to the November council work session.

Illustrative example. Owner names are ClearPoint demo personas.

Why it's built this way

• Every reading carries a date and a source. The council debates the fix, not the number.
• The tracking row has no value, on purpose. A missing reading is a gap of its own, and it gets an owner before it gets an action.
• The strategy row is the uncomfortable one. Every resurfacing contract finished on time, and the index didn't move. That's the signal to change the mix of work, not to add more of it.

Example 2: gap analysis for a community hospital

This is the template filled in for the 180-bed nonprofit community hospital of our 5-year strategic plan template. The April 2027 analysis covers infection control, the operating margin, new-nurse turnover and readmissions. Readings come from NHSN, the monthly finance close, the HR report and the quality dashboard, and the board quality committee reviews them.

Illustrative example. Owner names are ClearPoint demo personas.

Why it's built this way

• The infection row names the units without audits. A root cause you can point to on a floor plan gets fixed faster.
• The margin row is a calendar problem. Nobody failed: the update day came before the close. The fix is a date.
• The readmission row is the strategy gap. The calls happen, and patients still come back. The plan moves the effort from calling patients to seeing them.

Example 3: gap analysis for a regional public university

This is the template filled in for the regional public university of about 12,000 students in our 5-year strategic plan template. The October 2026 analysis covers first-year retention, the operating margin, research funding and the six-year graduation rate. Readings come from the fall census, the finance office, sponsored programs and IPEDS, and the president's cabinet reviews them.

Illustrative example. Owner names are ClearPoint demo personas.

Why it's built this way

• IPEDS sets the clock. Retention and graduation rates move once a year, so the monthly readings watch the supporting measures, and the full analysis runs each term.
• The research row re-baselines in the open. The board sees which grant ended and what the new target assumes.
• The graduation row is the strategy gap. The first-year work succeeded, and the six-year rate still sits at 52%. The effort moves to the third year.

The four types of gap, and the first fix for each

Every gap fits one of four types. A performance gap means the work isn't moving the number. A tracking gap means nobody is reading it. A definition gap means the target's assumption broke. A strategy gap means the projects deliver and the goal still misses. They look the same on a chart, and each one needs a different first fix.

Five whys is the triage. Run it once per row. The answer at the fifth why usually tells you which of the four types you're looking at. When the same strategy gap comes back cycle after cycle, ask whether the organization has the capability to close it at all: a quick VRIO framework pass answers that.

Why most gap analyses close nothing

Most gap analyses get the math right and the ownership wrong. The grid ends with an action and a department name, so nobody in particular moves it. Across 52,247 objectives in 318 organizations, 77% have no named owner. Write one person's name, with a title, in every owner cell, and check that this person controls the inputs.

Ownership tracks with completion. Across 90,305 initiatives in 315 organizations, those with a named owner are completed 2.5× as often as those without (21.5% vs 8.7%). That's a correlation, not a promise. An owner doesn't make the work happen. An owner makes it someone's job to say when it isn't happening.

That's why the template puts the owner and the due date in the same row as the gap. A gap analysis that ends in a meeting note ends there.

Four gap analysis mistakes we see often

Four mistakes undo most gap analyses. Teams measure the projects instead of the goal. They treat a delay as a gap. They never re-baseline a target whose assumption broke. And they hand the action to someone who can't move the measure. Each one has a simple check, and the template builds every check into a column.

Mistake 1: measuring the projects instead of the goal

Ask "are our projects on track?" and the answer is usually yes. Then the goal drifts anyway. Run the analysis on the goal's measure, not on the work that serves it. The strategy rows in all three examples show why. Before you blame the work, check the goal itself against good strategic objective examples.

Mistake 2: treating a delay as a gap

A project running 60 days late is a delay. A measure moving away from its target is a gap. Manage the delay in the project plan. Diagnose the gap in this grid. Treat one as the other and you lose a quarter.

Mistake 3: never re-baselining

Targets set against old assumptions sit in plans for years. If a gap stays wide for four quarters in a row, check the target's assumption before you add work. Then write down what changed, as the city does for its storefront target. We see this often in healthcare gap analyses, where staffing and pay assumptions move fast.

Mistake 4: naming an owner who can't move the measure

This one sinks the other three. A closing action owned by a department, or by someone who doesn't control the inputs, is an action nobody runs. Check each owner cell against the inputs before the review, not after it.

A real gap analysis: the City of Durham, NC

Durham, a city of 283,000 residents, started its first strategic plan on ClearPoint in 2011. A year later, most departments had gone back to Excel. The gap wasn't in the strategy, and it wasn't in the software. Nobody clearly owned the performance program, and staff weren't held to updating their measures. The fix was ownership.

Durham relaunched the program around its owners. Department directors took responsibility for their measures. Budget requests now carry the performance measures they affect. A designated performance manager trains staff, and use of the system grew from 2 to 100+ users. In this template's terms, Durham's early problem was a tracking gap on most rows, and the fix sat in the owner column.

Jay Reinstein, Strategic Plan Project Manager, summed it up: "With data now driving decision making, it's all about results."

Source: ClearPoint case study, City of Durham

When is a spreadsheet enough?

A spreadsheet is enough for one gap analysis, run once, by one person. It stops being enough when the grid needs monthly readings from a dozen owners. Or when the council or board wants the history. Or when a missed update has to show up on its own, without anyone chasing it. That's the point where software earns its place.

ClearPoint keeps the grid alive between reviews. Each row links to the measure and the goal it serves, so the gap updates when the measure does. Every measure shows its last-update date. Owners get reminders on the cadence you set, and stale measures escalate. Initiatives sit beside the measures they're meant to move, so a strategy gap shows up when the projects are green and the measure isn't.

Prefer to build it in your browser first? The free gap analysis tool computes each gap and a priority in your browser, with no account. You give a work email only to export the CSV and the one-page summary.

Download the free gap analysis templates

Every file below is free, with no form: the blank template, the four gap types, the how-to steps and one worked example, in Excel, Word and PowerPoint. Excel files open in Google Sheets and carry the helper columns that compute the gap. Pick the example closest to your organization, or copy any table on this page with the buttons under it.

Built from 20,000+ strategic plans analyzed (2017–2024). Founded in 2008 by Ted Jackson and Dylan Miyake, who worked with Robert Kaplan and David Norton — the creators of the Balanced Scorecard — and have worked in strategy execution since 1999.

A gap is not a failure. It's the plan telling you, in numbers, where it needs a name.

Related templates and guides

• 5-year strategic plan template: the same city, hospital and university, with their full plans.
• Gap analysis tool: build the grid in your browser.
• Gap analysis in healthcare: how hospitals and health systems run it.
• SWOT analysis examples: the landscape scan that often comes first.
• KPI examples: borrow a measure definition instead of inventing one.
• RAG status tool: set status thresholds for the review.
• Sector pages: Local government · Healthcare · Higher education

Sources

• Source: ClearPoint anonymized platform data, plans run on the platform 2017–2024. Objectives: 52,247 in 318 organizations. Initiatives: 90,305 in 315 organizations. Plan structure: 4,184 plans with at least one objective and one initiative. We see the structure of plans, never their content. How we read the data ›
• CDC, National Healthcare Safety Network (NHSN): standardized infection ratio for central line infections.
• NCES, Integrated Postsecondary Education Data System (IPEDS): retention and graduation rates.
• NSF NCSES, Higher Education Research and Development (HERD) Survey.
• Customer story: City of Durham, NC.