Looking for Excel solution to track audit findings and recurring defects

Hi everyone,

I’m working in quality management and regularly perform product audits based on checklists. The process is quite standard: each point is evaluated as pass / fail. Whenever something fails, I have to fill out a separate one-page Excel sheet (a kind of defect report), where I describe the issue, classify it, and assign a quality rating/score.

The challenge is that I conduct many audits, and over time I would like to analyze the data more efficiently.

What I’m looking for is an Excel-based solution (or template) that allows me to:

• Enter audit results and defect reports in a structured way • Automatically store and track all detected issues • Identify recurring defects (e.g. same issue appearing multiple times) • Count how often specific errors occur • Filter or analyze defects across multiple audits (e.g. by category, severity, date, etc.) 

Ideally, I’d like something where I can either:

• Integrate my existing defect report form, or • Enter the data once and have it stored in a central database-like structure in Excel 

Do I need to upload/store the individual forms somewhere, or is there a smarter way to structure this directly in Excel (e.g. with tables, Power Query, or a dashboard)?

Has anyone implemented something similar or can recommend a good approach/template?

Thanks in advance!