How to Create a Competitive Analysis in Google Sheets (Step-by-Step)
Google Sheets is the fastest way to create a shareable competitive analysis. No tool to buy, universal access, and formula-powered scoring.
Use multiple tabs for different dimensions: features, pricing, moves, and win/loss.
Step-by-step guide
Step 1: Create a feature comparison tab
Columns: Feature Category, Feature, Your Product, Competitor columns. Conditional formatting: green Y, yellow Partial, red N.
Step 2: Build a pricing comparison tab
Rows: Free tier, Pro price, Enterprise price, per-seat or usage, total cost at different team sizes (5, 25, 100).
Step 3: Add a competitive moves log
Columns: Date, Competitor, Move Type, Description, Impact, Our Response. Sort by date descending.
Step 4: Create a weighted scoring matrix
Weight features by ICP importance. Multiply scores by weights and sum. Rank competitors by composite score.
Step 5: Build a dashboard tab
Charts: overall score, feature parity by category, pricing at 25-seat level, win rate by competitor.
Common mistakes
Too many competitors
Track 3-5 deeply, not 15 superficially.
No weighting
A flat feature count is misleading. Use weighted scoring.
Not sharing with sales
Sales fights competitive battles daily. Share the sheet and create a battlecard tab.
Tips
- Use IMPORTHTML to pull competitor pricing automatically
- Set monthly calendar reminders for updates
- Create a protected tab for sales battlecards
How Vantage helps
Vantage lets you add competitive data as context when generating PRDs. Upload analysis or link competitor pages, and the AI grounds specifications in competitive awareness.