Competitive Pricing Analysis in Google Sheets

Pricing in a vacuum leads to two common mistakes: charging too much and losing sales you don’t know you’re losing, or charging too little and leaving money on the table. A competitive pricing analysis grounds your prices in market reality without requiring expensive software or consultants.

Here’s how to build a practical competitor price tracker in Google Sheets and actually use it to make pricing decisions.

What You’re Trying to Learn

Before building anything, get clear on what questions you’re answering:

• Where does my price sit relative to the market? (High, mid, low?)
• Am I priced consistently with my positioning? (Premium product shouldn’t be the cheapest option)
• Which of my products are most price-sensitive vs. differentiated?
• When competitors change prices, what should I do?

The spreadsheet captures raw data. Your judgment turns it into decisions.

Building the Competitor Price Tracker

Set up a tab for each major product category or individual product line. For each, track:

Columns:

Column	What to Track
Competitor Name	Business name
Product / SKU	Their equivalent offering
Our Comparable Product	What we’d compete with
Their Price	Current listed price
Date Checked	When you checked
Our Current Price	Your price for this product
Price Difference ($)	=Our Price - Their Price
Price Difference (%)	=(Our Price - Their Price)/Their Price
Notes	Quality differences, terms, bundling

Summary row:

• Lowest competitor price: =MIN(TheirPrice)
• Highest: =MAX(TheirPrice)
• Market median: =MEDIAN(TheirPrice)
• Your position in range: =(OurPrice - MIN) / (MAX - MIN) — 0% means you’re the cheapest, 100% means you’re the most expensive, 50% is exactly middle

How Often to Check Competitor Prices

Frequency depends on how dynamic your market is:

• High-volume commodity products (office supplies, cleaning products, generic parts): monthly or more
• Service pricing (consulting, lawn care, cleaning services): quarterly
• Specialty or custom products: semi-annually, or after major market events
• E-commerce / retail: weekly for core SKUs, monthly for tail SKUs

Add a Last Updated timestamp to each row and use conditional formatting to flag rows older than your review frequency: =TODAY() - DateChecked > 30 → yellow fill

This prevents stale data from driving decisions.

Where to Find Competitor Pricing

Websites and menus: The obvious first stop. Screenshot prices so you have a historical record.

Request quotes: For service businesses, getting a competitor quote is completely legal and often the only way to get real pricing. Use a neutral email address or have a friend request.

Industry associations and trade publications: Some industries publish price surveys. If yours does, use it.

Customers: Customers often volunteer competitor pricing information, especially when negotiating. Log it every time. “XYZ Company quoted me $850 for the same thing” is data. Capture it.

Job boards and forums: Competitors sometimes post rates in hiring materials. Industry forums often discuss pricing openly.

Create a Sources column in your tracker. Knowing whether a price came from a website quote or a customer anecdote matters when you’re deciding how much to trust it.

When to Match vs. Differentiate

This is the judgment call no spreadsheet can make for you, but these guidelines help:

Match competitor pricing when:

• Your product is genuinely equivalent (same quality, same terms, same support)
• The customer has no strong reason to prefer you
• You’re trying to win on price in a price-sensitive market
• You have the cost structure to sustain that price profitably

Differentiate (price higher) when:

• Your product has meaningful advantages: better quality, faster delivery, better support, more experience
• Your customer segment values those advantages
• You have a relationship or reputation that creates preference
• Your cost structure doesn’t allow matching without hurting margins

Differentiate (price lower) when:

• You’re entering a market and need to win your first customers
• You have a cost advantage competitors can’t replicate
• You’re trying to capture volume to build economies of scale
• It’s a strategic decision to undercut, not a reaction to desperation

The worst pricing decision is reactive: lowering your price just because you lost a deal to a competitor, without understanding why you lost or whether the customer was worth having.

Tracking Price Changes Over Time

Add a Price History tab. Every time you check a competitor’s price, log it with a date. Over 6-12 months, you’ll see patterns:

• Seasonal pricing (do they raise prices before peak season?)
• Promotional patterns (regular sales, discount codes, clearance cycles)
• Response to your price changes (do they adjust when you do?)

Use a pivot table to chart competitor pricing over time. Go to Insert > Pivot Table, put Date in rows, competitors in columns, and their price as values. This gives you a timeline view of the market.

Building a Pricing Response Framework

Once you have data, document your decision rules. This prevents emotional pricing decisions under pressure:

Scenario	Our Response
Competitor drops price 5-10%	Monitor for 30 days, no action unless we lose deals
Competitor drops price 15%+	Investigate reason, adjust if structural not promotional
We’re highest priced in market	Verify we’re actually winning on quality/service claims
New competitor enters lower	Welcome package or introductory offer consideration
Competitor exits market	Opportunity to test modest price increase

Document this in a Pricing Policy tab. When a salesperson asks “should we match this competitor?” you have a written answer.

Next Step

List your top five competitors and your five best-selling products. Spend an hour this week finding and recording competitor prices for each combination. Calculate where your prices sit relative to the market median. If you’re consistently 20%+ above median with no documented reason why (and no customers who explicitly choose you for quality), you have a pricing problem to investigate. If you’re consistently below median, you have a margin improvement opportunity.