skip to Main Content

Competitor Price Comparison and Analysis Excel Template

4.7 (10 reviews)

Competitor Price Comparison Template will help you to analyse and calculate the correct price positioning for your products and services in Excel.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Market analysis is a must for any company hoping to increase revenue and stay ahead of the competition in any sector. Most of the buyers compare the offers of several brands in search of a greater deal. One of the most practical ways to make a competitive pricing analysis and see the market position of their products and services is using a tool like this Competitor Price Comparison Excel Template.

These are the reasons why price comparison  is crucial in order to have the right price position within the market you operate. Also, providing the right price for the right product or service will always keep you one step ahead.

If you have competitors in the same industry then you need to look at the positioning of your products according to competition. Hence, making price comparisons and competitor price analysis is an indispensable action for competition. Thanks to this Competitive Pricing Analysis Template, you will guarantee yourself that you are on the right track.

Price Comparison and Analysis Template

Basically the flow of the template:

  1. Type product names, segments and market volumes in the variables table
  2. Define competitor brands and type product prices

As a result, the template will provide you with a weighted price comparison index to see the big picture. Play with the categories, expand/collapse product groups and take necessary actions for areas that seem problematic to you.

Above all, our Competitive Pricing Analysis Template is constructed by three parts;



These are the parts where you will be inputting your data and getting your results in the end. All the parts and sections are briefly explained. So, all you need to do is to follow the steps below.


Start with this section. This is where you input your raw data by simply clicking on the “VARIABLES” button. In this part, you simply will write your product names, segment types and market volumes of each product. After that, list down the name of brands that sell the same product.


After completing this part, write down your rivalries which you want to see in the analysis in the brand column.


Click on the “PRICES” button on the dashboard. It is the data that shows the worth of each product brand by brand. Input prices for each product and brand which will be used in the competitor price comparison. You can leave the price blank if you don’t have data. Once you put the prices of the products for each brand your data will be ready for the final analysis.


Note: The products and brands you put in the previous section is going to be shown automatically in this part.


This section is fed by the values you input in the Variables and Prices section. You can also fix the price index of the selected brand to 100 from the right-hand side and other brand indexes will adapt automatically. All you have to do is refresh the report with the Refresh button.


In short, it lets you make analyze your consolidated competitor price comparison records.

For Strategic Pricing Decisions, Ensure That You See The Big Picture

Comparing different products or services can be confusing when faced with numbers. Some of your products will be cheaper and some of them will be costly.

You should also consider how important and strategic a product is. For instance, if you are cheap at almost all products but way expensive on a few high-demand ones, you will probably lose market share and sales.

This is where mathematics comes into play. You should make some “Weighted Averages” by using market volumes. However, without automatization, this can be tedious work. That’s why we have prepared this Price Analysis Tool to provide you with a quick competitive price analysis.

Competitor Price Comparison Excel Template Features Summary

  • Pricing Analysis in Excel Comparison Template
  • Weighted average calculation for average figures
  • Supported by pivot tables and charts
  • Full print ready, cool design
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Includes VBA code and macros

Price Comparison Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.



10 reviews for Competitor Price Comparison and Analysis Excel Template

  1. Albina

    Hola Someka!
    Can I have this in Spanish?

    • Someka

      Hi Albina,

      After unprotecting the sheets, you may easily edit them as well as translate them. To learn more about unlocking please click here.

  2. Cleve P

    Obviously your excel is really successful and really useful for my team members thank you for this. But I need to do some special customization (removing logo )
    How is it possible

    • Someka

      Hi Cleve,

      You can remove the logo or replace it with your own logo for each sheet. For Free Versions, you are not allowed to remove the logo or alter any copyrighted material in the template.
      You can do it in the full version. Please check how to do that in this link.


  3. Liberty

    I really search such a product. Finally I found. THX

  4. Leroy

    Great excel! I need to make sure it is one time charge for one of the downloads and not multiple charges.

    • Someka

      Hello Leroy,

      All our prices are processed as one-time payment. You receive the template after you make the purchase.
      There is no subscription or recurring payments. For more information please click here.

  5. Dan Burbank

    I just purchased the Price Comparison and Analysis Template. After opening it, it doesn’t seem to perform correctly. I have over a 1000 products and the analyze tab and the data doesn’t change when selecting a different brand. I couldn’t find the reason, can someone help me?

    • Someka

      Hi Dan,

      Thanks a lot for your interest! We have explained how to refresh the analysis table in the yellow notes on the navigation page. Did you see it? There is an additional step to do to update the analyze tab, otherwise the changes won’t be reflected in the chart.

      We recommend having a look at it once more and watch the product video. Please contact us if you still can not figure out how to do it.


  6. Phil

    Nice work thanks someka

  7. Sabri AL SAQLAB

    the zip file sent is corrupted, it wont unzip

    • Someka

      Hello Sabri,

      Sorry for the problem you had on this template. We’ve just sent the unzipped version of the template which you can directly download to your computer.

      Hope this helps!

  8. Perla

    hi team this app is very efficient and useful for me and so I want to share with my team members.
    Please change my license to multi user.

    • Someka

      Hello Perla,

      We may surely upgrade your license from single-user to multi-user. Just email us at and our team will contact you with a link to upgrade your license.

  9. Hemand11

    This template is very effective at determining a proper price to purchase which is a highly complex issue to find the most economic ones that we struggled with for each time.

  10. Vuthy

    Need file and learning

    • Someka

      Hello there! Didn’t receive the file? We contacted you immediately and sent the file to your e-mail address.

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.