NPS (Net Promoter Score) Calculator

Paste your survey scores or a CSV export and calculate your NPS in seconds. You also see how much the score could swing and which clients are ready to vouch for you.

  • Raw scores, counts or a whole CSV
  • Margin of error and NPS by service line
  • No signup. Nothing leaves your browser

Reading 40 scores from 0 to 10.

Everything runs in your browser. Nothing you paste or upload is sent anywhere or saved.

Your Net Promoter Score

+40

Good. More clients would recommend you than would warn people off. From 40 answers.

Detractors
6 · 15%
Passives
12 · 30%
Promoters
22 · 55%
55% promoters − 15% detractors = NPS +40

How sure you can be

Likely between +15 and +59 (±22 at 95%). A change smaller than 22 points could be noise.

One more promoter adds 1.5 points. One more detractor costs 3.4.

5 points below the average of 45, which is inside your margin of error. ClearlyRated, 2024.

Next step

Send your 22 promoters this link

They already said they would recommend you. Ask them to say it where your next client can read it.

  1. Create a free Famewall collection page and use this question as its title.
  2. Send the link to everyone who scored 9 or 10, within a day or two of the survey.
  3. They write a few lines or record a short video. You approve the ones you like and they go on a wall on your site.

No credit card. Ask for the testimonial first, and save the referral ask for later.

What would you tell someone considering us?

You told us you’d recommend us. A few lines on what changed for you, or a 30-second video, helps the next client decide.

Send in Text Record a Video

How the page looks to your promoters

How to calculate NPS: % promoters minus % detractors

The Net Promoter Score comes from one question and one subtraction. Bain & Company, who created it, still describes it that way.

The NPS formula

NPS = % promoters − % detractors

  1. Ask one question on a 0 to 10 scale

    Ask “How likely are you to recommend us to a friend or colleague?” and let people answer from 0 (not at all likely) to 10 (extremely likely).

  2. Sort the answers into three groups

    Scores of 9 and 10 are promoters. 7 and 8 are passives. 0 to 6 are detractors.

  3. Turn each group into a percentage

    Divide the number of promoters by the total number of answers and multiply by 100. Do the same for detractors.

  4. Subtract detractors from promoters

    NPS = % promoters − % detractors. The result is a whole number from −100 to +100.

The NPS formula for Excel and Google Sheets

Put one score per row in a column with a header in row 1. Type that column’s letter and paste the formula into any empty cell.

=(COUNTIF(B2:B1000,">=9")-COUNTIF(B2:B1000,"<=6"))/COUNT(B2:B1000)*100

Use the NPS calculator in 4 steps

Paste, read, split and send. There is nothing to install and no account to make.

  1. Paste your answers, a CSV or your counts

    Copy the score column from your survey tool and paste it in.

    Commas, one score per line or a whole CSV with a header row all work.

    NPS calculator with a sample client survey CSV pasted in and its score, service line, name, company, email and comment columns detected, next to a result of NPS +46 from 24 answers
  2. Read your score and how sure you can be

    You get your NPS, the split between promoters, passives and detractors, and a 95% margin of error.

    That tells you which changes are real.

    NPS calculator result showing a Net Promoter Score of +40 from 40 answers, 15% detractors, 30% passives and 55% promoters, a likely range of +15 to +59 and a comparison with the B2B services average of 45
  3. Split it by service line or client

    If your CSV has a column for service line, client, office or account manager, pick it under Split by.

    Each group gets its own NPS and margin.

    NPS calculator column picker with Split by set to Service line, above an NPS by service line table: Managed IT +36 from 11 answers, Cybersecurity +71 from 7 and Microsoft 365 +33 from 6, each with its margin of error
  4. Send your promoters one link

    Your promoters are listed with their comments. Copy their emails or download the list.

    Then send them a collection page that asks one question.

    List of 15 promoters with their comments and a copy emails button, above a next step panel showing a Famewall collection page titled What would you tell someone considering us? with Send in Text and Record a Video buttons

NPS asks about the relationship. CSAT asks about one moment.

Track both, plus retention to see who actually stayed.

NPS, CSAT, Net CSAT, retention rate and churn rate formulas
MetricFormulaTells you
NPS% promoters (9–10) − % detractors (0–6)How the whole relationship is going
CSAT% of 4s and 5s on a 1 to 5 scaleWhether one project, ticket or meeting landed
Net CSAT% good − % badThe same, on 3-face MSP ticket surveys like SmileBack
Retention rate(clients at end − new clients) ÷ clients at startHow many clients stayed
Churn rate100% − retention rateHow many clients left

NPS survey questions that get answers you can use

Ask the score question the standard way. Then ask one follow-up, and change it by score.

Send it from a named person, not a no-reply address. Keep it to the score plus one question. If you want a longer client feedback form after a project, put the NPS question first and make the rest optional.

The NPS question

How likely are you to recommend [firm] to a friend or colleague?

0 = not at all likely · 10 = extremely likely

The follow-up, by score

  • Detractors (0 to 6)

    What is the one thing we should fix first?

  • Passives (7 or 8)

    What would have made this a 10?

  • Promoters (9 or 10)

    What would you tell someone considering us?

Agencies, asking clients

  • How likely are you to recommend our agency to another marketing lead?
  • Which part of our work made the biggest difference for you this quarter?
  • If you could change one thing about how we report, what would it be?

In-house marketing teams, asking customers

  • How likely are you to recommend [product] to a colleague in your field?
  • What were you trying to get done when you started using [product]?
  • What almost stopped you from buying?

MSPs and IT firms

  • How likely are you to recommend us to another business owner?
  • Think about your last few tickets. What stood out, good or bad?
  • What do you want to see at your next quarterly review?

Recruiting and staffing firms

  • How likely are you to recommend us to another hiring manager?
  • How well did the people we placed fit your team?
  • For candidates: how likely are you to recommend us to a friend who is job hunting?

Accounting, legal and advisory firms

  • How likely are you to recommend our firm to a friend or colleague?
  • How clearly did we explain what we were doing and why?
  • How did this year’s work with us compare with last year’s?

Your promoters are already your testimonial list.

Most firms run NPS, thank the 9s and 10s and stop there. Those clients just told you they would recommend you. Many will say it in public if you ask them the right question.

So ask. Send every promoter a collection page with one question. They write a few lines or record a short video testimonial in the browser. You approve the best ones and they go live on a wall of client results on your own site.

If you run more than one service line, give each its own wall. Jumpstart, a recruiting firm, runs nine walls with separate ones for clients and candidates. They serve about 32,000 views a month. MSPs can do the same with a wall on each service page, and agencies run one wall per client site.

Save the referral for a second ask. The testimonial is the easier yes, and it gives you a reason to thank them when you ask for a referral.

What would you tell someone considering us?

You told us you’d recommend us. A few lines on what changed for you, or a 30-second video, helps the next client decide.

Send in Text Record a Video

The question to use as your page title.

Frequently asked questions

Looking for software to send NPS surveys on a schedule? Here are six NPS tools we tested.

How do you calculate NPS?

Subtract the percentage of detractors (scores 0 to 6) from the percentage of promoters (9 or 10). Passives (7 or 8) count in the total only. If 55% of answers are promoters and 15% are detractors, your NPS is 40.

Is NPS a percentage?

No. It is built from two percentages, but the result is a number from −100 to +100. Write 40, not 40%.

What is a good NPS for a B2B services firm?

ClearlyRated’s 2024 study put the average B2B services firm at 45. IT services scored 55, staffing 45, accounting 38 and legal 37. A score above 50 is usually called excellent and above 70 world-class.

How many responses do you need for a reliable NPS?

With 40 answers the margin of error is about ±22 points. With 100 it is about ±14. Under 20 answers, read the comments and treat the score as a rough guide.

What is the difference between NPS and CSAT?

NPS asks how likely a client is to recommend you, on a 0 to 10 scale. CSAT asks how satisfied they were with one thing, usually on a 1 to 5 scale, and counts the share of 4s and 5s. Use NPS for the relationship and CSAT for single tickets or projects.

How do you calculate customer retention rate and churn rate?

Retention rate is clients at the end minus new clients won, divided by clients at the start, times 100. Churn rate is 100 minus that. Start with 40 clients, win 6 and end with 42, and you kept 36. That is a 90% retention rate and 10% churn.

Why teams use Famewall

Agencies, marketing teams and professional firms use Famewall to put what their clients say on their own website