NPS Calculator

NPS Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Net Promoter Score Calculator

Enter the number of survey responses received for each score from 0 to 10. The calculator classifies respondents, computes NPS, visualizes the response mix, and exports the current analysis to Excel.

Responses 73 Promoters 27 Detractors 16 NPS 15.07

Responses by survey score

Use whole, non-negative response counts. Scores 9–10 are promoters, 7–8 are passives, and 0–6 are detractors.

Response composition

Promoters are the largest group at 36.99% of responses.

The score is positive because the promoter share exceeds the detractor share by 15.07 percentage points.

Score distribution

Score 7 has the most responses.

Responses concentrated at 7 or 8 increase the total sample but do not directly change NPS.

Response detail

The table uses the same current-state values as the results, charts, accessible summaries, and Excel workbook.

Score Classification Responses Share NPS contribution
NPS contribution shows the percentage-point effect of each score. Promoter rows are positive, passive rows are zero, and detractor rows are negative.

What does this NPS calculator estimate?

Net Promoter Score summarizes how likely respondents are to recommend a product, service, or organization. A standard survey asks for a rating from 0 to 10. Responses of 9 or 10 are classified as promoters, 7 or 8 as passives, and 0 through 6 as detractors. The calculator converts the counts into group shares and subtracts the detractor percentage from the promoter percentage. The result ranges from −100, when every respondent is a detractor, to +100, when every respondent is a promoter.

NPS is a compact directional metric, not a complete diagnosis. It is most useful when the same survey method, audience, channel, and timing are repeated consistently. Method changes can move the result even when customer sentiment has not changed. The original NPS framework is associated with Bain & Company; its measurement overview explains the basic promoter, passive, and detractor categories.

How should each score input be used?

Scores 9 and 10: promoters

Enter the number of respondents who selected 9 or 10. These fields are required for a meaningful promoter count, although zero is valid. Higher promoter counts increase NPS as long as the total sample is otherwise unchanged. A common mistake is to enter percentages instead of response counts. Use raw counts here; the calculator derives percentages automatically.

Scores 7 and 8: passives

Enter the number of respondents who selected 7 or 8. Passives are included in total responses, so they affect every group’s percentage, but their direct NPS contribution is zero. Adding passives while promoter and detractor counts remain fixed moves both shares closer to zero and generally reduces the absolute size of NPS. Do not omit passive responses from the denominator.

Scores 0 through 6: detractors

Enter the count for each detractor score. Higher detractor counts reduce NPS. Keeping separate score fields is useful because a shift from 0 to 6 does not change NPS classification, but it may still indicate meaningful movement in customer sentiment. Every field accepts whole, non-negative counts. Negative or nonnumeric entries are treated as invalid and excluded until corrected; decimal counts are rounded down because a response cannot be fractional.

How is Net Promoter Score calculated?

The model first adds all 11 response counts. Promoters equal the sum of scores 9 and 10. Passives equal the sum of scores 7 and 8. Detractors equal the sum of scores 0 through 6. Promoter share is promoters divided by total responses, and detractor share is detractors divided by total responses. NPS is then calculated as 100 × (promoters − detractors) ÷ total responses. Full precision is retained internally and the displayed score is rounded to two decimals.

When total responses are zero, the score is not mathematically defined. The calculator therefore shows an em dash, clears percentage outputs, and replaces charts with compact guidance rather than drawing empty or misleading visuals. Qualtrics provides a useful practical explanation of NPS surveys, including how the core question is typically phrased.

How should the outputs, charts, and table be interpreted?

The primary NPS result is expressed in points rather than as a conventional percentage. A positive score means promoters outnumber detractors; zero means their shares are equal; a negative score means detractors outnumber promoters. A higher score is usually directionally favorable, but “good” depends on industry, customer type, geography, survey channel, and historical baseline. Comparisons are strongest when the underlying methodology is stable.

The promoter, passive, and detractor cards show group counts. Their share cards show the corresponding percentages of the full sample. The composition donut uses the same three category totals and percentages, while the score-distribution chart preserves the detail of all 11 response choices. The table goes one step further by showing each score’s exact share and NPS contribution. A promoter response contributes positively, a passive contributes zero, and a detractor contributes negatively.

The Excel workbook captures the current state at the moment of download. It includes summary results, all inputs, the category breakdown, score-level detail, and methodology notes. This is useful for audit trails, monthly reporting, or combining multiple survey waves outside the browser.

What are the main tradeoffs and common mistakes?

  • Sample size: a small response count can produce a volatile score. Track the number of responses alongside NPS rather than reporting the score alone.
  • Selection bias: people who choose to respond may differ from those who do not. Survey distribution and response rates matter.
  • Timing effects: asking immediately after support, renewal, cancellation, or purchase can produce different results.
  • Benchmark misuse: external benchmarks may use different audiences and methods. Internal trends are often more actionable.
  • Ignoring comments: NPS indicates direction but not cause. Pair the rating with an open-text follow-up and analyze recurring themes.

For survey design and interpretation, the Pew Research Center’s questionnaire design guidance highlights wording, order, and response-option effects that can influence answers. Use NPS with retention, complaints, repeat purchase, and qualitative feedback rather than treating it as a standalone forecast or a substitute for customer research.