The CSAT calculation, step by step
Count the responses that scored 4 or 5 on your 5-point satisfaction question. Those are your satisfied responses.
Divide that number by the total number of responses received — not the number of surveys sent.
Multiply by 100. That figure is your CSAT percentage: CSAT % = (satisfied ÷ total) × 100.
Worked example: 180 responses of 4 or 5 out of 240 total responses gives 180 ÷ 240 = 0.75, so CSAT is 75%.
How to calculate a CSAT score out of 5
Some teams report CSAT as an average out of 5 rather than a percentage. Add every score together and divide by the number of responses — that gives a mean like 4.2 out of 5.
The two are not interchangeable. An average of 4.2 out of 5 can sit alongside a top-2-box percentage of anywhere between roughly 70% and 90%, depending on how the answers are spread.
Pick one and stay with it. Public benchmarks from ACSI and Zendesk use the top-2-box percentage, so that is the version you can compare against other companies.
CSAT percentage vs customer satisfaction index
A CSAT percentage covers one question about one interaction. A customer satisfaction index combines several weighted questions into a single composite score.
An index is useful for board reporting, but it hides which specific moment moved. Keep the per-interaction CSAT as your working number and treat the index as a summary.
Net satisfaction is a third variant: satisfied percentage minus dissatisfied percentage, which behaves more like NPS and can be negative.
The CSAT formula in Excel or Google Sheets
With scores in column A, count the satisfied responses with =COUNTIF(A:A,">=4").
Get the total with =COUNT(A:A), then combine them: =COUNTIF(A:A,">=4")/COUNT(A:A) and format the cell as a percentage.
For the average-out-of-5 version use =AVERAGE(A:A) instead.
If you collect responses with a LemForms survey, the score is calculated for you as answers arrive — no export, no formula.
Frequently asked questions
What's a good CSAT score?
It depends on your industry. SaaS and B2B services average around 80–82%, with the top quartile at 90–92%. Retail averages ~78%, healthcare ~74%, and government ~66%. Use the industry selector above for your specific benchmark.
What's the CSAT formula?
CSAT % = (satisfied responses ÷ total responses) × 100. Satisfied = 4 or 5 on a 5-point scale.
How is CSAT different from NPS?
CSAT measures satisfaction with a specific interaction. NPS measures overall loyalty and willingness to recommend.
What CSAT scale should I use?
The 5-point scale (Very Dissatisfied → Very Satisfied) is the industry standard because it maps cleanly onto the ‘top-2-box’ CSAT formula. 7- and 10-point scales work too, but you need to redefine ‘satisfied’ (top-2 or top-3 boxes) — otherwise scores across surveys aren't comparable.
How often should I measure CSAT?
After every meaningful interaction — support ticket, onboarding, checkout — so you can attribute score changes to specific moments. Aggregate quarterly for board reporting. Continuous measurement beats one big annual survey every time.
How many responses do I need for CSAT to be trustworthy?
For a 5-point margin of error at 95% confidence you need roughly 380 responses per segment. Below ~100 responses, treat CSAT as directional only — one very unhappy customer can swing the score several points.
Why is my CSAT dropping even though customers seem happy?
Three usual suspects: (1) sample bias — only frustrated users are responding, (2) a recent product change quietly regressed a workflow, (3) survey fatigue is compressing responses toward neutral. Segment CSAT by channel and cohort before you diagnose.
Is CSAT better than NPS or CES?
They measure different things. CSAT = did this specific interaction meet expectations. CES (Customer Effort Score) = how hard was it to get the thing done. NPS = overall willingness to recommend. Mature CX programs run all three and compare trends, not single scores.
What's a top-2-box CSAT score?
‘Top-2-box’ means you count the top two positive answers (‘Satisfied’ + ‘Very Satisfied’ on a 5-point scale) as satisfied. It's the calculation used in this tool and in ACSI's public benchmarks — so scores are directly comparable.
Should CSAT include neutral responses?
No. The standard top-2-box formula treats ‘Neither satisfied nor dissatisfied’ as not satisfied. Including neutrals inflates your score and breaks comparability with industry benchmarks.
How do I improve CSAT quickly?
The fastest wins usually aren't product changes — they're closing the loop. Follow up personally with every detractor within 48 hours, fix the top-3 recurring complaints, and re-survey. Companies that close the loop see 15–20 point CSAT lifts within a quarter.
Can I calculate CSAT from a Google Form or Typeform export?
Yes — export to CSV, count responses of 4 and 5, divide by total, multiply by 100. Or connect your survey to LemForms and the CSAT score appears automatically in your Insights dashboard, updated in real time as responses come in.
Build the form behind the tool
LemForms is the form builder this tool plugs into — calculations, conditional logic, embeds, webhooks, and a real submissions dashboard. Free to start.
Try LemForms freeMore free tools
- Form Embed Code GeneratorPaste any form URL and get copy-paste embed code for WordPress, Webflow, Framer, Wix, Squarespace, Shopify, Notion and more.
- NPS Score CalculatorCalculate your Net Promoter Score in seconds. Enter promoters, passives, and detractors — get NPS, percentage breakdown, and industry context.
- Survey Sample Size CalculatorCalculate the minimum survey sample size for any population, confidence level, and margin of error. Free, no signup required.
- Survey Response Rate CalculatorFree survey response rate calculator with the formula, a worked example, and channel benchmarks. Enter invitations and completed responses—no signup.