# APQP Template (Excel): Plan, Checklist and Filled Example > Source: https://netray.co/tools/apqp-template-excel-plan-and-checklist > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable APQP plan and checklist with a filled example plan. Track deliverables by phase, owner, due date and percent complete, then export to Excel. ## Category quality ## Industry Automotive ## Audience - Program engineer - Quality engineer - Advanced quality planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### APQP phase **Key:** phase **Type:** select **Options:** - 1 Plan and define - 2 Product design and development - 3 Process design and development - 4 Product and process validation - 5 Feedback, assessment, corrective action #### Deliverable **Key:** deliverable **Type:** text #### Owner **Key:** owner **Type:** text #### Due date **Key:** due **Type:** date #### Status **Key:** status **Type:** select **Options:** - Not started - In progress - Complete - Blocked #### Percent complete **Key:** pct **Type:** number **Format:** percent **Unit:** % **Rows:** #### 1 Plan and define **Deliverable:** Design goals and customer requirements **Owner:** Program manager **Due:** 2026-11-02 **Status:** Complete **Pct:** 100 #### 1 Plan and define **Deliverable:** Preliminary bill of materials and process flow **Owner:** Manufacturing engineer **Due:** 2026-11-09 **Status:** Complete **Pct:** 100 #### 2 Product design and development **Deliverable:** Design FMEA **Owner:** Design engineer **Due:** 2026-11-30 **Status:** In progress **Pct:** 60 #### 2 Product design and development **Deliverable:** Special characteristics list (draft) **Owner:** Quality engineer **Due:** 2026-12-04 **Status:** In progress **Pct:** 40 #### 3 Process design and development **Deliverable:** Process FMEA **Owner:** Quality engineer **Due:** 2027-01-15 **Status:** Not started **Pct:** 0 #### 3 Process design and development **Deliverable:** Pre-launch control plan **Owner:** Quality engineer **Due:** 2027-01-29 **Status:** Not started **Pct:** 0 #### 4 Product and process validation **Deliverable:** Measurement system analysis (MSA) **Owner:** Metrology lead **Due:** 2027-02-19 **Status:** Not started **Pct:** 0 #### 4 Product and process validation **Deliverable:** Production trial run and PPAP submission **Owner:** Program manager **Due:** 2027-03-12 **Status:** Not started **Pct:** 0 **Totals:** #### Average percent complete **Key:** pct **Agg:** avg **Format:** percent #### Deliverables tracked **Key:** deliverable **Agg:** count **Format:** integer **Notes:** The rows are an example plan for a new automotive component. Replace them with your own deliverables, add rows for customer-specific requirements, and use the status column as your checklist. Dates are placeholders. ## Content **Intro:** This APQP template is a working plan and checklist in one table. It lists the standard APQP deliverables by phase, with owner, due date, status and percent complete, so you can replace the example rows and export a plan in Excel or PDF. **Sections:** #### How to use this APQP plan and checklist **Body:** Start by deleting the example rows that do not apply and adding the deliverables your customer requires. Assign one named owner per line, not a department. Set due dates backward from the PPAP submission or start of production date, then update status and percent complete at every APQP team meeting. Export to Excel to circulate the plan or attach it to a customer review. The average percent complete at the bottom gives a quick health reading, but it treats every line equally, so also look at blocked items and the next gate date. **Bullets:** - One owner per deliverable - Work backward from the launch date - Review at every phase gate - Use Blocked for items waiting on the customer or a supplier #### The five APQP phases and typical documents **Body:** Advanced Product Quality Planning is structured in five phases: plan and define, product design and development, process design and development, product and process validation, and feedback, assessment and corrective action. Typical APQP documents include the design FMEA, process flow diagram, process FMEA, special characteristics list, control plan, measurement system analysis, initial process capability study, packaging specification and the PPAP package. Customers may add their own forms, so confirm requirements in your customer-specific requirements list before you freeze the plan. #### A filled APQP plan example and how to read it **Body:** The example shows a program in phase 2: goals and the preliminary process flow are done, the design FMEA is 60 percent complete and the special characteristics list is in draft. Phase 3 items are not started, which is normal because process FMEA and the control plan depend on a stable design FMEA and characteristics list. If a phase 3 line shows progress while its phase 2 inputs are open, treat that as a risk and note it. Percent complete should reflect reviewed output, not hours spent. #### Common mistakes **Body:** Teams often list documents instead of outcomes, so a control plan shows complete while the PFMEA it should reflect is still being rewritten. Others keep one plan owner for everything, which hides who is actually late. Customer-specific requirements are frequently found late, so read them in phase 1. Finally, an APQP plan that is not reviewed at gates becomes a file nobody opens. Tie each phase to a dated review with management attendance. **Cta:** If your APQP deliverables live across ERP, PLM and spreadsheets, Netray can add a private AI layer that pulls status from those systems on your own infrastructure. The template here works fully without us. **Faq:** #### Is this APQP template free? **Answer:** Yes. You can edit the rows in the browser and export to Excel, PDF or CSV without an account. The example plan is generic and meant to be replaced with your program deliverables and customer requirements. #### What documents are in an APQP package? **Answer:** Commonly the design FMEA, process flow, process FMEA, special characteristics list, control plan, MSA, capability studies, packaging spec and PPAP submission. Exact content depends on the customer and the product risk level. #### How is APQP different from PPAP? **Answer:** APQP is the planning framework used throughout development. PPAP is the evidence package submitted to the customer to show the process can produce conforming parts at rate. PPAP is one output of APQP phase 4. #### Can I use this for non-automotive programs? **Answer:** Yes. Aerospace suppliers use similar planning under AS9145, and any complex new product introduction benefits from phase gates. Rename the phases or deliverables to match your own process. ## Search terms apqp template excel, apqp checklist template, apqp checklist excel, apqp plan example, apqp example, apqp format, apqp documents, apqp documents examples --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json