# APQP Checklist in Excel with Owners and Evidence

> Source: https://netray.co/tools/apqp-checklist-excel-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable APQP checklist by phase with owner, evidence and status columns. Track deliverables across the five phases and export to Excel.

## Category

quality

## Industry

Automotive

## Audience

- Quality engineer
- Program manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Phase

**Key:** phase

**Type:** select

**Options:**

- 1 Plan and define
- 2 Product design
- 3 Process design
- 4 Validation
- 5 Feedback and action

#### Deliverable

**Key:** item

**Type:** text

#### Owner

**Key:** owner

**Type:** text

#### Evidence

**Key:** evidence

**Type:** text

#### Status

**Key:** status

**Type:** select

**Options:**

- Not started
- In progress
- Complete
- Blocked
- Not applicable

#### Due date

**Key:** due

**Type:** date

**Rows:**

#### 1 Plan and define

**Item:** Voice of the customer inputs captured

**Owner:** Program manager

**Evidence:** Customer RFQ and specs

**Status:** Complete

**Due:** 2026-11-06

#### 1 Plan and define

**Item:** Design goals and reliability and quality goals set

**Owner:** Engineering

**Evidence:** Goals sheet

**Status:** Complete

**Due:** 2026-11-13

#### 1 Plan and define

**Item:** Preliminary bill of materials

**Owner:** Engineering

**Evidence:** BOM rev A

**Status:** Complete

**Due:** 2026-11-13

#### 1 Plan and define

**Item:** Preliminary process flow and special characteristics list

**Owner:** Quality

**Evidence:** Draft flow, SC list

**Status:** In progress

**Due:** 2026-11-20

#### 1 Plan and define

**Item:** Product assurance plan and management support

**Owner:** Program manager

**Evidence:** Signed plan

**Status:** In progress

**Due:** 2026-11-27

#### 2 Product design

**Item:** Design FMEA completed

**Owner:** Engineering

**Evidence:** DFMEA rev 1

**Status:** In progress

**Due:** 2026-12-11

#### 2 Product design

**Item:** Design verification and prototype control plan

**Owner:** Quality

**Evidence:** Test plan, prototype control plan

**Status:** Not started

**Due:** 2026-12-18

#### 2 Product design

**Item:** Drawings and specifications released

**Owner:** Engineering

**Evidence:** Drawing SB-48213 Rev C

**Status:** Not started

**Due:** 2027-01-08

#### 2 Product design

**Item:** Gauge, equipment and tooling requirements defined

**Owner:** Manufacturing

**Evidence:** Equipment list

**Status:** Not started

**Due:** 2027-01-08

#### 2 Product design

**Item:** Team feasibility commitment signed

**Owner:** Program manager

**Evidence:** Signed commitment

**Status:** Not started

**Due:** 2027-01-15

#### 3 Process design

**Item:** Process flow diagram and floor plan

**Owner:** Manufacturing

**Evidence:** Flow chart, layout

**Status:** Not started

**Due:** 2027-01-29

#### 3 Process design

**Item:** Process FMEA completed

**Owner:** Quality

**Evidence:** PFMEA rev 1

**Status:** Not started

**Due:** 2027-02-05

#### 3 Process design

**Item:** Pre-launch control plan

**Owner:** Quality

**Evidence:** Control plan

**Status:** Not started

**Due:** 2027-02-12

#### 3 Process design

**Item:** Measurement system analysis plan

**Owner:** Quality

**Evidence:** MSA plan

**Status:** Not started

**Due:** 2027-02-12

#### 4 Validation

**Item:** Production trial run and capability study

**Owner:** Manufacturing

**Evidence:** Run report, Ppk study

**Status:** Not started

**Due:** 2027-03-05

#### 4 Validation

**Item:** PPAP submitted and approved

**Owner:** Quality

**Evidence:** PSW

**Status:** Not started

**Due:** 2027-03-15

#### 5 Feedback and action

**Item:** Lessons learned and variation review

**Owner:** Program manager

**Evidence:** Review minutes

**Status:** Not started

**Due:** 2027-07-01

**Totals:**

#### Deliverables

**Key:** item

**Agg:** count

**Format:** integer

**Notes:** Deliverables follow the structure of the five APQP phases. Add rows for customer-specific items and change the owner names. Sort or filter by phase and status in Excel before each gate review.

## Content

**Intro:** An APQP checklist is only useful if each line has an owner, evidence and a date. This worksheet lists the typical deliverables for all five phases and lets you edit, add and export them as an Excel tracker.

**Sections:**

#### How to use the checklist

**Body:** Edit the example rows to match your program, add customer-specific deliverables and assign a real person to each line. Write the evidence as a document name or reference, so that at the gate review you can check it exists rather than ask someone. Export to Excel and filter by phase before every gate. A line only moves to Complete when the evidence has been reviewed, not when the work has started.

#### Phase by phase

**Body:** Phase 1 collects customer needs and sets goals. Phase 2 covers the design, with the DFMEA and drawings. Phase 3 develops the process: flow, PFMEA, control plan and measurement plan. Phase 4 validates through a trial run, capability study and PPAP. Phase 5 uses production feedback to reduce variation and capture lessons. Each phase also needs management support, which is why sign-off lines appear in the list.

**Bullets:**

- Link PFMEA and control plan: every high risk step has a control
- Plan MSA before the capability study, not after
- Confirm tooling and gauge lead times in phase 2
- Keep customer-specific requirements as their own rows

#### Common mistakes

**Body:** A checklist that is filled in at the end is a record of paperwork, not a planning tool. Avoid marking items complete without evidence, skipping the feasibility commitment, or leaving owners as departments rather than named people. Also avoid copying last program's checklist without reviewing risk: a new material or process changes what the PFMEA and control plan need to cover.

**Cta:** Netray can connect this kind of tracker to your ERP so milestone status and open actions can be asked in plain language, on your own servers.

**Faq:**

#### What should an APQP checklist include?

**Answer:** It should list the deliverables of each of the five phases, such as design goals, DFMEA, drawings, process flow, PFMEA, control plan, MSA, capability study and PPAP, each with an owner, evidence and due date.

#### Is this the AIAG APQP checklist?

**Answer:** No. It is an independent checklist based on the phase structure of APQP. The AIAG manual is copyrighted and contains its own forms. Use this as a working tracker and refer to the manual for the full detail.

#### How often should I review it?

**Answer:** Weekly in the program team meeting and formally at each gate. Any item that is late or blocked should have an escalation owner so it does not surprise you at PPAP time.

#### Can I use it for aerospace programs?

**Answer:** Yes as a starting point. Aerospace suppliers often follow AS9145 for APQP and PPAP, which uses similar phases with aerospace-specific requirements. Adapt the deliverables to your customer's flow-downs.

## Search terms

apqp checklist example, apqp checklist xls, aiag apqp checklist, apqp requirements checklist, apqp checklist examples, apqp checklist for quality control, apqp format in excel, apqp excel tracker

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json