Load customer perception evidence, convert it into structured records, and prepare it for review before inclusion in reporting.
Source Type
Select the type of input this feedback came from. Source type is retained on every record and feeds the Source_Files sheet in your exported workbook — auditors use it to verify that your perception monitoring covers multiple input channels, not just one. Choose the closest match; you can always add a note in the feedback text.
Feedback Date
Enter the date the feedback was received or observed — not today's date unless you are logging something that happened today. This date drives trend analysis in the Analysis tab and is the primary time axis in your management review output. Missing or incorrect dates will compress your trend chart and make it harder to spot patterns across time.
Feedback Text
This is the objective evidence field. Paste the original text — email body, survey comment, visit note, or verbal summary — as close to verbatim as possible. The tool uses this text to infer sentiment, theme, and severity. A thin or paraphrased entry will produce weaker classification. The extracted text is retained on every approved record and becomes auditable evidence that the input was reviewed.
Owner
The person responsible for reviewing this record and following up if action is required. Ownership is carried into the Actions tab for any record that is negative or mixed. Auditors will ask who reviewed customer perception inputs and what was done — this field is your answer. If no specific owner applies, use a role name (e.g. "Quality Manager").
Review queue
Approve structured findings before they are committed to the reporting set.
Candidate records
Customer
Source
Sentiment
Theme
Severity
Evidence
Action
Sentiment
Sentiment is inferred from the feedback text. Positive = predominantly favorable language. Negative = predominantly critical or dissatisfied language. Mixed = both present in the same record — the most common result for real-world feedback. Neutral = factual or observational with no clear tone. Any Negative or Mixed record automatically creates an open action. Review and correct before approving — the classification affects your trend chart and management review summary.
Severity
Severity is inferred from the sentiment and specific trigger words in the feedback text. High = direct mention of defects, delivery failures, or damage. Medium = negative or mixed tone without specific failure language. Low = positive or neutral records. Severity drives prioritization in the Actions tab — High items should be reviewed and dispositioned before Low items.
Analysis & reporting
Phase 1 includes executive reporting views aligned to QMS customer perception evaluation and follow-up tracking.
Approved records
0
Structured evidence items
Negative or mixed
0
Items needing attention
Open actions
0
Follow-up workload
Top theme
—
Primary concern area
Sentiment summary
Pareto by theme
Approved record register
Date
Customer
Theme
Sentiment
Status
Management review notes
Management Review Notes
These notes are auto-generated from your approved records and are intended as a starting point for your management review agenda — not a finished document. Copy the text into your management review minutes as a draft, then have the responsible person review and sign off before use as audit evidence. ISO 9001 §9.3 and AS9100 require that customer perception be a named input to management review.
Action tracking
Track which items require follow-up, assignment, or escalation into the QMS action system.
Open actions
Customer
Theme
Severity
Owner
Status
Customer Perception Analyzer
User Overview · The QMS Collective, LLC
Why This Tool Exists
Most organizations collect customer feedback in a dozen different places — emails, site visit notes, survey exports, verbal comments written on sticky notes. When an auditor asks "how do you monitor customer perception?", the answer is usually a scramble. This tool solves that problem by giving you one place to bring all of that scattered input, structure it consistently, and turn it into reviewable evidence. It replaces ad hoc folders and informal logs with a traceable record that supports ISO 9001 §9.1.2 and AS9100 customer perception requirements.
How It Works
1 · Intake
→
2 · Extract
→
3 · Review
→
4 · Approve
→
5 · Analyze
→
6 · Export
Enter or paste feedback from any source, assign context (customer, date, source type, owner), then click Create review candidates. The tool infers sentiment, theme, and severity from the text and places the result in the Review Queue. You approve, reject, or edit each candidate before it enters the active dataset. Approved records drive the Analysis charts and management review summary. Export to Excel at any time — the workbook includes a hidden backup sheet for full restore.
What This Tool Does for You
Eliminates the audit scramble. Every approved record is structured, dated, and traceable to its source — ready for auditor review without last-minute assembly.
Flags risk before it becomes a finding. Negative and mixed records automatically create open actions so nothing gets lost between review cycles.
Surfaces trends your team can act on. Sentiment and theme Pareto charts show where problems concentrate across customers, programs, and time periods.
Drafts your management review input. The management review notes panel generates a starting summary from your approved records — reducing prep time for §9.3 inputs.
Protects your data between sessions. Auto-save to browser storage and Excel export with embedded backup mean you never lose approved work.
Before You Start
📋 Gather your customer feedback sources — emails, survey exports, visit reports, report cards, or meeting notes covering the review period.
🗓️ Know the date range you are covering. Feedback date drives the trend analysis — vague or missing dates compress the chart.
👤 Identify who owns each customer relationship or source type so you can assign records accurately.
📁 For binary files (PDF, DOCX, XLSX): extract the relevant text before opening the tool and paste it into the feedback field. Binary parsing is not available in this release.
What This Tool Produces
Approved Record RegisterStructured, dated evidence of every reviewed customer perception input — traceable to source and owner.
Sentiment Summary ChartPositive / Negative / Mixed / Neutral breakdown across all approved records for the review period.
Theme Pareto ChartFrequency ranking of issue categories — Delivery, Quality, Communication, Documentation, Service — to direct improvement focus.
Open Actions RegisterAuto-generated follow-up list for all Negative and Mixed records, with owner and status tracking.
Management Review DraftAuto-generated narrative summary suitable as a starting point for ISO 9001 §9.3 management review input.
Excel Workbook ExportMulti-sheet workbook with Records, Themes, Actions, Dashboard_Data, and a hidden backup sheet for full restore.
Data & Privacy Note
All data entered into this tool is processed and stored entirely in your browser. Nothing is transmitted to any server. Auto-save uses your browser's local storage. The only external connection this tool makes is loading the SheetJS library from a public CDN on first load. Customer names, feedback text, and all record data remain on your device unless you choose to export and share the Excel file.