Free · Excel + Google Sheets · No macros

Free ISO 9001:2015 Audit Checklist Template (Excel/XLS)

This free checklist is prefilled with the 7 main ISO 9001:2015 clauses (4 through 10). Mark each requirement Conforming, Non-conforming or Observation, and overall conformity plus conformity per clause calculate automatically. A separate Nonconformance Register tracks findings with an overdue flag. Works in Excel and Google Sheets.

Download free template

Free where the alternatives are paid or gated

This exact search still surfaces a decade-old forum thread asking for a free clause-based ISO 9001 checklist - the real alternatives are a paid Etsy listing, a "demo" version gated on iso9001help.co.uk, and PDF previews of paid spreadsheets on Scribd.

This template gives you the same clause-by-clause structure those paid versions use - free and fully unlocked, in an Excel and Google Sheets workbook you can start using immediately.

It also works as a base for an AS9100 aerospace quality audit: AS9100 is built on top of ISO 9001's core clauses with aerospace-specific additions, so this checklist covers the ISO 9001 foundation either audit needs.

How conformity percent and the nonconformance register work

Overall conformity is conforming items divided by conforming plus non-conforming items (Observations are tracked separately and don't count either way). Conformity per clause runs the same calculation, but only for rows tagged with that exact clause.

The Nonconformance Register is a separate, linked tab: log each finding with its clause, root cause, corrective action, responsible person and due date. An open NC past its due date is flagged OVERDUE automatically - a closed one never is, no matter how old its due date.

Keep the seven prefilled clause labels exactly as they appear when you add more questions underneath each - the per-clause conformity formulas match on that exact text.

Who this template is for

Quality managers and small manufacturers preparing for an internal audit or a certification-body visit, who need a working clause-by-clause checklist without buying one or filling out a lead form for a "demo."

This is a self-assessment tool for internal audit prep - it is not a certification document. Your certification body's auditor makes the official conformance determination, not this spreadsheet.

How to use it

  1. Add your audit questions under the 7 prefilled ISO 9001:2015 clauses.
  2. Mark each Conforming, Non-conforming or Observation - conformity % updates per clause automatically.
  3. Log findings on the Nonconformance Register - open items past their due date flag OVERDUE.
Need more? — $49

Quality & Audit Pack

This free checklist covers one audit with a manual clause list and a linked nonconformance register - it doesn't score conformity by clause across a bank of pre-filled questions, and it stops at logging an NC, not closing it. The paid Quality & Audit Pack ($49) adds a 120-row Internal Audit Checklist across clauses 4-10 with 46 pre-filled questions and a per-clause conformity score, plus a 100-row NC/CAPA Register that tracks severity and computes aging in days and overdue flags automatically. Both build in Excel and Google Sheets, every formula tested to the cent.

See the full version

Frequently asked questions

Does this work for an AS9100 aerospace audit too?

Yes, as a base. AS9100 builds on ISO 9001's core clauses plus aerospace-specific requirements, so use this checklist for the ISO 9001 foundation and add aerospace-specific rows under each clause.

Can I use this in Google Sheets?

Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The clause structure and conformity formulas keep working.

Is this a certification document my certification body will accept?

No. This is a self-assessment tool for internal audit prep, not a certification document - your certification body's auditor makes the official conformance determination.

How is conformity percent per clause calculated?

Conforming rows tagged with that exact clause, divided by conforming plus non-conforming rows tagged with that clause. Observations are tracked but excluded from the percentage.

Does closing a nonconformance clear the overdue flag?

Yes. The Overdue flag on the Nonconformance Register only applies to items still marked Open - mark one Closed and it stops flagging, regardless of its due date.

What's the usage license?

Personal use or use within one business. It's not meant to be resold or redistributed as a template product.

Related free templates