Garment Defect Inspection Sheet (AQL-ready)
Fast, clean defect logging for apparel QA. Includes dropdown defect types, severity (Critical/Major/Minor), action taken, auto counts, and a mini dashboard with KPIs and charts. Built for AQL workflows.
Excel (.xlsx) Google Sheets ready AQL-friendly KPIs + charts
Download the template
Enter your details and we’ll email you the Excel file and a Google Sheets copy link.
What’s inside
- Header: buyer, supplier, factory, style/PO, date, inspector, stage, sample & lot size, AQL note
- Defect log table: Sample ID · Carton/Unit · Defect Type · Description · Severity · Action · Count
- Dropdown lists for defect types, severity, and actions (rework/reject/accept/replace/sort & rework)
- Mini Dashboard: KPIs (Total/Critical/Major/Minor) + bar & pie charts with filters
- Step-by-step panel to guide data entry
How to use
- Fill header cells (buyer/supplier/factory/style/PO/date/inspector/stage).
- Enter sample size, lot size, and AQL info; pick sampling method if used.
- Log defects row by row (choose Defect Type, set Severity, select Action).
- Use dashboard filters (Severity / Defect Type / Action) to analyze patterns.
- Export or print for report handover.
Who it’s for
- Brand QA/QC teams & third-party inspectors
- Factory quality & IE teams
- Ops leads needing quick inspection summaries
Template specs
- Severity: Critical · Major · Minor
- Actions: Rework · Reject · Accept · Replace · Sort & Rework
- Outputs: totals by type/severity/action, KPIs and charts, filtered views
- Editable: defect types list, actions, thresholds/notes
- Formats: .xlsx + GSheets
FAQs
Is this AQL compliant?
It’s designed to log defects and summarize results for AQL checks. Enter your chosen AQL level and sampling method; counts/ratios are calculated automatically.
Can I customize defect types?
Yes. Edit the lists sheet to add or rename defect categories and actions.
Does the dashboard work in Google Sheets?
Yes. The KPIs and formulas work in Sheets (charts may render slightly differently vs Excel).
