Competitive analysis template for product teams
A free competitive analysis template for Google Sheets or Excel: a competitor overview, feature comparison, per-competitor SWOT, five forces, and how to use it.
A PM spends two weeks on a 40-slide competitive analysis. It covers every competitor's feature list, logo, and funding round. In the review, the CEO asks, "So what should we do differently?" There's no slide for that.
A competitive analysis is only worth the decisions it informs. This template is built around that question, using two standard frameworks, SWOT analysis and Porter's five forces, checked on 16 November 2026.
Start with the question
Write it at the top before any research: "Should we add a free tier?" or "How do we position against the new entrant?" Every section should help answer it. If a fact doesn't, leave it out.
1. Competitor overview
| Us | Competitor A | Competitor B | Competitor C | Do nothing | |
|---|---|---|---|---|---|
| Who they serve | |||||
| Positioning (one line) | |||||
| Pricing model | Free | ||||
| Strength customers mention | |||||
| Weakness customers mention | |||||
| Recent moves |
Include "do nothing," or the spreadsheet customers use today. It's often the real competitor.
2. Feature and quality comparison
List what customers care about, not every feature:
| What customers care about | Us | A | B | C |
|---|---|---|---|---|
| [Need 1] | ● | ◐ | ○ | ● |
| [Need 2] | ◐ | ● | ● | ○ |
| [Need 3] | ● | ○ | ◐ | ○ |
● strong, ◐ partial, ○ missing. Source each rating: a demo, docs, a customer interview. Unsourced ratings turn into opinions.
3. SWOT per main competitor
| Helpful | Harmful | |
|---|---|---|
| Internal | Strengths | Weaknesses |
| External | Opportunities | Threats |
SWOT lists strengths, weaknesses, opportunities, and threats, and is often used early in decision-making to find favorable and unfavorable factors. Wikipedia notes it's been criticized as static and prone to personal bias, so ground each entry in evidence and date it.
4. Market forces (optional)
For market-level decisions, Michael Porter's five forces, first published in Harvard Business Review in 1979, assess how competitive an industry is:
| Force | Question | Assessment |
|---|---|---|
| Threat of new entrants | How easy is it to enter? | Low / Medium / High |
| Threat of substitutes | What else solves the problem? | |
| Rivalry | How intense is competition now? | |
| Supplier power | Can suppliers squeeze us? | |
| Buyer power | Can customers push prices down? |
5. Implications
The section that matters:
| Area | Decision | Why |
|---|---|---|
| Match | [Where we must reach parity] | [Customers leave without it] |
| Differentiate | [Where we'll be clearly better] | [Our strength, their weakness] |
| Ignore | [What we won't copy] | [Not our customer, or not worth it] |
Where to get evidence
- Your own lost-deal and churn notes
- Customer interviews: "what else did you try?"
- Competitors' public docs, changelogs, and pricing pages
- Trial accounts and demos
- Review sites, read for patterns rather than single comments
Keep it alive
Date the document and each rating. Assign an owner. Update it when a competitor launches, changes pricing, or gets acquired. An undated competitive analysis gets quoted long after it stopped being true.
Where Lockstep fits
The implications table is a set of decisions: match this, differentiate there, ignore that. Lockstep captures decisions like these from documents, Slack, and pull requests, routes each to its owner for approval, and briefs the engineers and Claude Code sessions building against them, so "we're not copying their free tier" reaches the people writing the pricing page.
See Lockstep for product teams.
Sources checked 16 November 2026
- https://en.wikipedia.org/wiki/SWOT_analysis
- https://en.wikipedia.org/wiki/Porter%27s_five_forces_analysis
Related reading
For pitching what to do about it, see the product one-pager template. For comparing your options, see the decision matrix template.
Frequently asked questions
- What should a competitive analysis include?
- An overview of each competitor (who they serve, positioning, pricing model), a comparison of the features and qualities customers care about, strengths and weaknesses of each, and the implications for your product: where to match, where to differentiate, and where to ignore.
- How many competitors should I analyze?
- Three to five direct alternatives is usually enough, plus the option customers use most often: doing nothing or using a spreadsheet. More than that and the analysis gets wide and shallow.
- What is SWOT analysis?
- A strategic planning technique that lists Strengths, Weaknesses, Opportunities, and Threats, often in a 2 by 2 grid. It's commonly used early in decision-making to identify internal and external factors. Wikipedia notes criticism of it for being static and prone to personal bias.
- What are Porter's five forces?
- A framework from Michael Porter, first published in Harvard Business Review in 1979, for analyzing an industry's competitive intensity: the threat of new entrants, the threat of substitutes, rivalry among existing competitors, and the bargaining power of suppliers and of buyers.
- How often should I update a competitive analysis?
- When something material changes, such as a competitor launch, pricing change, or acquisition, and on a regular cadence such as quarterly. Date every entry so readers know how current it is.
Keep reading