Free template

Supplier evaluation template (Excel), free download

Free supplier evaluation template in Excel: 15 weighted criteria, non-conformance deductions and automatic A/B/C grade with live formulas. No macros.

Written by , Head of Quality (AS/EN 9100)

Updated:

Ready immediatelyDownload at no cost
Editable filesAdapt it to your own process
Guidance includedGet practical notes on using it
XLSExcel workbook · XLSXFree download

Supplier evaluation workbook

15 weighted criteria, non-conformance deductions, and an automatic A/B/C grade. Live formulas, no macros.

No signup required

This supplier evaluation template is a ready-to-use Excel workbook for evaluating suppliers according to ISO 9001 clause 8.4 and AS/EN 9100. Enter scores and the supplier’s non-conformances; the formulas calculate the weighted total, deduct points for non-conformances and assign an A/B/C grade. No macros, no signup.

What is in the template

The workbook has three sheets:

Sheet Content
Evaluation Supplier, date, evaluator; 15 criteria in four groups with weights, scores, deductions and final points; total score and grade
Non-conformances List of up to 100 non-conformances: date, description, severity, affected area, closed on time, 8D complete
How to use Short instructions

Input cells are yellow; formula cells are protected (without a password, so you can adapt the template). Severity, area and yes/no fields use drop-down lists, and scores are limited to 0–100.

How to fill it in

  1. Evaluation sheet: enter supplier, date and evaluator, then score each criterion from 0 to 100. The column next to each criterion explains the scale.
  2. Non-conformances sheet: list every non-conformance of the evaluation period. Choose severity (critical, major, minor) and the area it affected; “General” affects all areas.
  3. The total score and grade update automatically: A ≥ 90, B 71–89, C ≤ 70.
  4. Save one file per supplier and year, or copy the Evaluation sheet for each supplier.

How the formulas work

  • Weighted total: each final score is multiplied by its weight; the sum is the total score.
  • Deductions: each non-conformance reduces the score of the area it affected by 15 (critical), 8 (major) or 3 (minor) points, at most 30 points per area, spread over that area’s criteria by weight.
  • Calculated criteria: number and severity of non-conformances, the share closed on time and the share with a complete 8D report are computed from the Non-conformances sheet.

This is the same scoring model used in the online calculator and in Suppliscore, so results are identical wherever you calculate them.

Adapting the template

The weights in column D can be changed; keep the sum at 100 %. You can rename criteria to fit your products, for example “first article inspection” instead of “sample quality”. If you change the structure (add or remove rows), unprotect the sheet first and check the sum formulas.

When a spreadsheet is no longer enough

A template works well for a yearly evaluation of a few dozen suppliers. It gets difficult when non-conformances come from a separate complaint log, several people evaluate, or you need the history of a supplier at audit time. That is the point where supplier evaluation software saves time: it counts non-conformances in the score without copying them by hand, and keeps every supplier’s grade current between evaluations.

FAQ

Does the template meet ISO 9001 requirements?

ISO 9001 requires defined criteria for evaluating and re-evaluating suppliers and records of the results and resulting actions. The template gives you the criteria and the record; you still need to document the actions you take on the results, for example in your approved supplier list.

Does it work in Google Sheets or LibreOffice?

Yes. The template uses standard formulas (SUM, COUNTIFS, ROUND, IF) without macros.

Can I use it for service providers?

Yes. Score the criteria that apply and set the weights of criteria that do not apply (for example material certificates for a calibration lab) to 0, then redistribute the weight.