Van Westendorp PSM Excel Template

Van Westendorp PSM Excel Template

Published on  
1 July 2022
Updated on  
29 December 2023
Chun Hui Lee image
Chun Hui Lee
Insights Writer
Van Westendorp Price Sensitivity Meter
VW

The Price Sensitivity Meter helps determine psychologically acceptable range of prices for a single product and approximately estimate price elasticity.

The Van Westendorp Price Sensitivity Meter is used to determine the psychologically acceptable range of prices for a single product or service. Learn more about the method and its output with our free Excel template.


VW
Features and claims
Pricing research

Van Westendorp Price Sensitivity Meter

The Price Sensitivity Meter helps determine psychologically acceptable range of prices for a single product and approximately estimate price elasticity.

Overview of the Van Westendorp PSM Excel template

The Van Westendorp Price Sensitivity Meter (PSM) is one of the most commonly used pricing techniques to reveal consumer attitudes toward price points and discover the psychologically acceptable range of prices for products and services. To help you understand the Van Westendorp output, Conjointly has set up a free Excel template with an example study for a multivitamin brand.

Conjointly Van Westendorp PSM Excel template

Sign up on Conjointly for free to download the template.

Using Van Westendorp PSM Excel template

On the Respondents tab , the columns AA to AD are the output for the Van Westendorp, where:

  • Column AA = the “too cheap” price.
  • Column AB = the “cheap” price.
  • Column AC = the “expensive” price.
  • Column AD = the “too expensive” price.
Using Van Westendorp PSM Excel template

Download the full report of the example experiment

The example study is based on Q4 of the “Example experiment 3: Gabor-Granger and Van Westendorp”, which is accessible for free in your list of experiments.


Read these articles next:

Can you make perceptual maps from fake data? (A replication study)
Creating a perception map

Can you make perceptual maps from fake data? (A replication study)

This study investigates the claim that synthetic LLM-generated data could be used effectively for creating perceptual maps in market research contexts.

View article
Kellogg's vs. Kellanova: Which Do Consumers Prefer?
Comparing the new and old Kellogg Logo

Kellogg's vs. Kellanova: Which Do Consumers Prefer?

To assess the effectiveness of Kellogg's recent rebrand to Kellanova, the Business Name Evaluator and Logo Test surveys compare the business names and their logos to see which respondents preferred.

View article
Are consumers passing on Ray-Ban Meta glasses?
Ray-Ban Meta smart glasses Credits: Meta / EssilorLuxottica

Are consumers passing on Ray-Ban Meta glasses?

Ray-Ban Meta glasses were dubbed 'pervert glasses' amid growing privacy concerns in 2026. Will real consumers pass on the product? We ran a concept test to find out.

View article