Skip to main content

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

  1. Pick 3 to 5 competitors: your closest direct rivals, one indirect alternative, and the status quo.
  2. Fill parts 1 to 5 from public sources: homepage, pricing page, features page, changelog and reviews.
  3. Write every gap you notice into part 6 and score it.
  4. 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

YouCompetitor ACompetitor BCompetitor 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.

FeatureYouCompetitor ACompetitor BCompetitor C
Feature 1Yes / No / Partial
Feature 2
Feature 3
Integrations
Mobile app
Support (channels, hours)

Part 3: Pricing comparison

YouCompetitor ACompetitor BCompetitor 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

YouCompetitor ACompetitor BCompetitor 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)

GapTypeEvidenceImpact (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:

GapTypeEvidenceImpactEffort
No offline modeFeatureOffline sync is the top complaint in competitor reviews54
No plan between free and $15 per monthPricingEvery competitor jumps from free to a team plan41
Nobody targets studentsAudienceNo competitor mentions students; Reddit threads ask for it42
Headlines all say "get organized"MessagingSame promise on all three homepages31

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.

Keep reading