Free CSAT calculator
Paste raw scores, choose one column of a CSV file, or enter counts per rating, on a 5-point or 7-point scale. Get the CSAT percentage, the counts, the average and each step. No signup. All processing is in your browser.
Put one score on each line, or separate the scores with commas, semicolons, tabs or spaces. Scores must be whole numbers. A comma always separates two scores: 4,5 is the score 4 and the score 5.
Your browser reads the file on this device. Values can be separated by commas, semicolons or tabs. Scores must be whole numbers. Row 1 can be a heading. Empty cells are skipped, and the result gives their number.
Enter the number of responses for each rating. An empty field counts as 0. Thousands separators are accepted.
Correct this input, then calculate again:
Your CSAT
Average rating
Satisfied responses
Total responses
Responses per rating
| Rating | Responses | Counted as |
|---|
Calculation steps
What this CSAT calculator does
Customer Satisfaction Score (CSAT) is the percentage of survey responses that are satisfied. A survey export can have one score for each person. This calculator takes those raw scores, one column of a CSV file or counts per rating. It gives the CSAT percentage, the counts, the average rating and each calculation step. Your scores and files stay in your browser.
How CSAT is calculated
Divide the number of satisfied responses by the total number of responses, then multiply by 100. Source: CSAT calculator, SurveyMonkey.
CSAT = satisfied responses ÷ total responses × 100
Which ratings count as satisfied
- 5-point scale: ratings 4 and 5. SurveyMonkey states this rule. Source: CSAT calculator, SurveyMonkey.
- 7-point scale, first option: ratings 5, 6 and 7. These are all the ratings above the neutral midpoint, which is 4. Youform's calculator uses this rule. Source: CSAT calculator, Youform.
- 7-point scale, second option: ratings 6 and 7. SurveyMonkey says that positive typically means 6 and 7, and that some teams include 5, which you must state explicitly. Source: How to calculate CSAT, SurveyMonkey.
There is no single rule for a 7-point scale, so this calculator gives you both options. Use the rule that your team already uses, and name the rule when you report the score.
How the average is calculated
CSAT uses only the count of satisfied responses. The average uses every rating. Source: CSAT calculator, Youform.
Average = sum of (rating × responses) ÷ total responses
Worked examples
5-point scale, with counts: rating 1 = 5, rating 2 = 5, rating 3 = 10, rating 4 = 40, rating 5 = 40. The total is 100 responses. Satisfied responses are 40 + 40 = 80, so CSAT is 80 ÷ 100 × 100 = 80%. The sum of ratings is 1 × 5 + 2 × 5 + 3 × 10 + 4 × 40 + 5 × 40 = 405, so the average is 405 ÷ 100 = 4.05.
7-point scale, with the scores 7, 6, 5, 4 and 1. With ratings 5, 6 and 7 as satisfied, 3 of 5 responses are satisfied, so CSAT is 3 ÷ 5 × 100 = 60%. With ratings 6 and 7 as satisfied, 2 of 5 responses are satisfied, so CSAT is 2 ÷ 5 × 100 = 40%. The average does not change: 23 ÷ 5 = 4.6.
Rounding
The results show a maximum of 2 decimal places. The steps show ≈ when a value is rounded and = when it is exact. If 2 decimal places would show a limit that the exact value does not reach, such as 100%, the result shows more decimal places.
How to use the calculator
- Choose your scale and the ratings that count as satisfied.
- Choose the tab that matches your data: Paste scores, CSV file or Counts per rating.
- Enter your data. If your CSV file has more than one column, choose the score column. Then select Calculate CSAT.
- Read the CSAT percentage, the counts, the average and the calculation steps. If a score is not valid, a message shows its position, and there is no result until you correct it.
CSAT calculator FAQ
What is a good CSAT score?
This calculator does not give a target. SurveyMonkey says that ecommerce and retail typically aim for 80% to 90%, and that 70% to 80% is often the norm for technology and software companies. It also says to evaluate a score as more than an isolated data point. Youform says to compare with the same touchpoint, audience, scale and collection method.
Which ratings count as satisfied on a 7-point scale?
There is no single rule. SurveyMonkey says that positive typically means 6 and 7, and that some teams include 5. Youform's calculator counts 5, 6 and 7, because these ratings are above the neutral midpoint. This calculator gives you both options, and the result names the rule that it used.
Can I compare a 5-point score with a 7-point score?
Do not compare them as if they were the same. The scale and the rule for satisfied are different, and the rule changes the result. In the 7-point example on this page, the same 5 scores give 60% with one rule and 40% with the other rule.
Why show the average as well as CSAT?
Two sets of scores can have the same CSAT and a different average. On a 5-point scale, the scores 4, 4, 4, 4, 1 and the scores 5, 5, 5, 5, 1 both give a CSAT of 80%. Their averages are 3.4 and 4.2.
What happens if a score is outside the scale?
You get an error that gives the position of the score, and no result. A pasted score has a position in the list, and a CSV score has a row number. This also applies to a score with a decimal part, such as 4.5, because each rating must be a whole number.
How does the calculator read commas in pasted scores?
A comma always separates two scores. So 4,5 is the score 4 and the score 5, not a decimal number. The steps give the total, so you can check how many scores the calculator read. In the counts fields, a comma or a point can separate thousands, but a decimal mark is not accepted there.
Which CSV files can I use?
Use a text file with values separated by commas, semicolons or tabs. If you use a spreadsheet, export the sheet as CSV first. Quoted values and a heading in row 1 are accepted. If the file has more than one column, you choose the score column. Empty cells do not count as scores, and the result gives the number of empty cells that it skipped.
Is my data sent to a server?
No. The calculation runs in your browser, and this page does not send or save your scores or files. The site uses Plausible analytics to count page visits. Plausible does not receive what you enter.
Do I need an account?
No. The calculator is free and needs no signup.
Related pages
Sources: