Net Promoter Score (NPS) Calculator
Turn counts of 0 – 10 recommendation scores into promoter, passive, and detractor shares and the resulting Net Promoter Score.
Responses by survey score
Whole-number counts, 0 or greaterResponses analysis
Updates as counts changeResponse composition
Share of all responses| Group | Responses | Share |
|---|
How to use this NPS calculator
What this calculator does
This calculator converts the number of survey responses at each recommendation score from 0 through 10 into the three standard Net Promoter Score groups and then computes NPS. Scores 9 and 10 are promoters, 7 and 8 are passives, and 0 through 6 are detractors. The calculation is an exact identity from the entered counts: promoter percentage minus detractor percentage. It helps summarize a completed recommendation survey, compare the same survey over time, or check a spreadsheet or dashboard calculation. It does not determine why respondents chose a score, prove customer retention or growth, or establish whether a score is “good” for a particular industry. Bain's explanation of how Net Promoter Score is measured describes the 0 – 10 grouping and the promoter-minus-detractor formula.
When to use it
Use it after an NPS survey closes and you have a count for each score; when reconciling results from two reporting systems; when testing how a corrected response count changes the headline NPS; or when exporting a compact, auditable workbook for a review meeting. If you only have promoter, passive, and detractor totals rather than the individual 0 – 10 counts, distribute those totals back to the actual score buckets before using this version so the inputs remain traceable to the survey response scale.
How to calculate
- The calculator opens with a ready-to-use demonstration set: 12 responses at score 10, 15 at 9, 10 at 8, 20 at 7, 6 at 6, 3 each at 5, 4, and 3, 1 at 2, and 0 at 1 and 0. The example results and Excel workbook are available immediately.
- Replace each score count with the number of people who selected that exact rating. Counts are required whole numbers from 0 to 1,000,000. Commas are accepted only as standard thousands separators, such as 1,250.
- Read the NPS and the promoter, passive, detractor, and total response metrics. The response-composition chart and table use the same current counts as the result cards.
- Select Download Excel to create a current-state XLSX workbook containing the summary, every 0 – 10 input, and the three-group breakdown. Select Reset to clear the demonstration and all entered counts. After Reset, Excel download is disabled until all score fields are complete and at least one response exists again.
Input guide
Scores 10 and 9
Score 10 and Score 9 are required nonnegative whole-number response counts and form the promoter group. Examples are 12 and 15. Increasing either count usually raises NPS because it increases the promoter share, although the total response count also rises. Do not enter a percentage, rating average, decimal, or the score itself; enter how many respondents chose that score.
Scores 8 and 7
Score 8 and Score 7 are required nonnegative whole-number counts and form the passive group. The demonstration uses 10 and 20. Passives are included in the total denominator but are not directly added to or subtracted from the NPS numerator, so adding passive responses can move NPS toward zero by diluting promoter and detractor shares. A common mistake is to treat an 8 as a promoter.
Scores 6, 5, 4, and 3
Score 6, Score 5, Score 4, and Score 3 are required nonnegative whole-number counts in the detractor group. Example values are 6, 3, 3, and 3. Increasing any of these counts generally lowers NPS because the detractor share rises. Keep zeros when no respondent chose a score; an empty field is not the same as a verified count of zero.
Scores 2, 1, and 0
Score 2, Score 1, and Score 0 are also required detractor counts. The example uses 1, 0, and 0. As with the other fields, accepted input is an integer count, not a percentage or decimal. Negative values, scientific notation, and ambiguous comma-decimal forms are rejected instead of being silently reinterpreted.
Output guide
Net Promoter Score (NPS) is the promoter share minus the detractor share, expressed in percentage points on a theoretical scale from – 100 to +100; this calculator displays two decimals. Promoters (9 – 10), Passives (7 – 8), and Detractors (0 – 6) show both each group's response count and its share of Total responses. The header pills repeat Total responses, Promoters share, and Detractors share for a quick scan. In the response-composition table, Group names the classification, Responses is its count, and Share is its percentage of the total. The donut chart encodes those same three shares; it is a composition view, not a separate metric. A zero NPS means promoter and detractor percentages are equal, while a negative result means the detractor percentage is larger. Industry comparisons require comparable survey methods and populations rather than the score alone.
Worked example
For the opening example, promoters are 12 + 15 = 27, passives are 10 + 20 = 30, and detractors are 6 + 3 + 3 + 3 + 1 + 0 + 0 = 16. Total responses are 27 + 30 + 16 = 73. The promoter share is 27 ÷ 73 × 100 = 36.99%, and the detractor share is 16 ÷ 73 × 100 = 21.92%. Therefore NPS = 36.99 – 21.92 = 15.07 percentage points. The passive share, 41.10%, remains part of the total denominator even though it is not directly subtracted or added in the NPS formula.
How the NPS formula works
NPS = (Promoters ÷ Total responses × 100) – (Detractors ÷ Total responses × 100)
The classification boundaries matter as much as the arithmetic. The standard method places 9 – 10 in promoters, 7 – 8 in passives, and 0 – 6 in detractors. Bain's overview of the Net Promoter System explains the same grouping and describes NPS as the percentage of promoters minus the percentage of detractors. Because every response remains in the denominator, adding passives can change the score even though passives do not appear as a positive or negative term in the numerator.
Interpretation caution. NPS is most informative when the survey question, audience, collection channel, timing, and sampling approach are consistent. A score can support trend tracking, but it should be read with response volume, qualitative feedback, and comparable benchmarks. Qualtrics' NPS guide provides additional context on survey use and calculation.
Common mistakes and practical checks
First, do not average the 0 – 10 ratings and call that number NPS; the metric is based on category percentages, not the arithmetic mean of scores. Second, do not classify scores 7 or 8 as promoters. Third, distinguish a verified zero count from a missing field: this calculator accepts zero but treats a blank field as incomplete. Fourth, keep the denominator consistent when comparing reports. If one report excludes certain responses or uses a different survey population, the NPS values may not be directly comparable.
For quality control, verify that promoter, passive, and detractor counts add exactly to Total responses and that their displayed shares add to approximately 100%, subject only to rounding. If promoter and detractor counts are identical and there are any number of passives, NPS is exactly 0 because the two category shares have the same denominator. At the theoretical extremes, all-promoter responses produce +100 and all-detractor responses produce – 100. Those identities are useful checks when validating a dashboard or exported workbook.