Net Promoter Score (NPS) Calculator

Excel Template

This Excel template makes calculating Net Promoter Score simple and automated. Just enter your survey response counts (0-10 ratings) in the left column, and the spreadsheet automatically:

  • Categorizes responses into Promoters (9-10), Passives (7-8), and Detractors (0-6)
  • Calculates your NPS score using the standard formula
  • Shows total respondents and category breakdowns
  • Provides score interpretation (Poor, Fair, Good, Excellent)
  • Includes color-coded visual indicators for easy reading

Perfect for offline analysis, team sharing, or integrating into your existing reporting workflow.

NPS Calculator Excel Template

There are two options to use the template:

Clone Google Sheets

Click "File → Make a copy" to create your own version