Survey response rate formula in Excel or Google Sheets
Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.
| Cell | What | Value or formula | Example |
|---|---|---|---|
| B2 | Surveys sent | 2000 | 2000 |
| B3 | Bounced or undelivered | 80 | 80 |
| B4 | Completed responses | 384 | 384 |
| B6 | Delivered | =B2-B3 | 1920 |
| B7 | Response rate (%) | =ROUND(B4/B6*100,1) | 20 |
Get the ready-made spreadsheet
The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).
Go further with the ebook
The Professional Customer Support Playbook
Better replies, fewer escalations, a clear path from agent to leader.
$19.99 · 103 pages · View the book
Frequently asked questions
- How do you calculate survey response rate?
- Subtract bounced emails from surveys sent, then divide completed responses by that number. 384 completed out of 1,920 delivered is a 20% response rate.
- What is a good survey response rate?
- For email surveys to customers, 10–30% is common. Short in-app or post-ticket surveys often reach 30–50%. A rate that falls over time usually means surveys are too long or too frequent.
- How many responses do I need?
- Enough for the margin of error you accept. For a 5% margin at 95% confidence you need about 385 responses from a large customer base; the survey sample size calculator does the maths.
About the author
Abdessamad Ghanem
Customer Experience & Customer Success Consultant · Founder of Clarivoxx
Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.