Download free Excel template for the Van Westendorp PSM
---
The pricing lead or VP Product setting a new price can find a free Van Westendorp Excel template in minutes, from Conjointly, OpinionX, Eloquens, eFinancialModels, or the open source pricesensitivitymeter package on CRAN (CRAN README). The real decision is not which template to grab; it is whether the acceptable price range that template returns should set the number you charge. Every one of these tools computes the same four-curve intersection correctly, but none of them can turn four uncontrolled survey questions into a causal estimate of what price actually changes behavior.
- Free Van Westendorp templates exist and are functionally interchangeable: Conjointly, OpinionX, Eloquens, eFinancialModels, and the CRAN
pricesensitivitymeterpackage all compute the same intersection points from the same four questions. - The templates get the arithmetic right; the problem sits upstream, in survey data collected with no purchase consequence, no competitive context, and no randomization.
- Stated prices in subscription pricing research tend to run higher than what customers actually pay, consistent with hypothetical bias in unincentivized willingness-to-pay questions; the direction is well documented, the magnitude varies by study (GetMonetizely).
- The method's four intersection points are known to shift under resampling and depend on respondents having a real reference point for the product's value, which is rare for anything new (Relevant Insights).
- Van Westendorp is scoped to a single, well-defined product; once a decision involves multiple attributes or competitors, a randomized discrete choice design is the tool that can test many configurations in a single study instead of one (Drive Research).
What does a Van Westendorp Excel template actually calculate?
It plots four self-reported price points, too cheap, cheap, expensive, and too expensive, as intersecting curves and reads off the crossing points as an acceptable price range. Peter van Westendorp developed the method in 1976 specifically to keep pricing research cheap: four questions, no experimental manipulation, no control group (Wikipedia). A template automates that plot and the interpolation between data points. What it cannot automate is the thing the plot depends on: respondents giving prices that predict what they would actually do at the register. Nothing in the four questions puts a real choice, or a real cost, in front of anyone.
Where the free templates actually come from
The commoditization of this math is itself informative. Conjointly, OpinionX, Eloquens, and eFinancialModels all publish free spreadsheet versions. Hotjar, LimeSurvey, SurveyKing, and XLSTAT build the four-question flow directly into their survey tools. The CRAN pricesensitivitymeter package standardizes the calculation as three lines of R code. When a method's entire analytical output can be replicated by an open source package with no proprietary logic, the remaining decision is not computational. It is whether the input data was collected in a way that supports a causal claim about price and behavior. Van Westendorp's inputs never were.
Why the spreadsheet math is not the hard part
The four questions are unprompted, unconstrained, and unconsequential. A respondent names "too expensive" for a product they have never used, with no competing product named, no attribute traded off, and no assignment of who sees which price. Practitioner critiques of the method point to exactly this: direct price questioning invites lowballing, and respondents lack any reference point to value a new or unfamiliar product (Relevant Insights). A template cannot fix that, because the fix is not arithmetic. It is design: what varies, what is held constant, and who is randomly assigned to see what. None of that happens inside four open price questions, however cleanly the spreadsheet plots the result.
Is Van Westendorp's price range accurate?
It is directionally useful but not reliable enough to set a number with revenue behind it. Subscription pricing research shows stated prices running higher than what customers actually pay (GetMonetizely), the standard pattern of hypothetical bias in unincentivized willingness-to-pay questions: respondents name a price when nothing is actually at stake, and that price tends to sit above what they later accept once a purchase is real. The exact size of that gap varies by study and by market; the direction does not. A Van Westendorp range built entirely from that kind of self-report inherits the same bias, and a template has no way to correct for it because it never sees a real choice to check the answer against.
The four-point estimate is not stable
The acceptable price range comes from four intersection points calculated on whatever sample answered the survey. Resample that population, or even resample the same population at a different time, and the four intersection points move. Practitioner critiques document this instability repeatedly, but none attach a number to how far the range shifts; the finding is qualitative, not a stated margin of error (Relevant Insights). A wide, unstable range is a reasonable input to a conversation. It is a weak basis for a single number on a price sheet.
Van Westendorp template vs. a randomized pricing experiment
| Van Westendorp Excel template | Randomized pricing experiment | |
|---|---|---|
| What it measures | Self-reported price thresholds for one product | Choices among priced alternatives assigned by design |
| Question source | Four unprompted price questions, no context | Discrete choice tasks with randomized price and attribute levels |
| Competitive context | None | Named alternatives, held constant or varied by design |
| Estimation | Spreadsheet interpolation of four points | Randomized experiments analyzed with discrete choice models (McFadden discrete choice, Mixed Logit, ICLV) |
| Known bias | Stated WTP runs high, unincentivized; direction documented, magnitude varies by study ([GetMonetizely](https://www.getmonetizely.com/articles/van-westendorp-price-sensitivity-meter-unlocking-saas-pricing-potential-while-navigating-limitations)) | Say-do gap tested against a human baseline, not eliminated |
| Best for: | A single, well-defined product, early direction-setting, no budget at risk | A pricing decision with real revenue at stake, or more than one product or attribute to test |
What would make a price estimate causal?
Randomization, not a better spreadsheet. A causal estimate of what price changes behavior requires assigning different prices, or different products, to different respondents by design, then measuring which assignment actually moves choice. DCE, Mixed Logit, and ICLV are estimators for analyzing that kind of data, not causal methods in themselves; the causal identification comes from the randomized manipulation in the experiment, not from the model fit afterward. A plain multinomial logit model also carries an assumption worth naming here: independence of irrelevant alternatives, which means it cannot represent two products a respondent sees as close substitutes. Mixed Logit and ICLV relax that assumption by letting preferences vary across the simulated population, which matters once a pricing decision involves more than one competing option.
Subconscious tests this approach with a randomized simulation, then checks the result against real human responses on published pricing studies. Our best configuration reaches 87% of the measured human ceiling on one study. That is a rank correlation of 0.832 against the published human result. Two independent samples of real humans reach 0.959 against each other. Across all 43 studies that passed design filters, the mean rank correlation is 0.73, a lower and more honest number to anchor expectations on. This is a replication result against published studies, not a guarantee for a market that has never been tested. Published studies can sit in a model's training data. The replication protocol behind these numbers is built to address that, not to pretend the problem doesn't exist. Full methodology and per-study results are in the causal fidelity paper, and current results by study are tracked on the leaderboard.
When does Van Westendorp actually work?
It works when the decision is genuinely small: one product, one price, low stakes, and a rough range is enough to move a conversation forward. Industry guidance treats it that way too: a cheap first pass before conjoint analysis, reserved for a single or very few product formulations (Drive Research). Once a decision involves multiple products, competitors, or attributes, the method is out of scope by design. A randomized discrete choice design can test many configurations in a single study. More background on how randomized experiment design and discrete choice estimation fit together is in the methods and validation hub.
Before setting a price from a Van Westendorp output, run the same product through a small randomized discrete choice test with a named competitor and a holdout group, and check whether the range survives. If it does, the spreadsheet range was close to right for the wrong reason. If it doesn't, that gap is the actual finding. When you're ready to design that test properly, meet the team.