Automotive supplier self-assessment aligned with IATF 16949
A structured self-assessment for new and existing automotive suppliers, covering the quality system, APQP and PPAP, production control, sub-tier suppliers, problem solving, ESG and TISAX.
- Free Excel file, no sign-up
- 38 questions, 8 sections
- Critical questions flag gaps
- Scores and rating calculated
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 4 | No. | Question | Answer | Criticality | Points |
| 5 | 1.1 | Valid IATF 16949 certificate for the supplying site? | Yes | Critical | 2 |
| 6 | 2.2 | Can you submit PPAP at the level we request? | Partly | Critical | 1 |
| 7 | 3.3 | Lot traceability back to raw material? | Yes | Critical | 2 |
| 8 | 8.1 | TISAX label at the required level? | N.A. | Standard |
What is inside
3 sheets, ready to use.
Yellow cells are yours to fill in. Grey cells calculate. Every sheet has a worked example so you can see the expected format.
Read me
Purpose, scoring rules, colour legend and assumptions.
Questionnaire
8 sections with Critical and Standard questions, answer dropdowns and an evidence column.
Summary
Score per section, overall score, critical gaps and a rating with editable thresholds.
How to use it
Four steps from download to a decision.
No macros, no add-ins. It works in Excel, Google Sheets and LibreOffice.
01
Send the Questionnaire sheet to the supplier. They answer each question Yes, Partly, No or N.A. and add evidence.
02
Yes scores 2, Partly 1 and No 0. N.A. is left out, so suppliers are not penalised for questions that do not apply.
03
The Summary sheet shows a score per section and overall. The rating stays In progress until every question is answered.
04
Any No on a Critical question makes the rating conditional. Follow those up first, whatever the total.
Spreadsheet or platform
Start in Excel. Move when the volume or the stakes grow.
The template and the platform use the same structure, so nothing you set up here is wasted.
This spreadsheet is enough when
- You assess a handful of new suppliers a year
- One person sends, collects and scores the answers
- You do not need to compare suppliers or track change over time
Move it into EvaluationsHub when you need to
- Send the same questionnaire to dozens of suppliers and chase answers automatically
- Score answers as they arrive and flag critical gaps for follow-up
- Keep evidence, certificates and expiry dates on one supplier record
- Compare suppliers and re-run the assessment every year without rebuilding it
Questions
Before you download
Does a self-assessment replace an IATF 16949 audit?
No. It is a screening step that shows where to focus the audit. Certification status, customer-specific requirements and PPAP readiness still need evidence.
Is the template really free?
Yes. The file downloads directly, with no form and no email address.
When should we move this out of Excel?
When several people rate the same suppliers, when suppliers need to see their results, or when actions get lost between file versions. That is usually the point where a shared platform pays back. Signs you have outgrown the spreadsheet →
Related templates
Next steps in the supplier lifecycle.
Templates that pick up where this one ends.
Supplier onboarding checklist
21 onboarding tasks in five phases with owners, due dates and progress.
View template →
Supplier corrective action tracker (8D)
8D cases with targets by severity, containment check and supplier summary.
View template →
Weighted supplier scorecard with segment presets
Six dimensions, weights by segment, tiers and next actions.
View template →
Run it live
Run this process with your suppliers, not just in a file.
Start a free sandbox and set it up yourself: send requests and surveys to real suppliers, collect answers and see scores in one place.
