PRODUCT RESEARCH / TEMPLATE
Competitor Analysis Template.
An Excel competitor analysis template and PDF guide for product teams, with 7 core sheets, worked fictional examples and action planning.
This is a paid template. This page only describes it; the files are delivered by Gumroad after purchase. See Gumroad for the current price.
What's inside
Competitor_Analysis_Template.xlsx: a How to Use sheet, 7 blank templates and 7 fully worked examples. User_Guide.pdf (6 pages): a 5-step method, how to use each sheet, copy-and-paste AI prompts for research, common pitfalls and a one-page structure for presenting to leadership.
Seven sheets
Competitors (names sync to every sheet), Feature Matrix (✓ / ◐ / ✗ / ? dropdowns and coverage scores), UX Scorecard (your own criteria and weights, automatic rank and chart), Pricing (normalized to USD per month), SWOT + TOWS, User Reviews (% negative and top pain points) and Insights & Actions (progress dashboard and overdue alerts).
Who it's for
Product managers and product ops preparing a competitive review; founders mapping the landscape before a launch or fundraise; growth, strategy and marketing teams benchmarking pricing and positioning; consultants who need a repeatable framework.
Compatibility and license
No macros or add-ons. Built for Excel 2010+ and also works in Google Sheets, LibreOffice and Apple Numbers. The worked example uses a fictional note-taking app market; all companies and figures are fictional. Licensed for personal use and use within your own team; no resale or redistribution.
Starting a review
Choose a decision first, such as whether to improve the first note-taking experience. Build the competitor list and record sources and access dates. Compare the same tasks, label unverified information, and turn findings into action items rather than stopping at a ranking.
FAQ: Does it collect competitor data automatically?
No. The workbook organizes the research and judgments you supply. Sources, accuracy and conclusions still need human review. The AI prompts in the guide are optional aids, not an automated collection service.
FAQ: Can I learn the method before buying?
Yes. Read the competitor analysis guide on this site to learn how to select competitors, record evidence and propose actions, then decide whether you need the workbook. Template files are paid deliverables; this site shows descriptions and fictional examples.
A closer look
