Free Download

Set-Up Steps for the Free Perceptual Map Excel Template

  1. Click the below link to download
  2. Open the Excel file
  3. Click to enable editing
  4. Follow the instructions in the spreadsheet – or watch the instructional video below.

Get Your Free Download of the Perceptual Map Template

Click here to download your free_download_perceptual_map_template

No password required!

There are formulas and calculations scattered across the spreadsheet, so the key cells have been protected to ensure that the template runs without errors.

Follow the instructions and enter your data as indicated – the template will work fine and no password is required.

Overview of the Template

When you open the template, it looks like this…

free perceptual map template

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…

example perceptual map template

What’s New in the Mapping Template?

The mapping template is maintained and updated yearly. The latest 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.

The spreadsheet is easy to use, but you can follow these instructions for more information. You can produce all the perceptual maps in COLOR, please see the section on how to format your map.

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 latest 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 25 attributes and up to 25 brands, which then enables you to review up to 300 perceptual maps amazingly fast. A great analysis tool.

Need Help?

If you have any problems, just email me and I’ll see if I can help you. (email = [email protected])

Instructional Video on Using the Template

The following video also shows you how to use the Excel template.


Helpful Academic Journal Article

Perceptual Position and Competitive Brand Strategy in a Two-Dimensional, Two-Brand Market

close

Sign up to our Newsletter and Get a Free PDF on the Seven MUST-DOs of Perceptual Maps

We don’t spam! Read our privacy policy for more info.