Perceptual Map Template updated Feb 2020. Click here to download the free Excel template… free_perceptual_map_template_2020
This link will open as an Excel spreadsheet and is ready to use. You simply input into the grey-colored cells and the chart is produced at the bottom of the spreadsheet – ready to copy and paste.
Overview of the Template
When you open the template, it looks like this…
And when you enter your marketing data (axis/attribute labels, brands/firms, and perceptual scores), then the perceptual map is produced automatically and looks like this…
What’s New in the 2020 Template Version?
The mapping template is maintained and updated yearly. The 2020 version now includes:
- A Data Converter spreadsheet (in a separate worksheet tab) – that allows you to convert data in any scale into a 1 to 9 scale for improved formatting and presentation of your perceptual map
- Improved instructions – although this Excel template is very easy to use, simple step-by-step instructions are available to follow
- And although not recommended, a password to unprotect the worksheet is listed at the top of the template
Tips on Using the Mapping Template
Perceptual maps are designed to show the perceived positioning of brands in the marketplace. Overall consumer, or market segment, perceptions are shown for competing brands.
The template uses a traditional two-axis perceptual map that is usually taught to marketing undergraduate students. But please note that positioning maps can be constructed in different ways. Therefore, this website has several templates available that can produce different forms of positioning maps.
There is also a separate data convertor spreadsheet available if your starting data is not in a 1 to 9 point scale – but this is now automatically included in the 2020 updated template.
Check Out Multi-Map Template
If you need to construct more than one perceptual map – which is the most common scenario – then you might be better off with the Fast Perceptual Map Maker. This template allows the input of up to 10 attributes and up to 25 brands, which then enables you to review up to 45 perceptual maps within a few minutes. A great analysis tool.
If you have any problems, just email me and I’ll see if I can help you. (email = firstname.lastname@example.org)
Instructional Video on Using the Template
The following video also shows you how to use the Excel template.