The first tab is suitable when you have relatively precise information on market shares and market growth rates and want to input these numbers.Īnd the second tab is suitable when you don’t have the exact market share or market growth information, but you have a good idea of how you want the BCG matrix to look. There are two tabs in the free Excel template to make the BCG matrix. Please note that you can add up to 50 portfolio/brands on to your own matrix. The template will provide both a color version and a black and white version, depending upon your needs, as shown below.
This template is designed for you to create a BCG Matrix within minutes using Excel. Please scroll down for more information on the template, or review the simple instructions on how to use the BCG Matrix spreadsheet. Please click here to download the free BCG_matrix_Excel_template_50_brands-2021-v2
The Marketing Study Guide offers a free BCG Matrix Excel template that is very quick and easy to use, even if you don’t normally use Excel. The BCG Matrix was developed many years ago to help large corporations make investment decisions in regards to their business portfolios and brands. It is a concept that is included in many modern-day marketing and strategy textbooks.
Download the Free Excel template for the BCG Matrix
