KPI calculator

CSAT Calculator

Enter your values to calculate CSAT. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

CSAT books Books that help you understand CSAT and related business metrics more deeply. Explore resources → CSAT audiobooks Audiobook searches for learning CSAT while commuting, walking, or working. Explore resources → Customer success resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Customer experience analytics Practical resources for turning CSAT into reports, dashboards, and business decisions. Explore resources →

Calculate CSAT

Positive Responses Total Responses

Result—

Formula

Positive Responses / Total Responses

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

CSAT =
DIVIDE(
    [Positive Responses],
    [Total Responses]
)

Read the complete CSAT formula guide →