Competitor Analysis Template (Free, Copy-Paste Ready)
A free competitor analysis template to copy into Google Sheets, Notion or Excel: the rows to fill, how to score gaps, and a worked example.
· 4 min read
Key takeaways
- A good template compares every competitor on the same rows: audience, promise, features, pricing, channels, strengths and weaknesses.
- The part most templates miss is a gap list scored by impact and effort. That is what turns research into decisions.
- Copy the tables below into Google Sheets, Notion or Excel, fill them for 3 to 5 competitors, and update them every quarter.
Most competitor analysis templates are either too thin (a logo grid) or too heavy (forty columns nobody fills). This one has six short parts. Each table is in plain text, so you can copy it straight into Google Sheets, Notion, Excel or a doc.
How to use this template
- Pick 3 to 5 competitors: your closest direct rivals, one indirect alternative, and the status quo.
- Fill parts 1 to 5 from public sources: homepage, pricing page, features page, changelog and reviews.
- Write every gap you notice into part 6 and score it.
- Put a date at the top. Re-check it every quarter, and whenever a competitor changes its pricing.
Keep cells short. A few words per cell is enough to see patterns.
Part 1: Competitor overview
| You | Competitor A | Competitor B | Competitor C | |
|---|---|---|---|---|
| Website or app link | ||||
| Target customer | ||||
| Headline promise | ||||
| Founded / team size (if public) | ||||
| Main acquisition channel | ||||
| Markets and languages |
Part 2: Feature comparison
List the 8 to 12 features buyers care about most (check reviews and sales calls), not every feature that exists.
| Feature | You | Competitor A | Competitor B | Competitor C |
|---|---|---|---|---|
| Feature 1 | Yes / No / Partial | |||
| Feature 2 | ||||
| Feature 3 | ||||
| Integrations | ||||
| Mobile app | ||||
| Support (channels, hours) |
Part 3: Pricing comparison
| You | Competitor A | Competitor B | Competitor C | |
|---|---|---|---|---|
| Pricing model (per seat, usage, flat, one-time) | ||||
| Free plan or trial | ||||
| Entry price | ||||
| Most popular plan and price | ||||
| Key limit on the entry plan | ||||
| Annual discount |
The pricing analysis guide shows how to compare plans fairly when the models differ.
Part 4: Positioning and messaging
| You | Competitor A | Competitor B | Competitor C | |
|---|---|---|---|---|
| Who they say it's for | ||||
| Main benefit claimed | ||||
| Proof used (logos, numbers, reviews) | ||||
| Tone (playful, technical, premium) |
When every competitor makes the same claim, that claim is table stakes. Look for the promise nobody makes.
Part 5: Strengths and weaknesses
For each competitor, write the top three strengths and top three weaknesses, using evidence: a review quote, a missing feature, a confusing pricing page. "Bad UX" is an opinion; "12 recent reviews mention losing data during sync" is evidence.
Part 6: Gap list (the part that matters)
| Gap | Type | Evidence | Impact (1-5) | Effort (1-5) | Priority |
|---|---|---|---|---|---|
| Feature / Pricing / Audience / Messaging / Content | |||||
Priority is simple: sort by impact (high first), then by effort (low first). Work on the top three. Everything else waits until the next review.
A worked example
Here is the gap list for a fictional to-do app, "TaskNest", compared with three made-up competitors:
| Gap | Type | Evidence | Impact | Effort |
|---|---|---|---|---|
| No offline mode | Feature | Offline sync is the top complaint in competitor reviews | 5 | 4 |
| No plan between free and $15 per month | Pricing | Every competitor jumps from free to a team plan | 4 | 1 |
| Nobody targets students | Audience | No competitor mentions students; Reddit threads ask for it | 4 | 2 |
| Headlines all say "get organized" | Messaging | Same promise on all three homepages | 3 | 1 |
TaskNest's plan: add a cheaper personal plan (high impact, low effort), launch a student landing page, and start the offline mode project. The messaging change rides along for free.
Fill it automatically
GapsFinder produces part 6 for you: paste your link and your competitors' links (websites or App Store and Google Play listings), and in about 60 seconds you get every gap ranked by impact, with an effort estimate, a recommended action and the evidence for each. Paid reports export to CSV or JSON, which pastes straight into this template. The free trial covers one competitor; $9 buys 10 full analyses with up to five competitors each. See a finished example report.
Frequently asked questions
What should a competitor analysis include?
At minimum: who each competitor targets, what they promise, their key features, their pricing, their strengths and weaknesses, and a ranked list of gaps for your own product. Everything else is optional.
How many competitors should a template cover?
Three to five: your closest direct competitors, one indirect alternative, and the status quo (doing nothing or doing it by hand). With more, the comparison gets shallow and the file rarely gets finished.
What is the difference between a competitor analysis and a SWOT analysis?
A SWOT looks at one company: its strengths, weaknesses, opportunities and threats. A competitor analysis compares several companies on the same criteria. You can use the comparison to fill the opportunities and threats in your own SWOT.

Founder of GapsFinder · AI integration engineer and competitor analyst
Shivam builds GapsFinder and has spent years wiring AI into products and studying how companies win against their competitors. He writes about competitor research, AI search and practical product strategy.