Practical Template Library · Evaluation · Free Excel (.xlsx)

Training satisfaction tally in Excel — with a filled-in example

An Excel workbook where entering each satisfaction survey as a single row automatically produces averages by area and by question, a Net Promoter Score (NPS), and charts. It also builds a separate table you can drop into your results report.

  • FormatExcel (.xlsx) — just swap in your company logo and approval boxes
  • What’s includedA blank template + a fully filled-in example for a fictional company
  • How to get itLeave your company name, name and email for instant download + a copy by email
  • CostFree
Training satisfaction auto-tally sheet preview — Response entry — yellow rows are the filled-in exampleEnlarge ⤢

Response entry — yellow rows are the filled-in example

Fields in this template

  • Response entry (100 people) — 12 questions on a 5-point scale + likelihood to recommend (0–10) + open-ended comments
  • Averages by area and by question, with questions below 4.0 flagged automatically
  • Automatic NPS calculation and per-question charts
  • A table to paste into “3. Satisfaction Results” of the results report (with change from the previous session)
  • Filled-in example — with 12 responses entered

Tips for completing it

  1. Question numbers match the “Training Satisfaction Survey” template. Just copy the completed survey in as is.
  2. Questions with an average below 4.0 are highlighted in red. Look here for what to change in the next session.
  3. NPS is the share of 9–10 scores minus the share of 0–6 scores. A score of +30 or higher suggests a training people would recommend to colleagues.
  4. Group open-ended responses by similar wording and note the count. This column, more than the numbers, is what shapes the next program.

Filled-in example — table view

A partial excerpt from an example filled in for a fictional company, Hanbit Precision Co., Ltd. (auto parts manufacturing · 280 employees). The file contains the blank template first, followed by this full example. Amounts and figures in the example are illustrative assumptions.

② Tally (filled-in example)

AreaAverage (out of 5)
Training content4.42
Instructor4.72
Operations4.25
On-the-job application4.39
Overall average4.45
Likelihood to recommend (NPS)+58

12 sample responses entered. Per-question averages, charts, and the table for the results report are in the file.

Get the Training Satisfaction Auto-Tally Sheet

Download other templates too

You can download the Training Satisfaction Auto-Tally Sheet right away. We also email you a copy of the same file in a single ZIP. Company name, name, and email are all required; we do not collect phone numbers.

Selected templates: 1

Stuck while using a template? → Instructor & curriculum 1:1 inquiry · See training costs first (quote calculator)

Frequently asked questions

How is NPS calculated?

On the 0–10 likelihood-to-recommend scale, scores of 9–10 count as promoters and 0–6 as detractors; NPS is the percentage of promoters minus the percentage of detractors. The tally sheet calculates it automatically from the responses.

How many respondents can it handle?

Up to 100 respondents at a time. Copy the file for each training session, and you can compare sessions using the same calculations.

Are the templates free?

Yes, they are free. Just leave your company name, name, and email to download the template you choose right away. We also email you the same file.

Can I adapt a template to our company format?

Yes, you can swap in your company logo and approval box and use it as an in-house template. We only ask that you do not sell it elsewhere or redistribute it as is.

More practical templates

We offer every template for running a training program, from planning through reporting, completely free. Browse the full practical template library →

Document Library — Practical Documents for Training Managers and Corporate InstructorsDocuments such as an AI training adoption plan, a statutory mandatory training calendar, a training budget table, and a sample instructor proposal are also available the same way, with filled-in examples.View Documents ›

Stuck filling out a template?

If you need an instructor or curriculum while preparing training with this template, let us know. We will send you the instructor name, curriculum, and cost breakdown within 24 hours.

※ The statutory mandatory training cycles and tax rates shown are general guidelines for convenience in filling out the template. They may vary by your company’s industry and size, so please also check the underlying laws and your company’s tax policy.

Get This Template Free