Environmental Aspects and Impacts Register Worksheet (Excel)
An aspects and impacts register is the backbone of an ISO 14001 environmental management system. This worksheet lets you list each activity, rate it, and see which aspects rank highest so you can focus objectives and controls where they matter.
| Activity or process | Environmental aspect | Environmental impact | Condition | Severity (1-5) | Frequency (1-5) | Control weakness (1-5) | Significance score | Owner | Next review | |
|---|---|---|---|---|---|---|---|---|---|---|
32 | ||||||||||
45 | ||||||||||
20 | ||||||||||
30 | ||||||||||
12 |
Many sites treat a score of 40 or more (out of 125) as significant, or any aspect with severity 5. Set your own threshold and write it into your procedure so auditors can see it is applied consistently.
Review my aspects register
Optional: send us your register and we will suggest gaps and data that could be pulled from your ERP.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Walk the process from receiving to shipping and list every activity that takes in a resource or puts something into air, water, land or waste. For each, write the aspect (the thing the activity does) and the impact (the change to the environment). Rate severity, frequency and control weakness from 1 to 5. The score multiplies the three, so a high score needs at least two factors to be elevated. Add rows for abnormal conditions such as start-up and maintenance, and for emergencies such as spills and fires.
- One row per activity and aspect pair, not per department
- Include contractors working on your site
- Record the life cycle perspective for products you design
- Date every review so the register stays current
The method behind the score
ISO 14001 requires you to determine aspects you can control or influence and decide which are significant, using criteria you define. It does not prescribe a formula. A severity times frequency times control approach is common because it separates a rare but serious event from a daily minor one, and it rewards the control improvements you make. Whatever criteria you choose, document them, apply them to every row and keep the results as documented information.
Reading the results
Sort by score and look at the top of the list first. High scores with weak control are candidates for objectives, operational controls or monitoring. A high severity item with a low overall score because it is rare still needs an emergency plan. Compare condition types: emergency rows should have a drill or response procedure, and abnormal rows should connect to a work instruction.
Common mistakes
The most frequent audit finding is a register built once and never updated after a new process, chemical or building change. Others include rating only normal operations, confusing aspects with impacts, scoring by gut feel without recorded criteria, and listing hundreds of trivial rows so the real risks are lost.
- Not linking significant aspects to objectives or controls
- Ignoring changes from the management of change process
- No evidence of who rated each row
Frequently Asked Questions
What is the difference between an aspect and an impact?
An aspect is the element of your activity, product or service that interacts with the environment, such as discharging used coolant. The impact is the resulting change, such as contaminated water. You rate the aspect, but describe the impact so the reader sees why it matters.
How often should the register be reviewed?
At least annually and whenever something changes: a new process, chemical, building, regulation or incident. Many sites also review it as an input to management review. Keep the review dates in the register so an auditor can see the cycle.
What score makes an aspect significant?
ISO 14001 leaves the criteria to you. A threshold such as 40 out of 125, plus an override for any legal non-compliance or severity 5 item, is a common setup. Document the rule and use it consistently across all rows.
Can I import this into a QMS or EHS system?
Yes. Export the worksheet to Excel or CSV and map the columns to your EHS software or SharePoint list. Keep the column names stable so later exports can be compared with earlier ones.
If your chemical, waste and utility data already live in your ERP, we can help pull them into a live register instead of a spreadsheet kept by one person.
Related Tools
Environmental Compliance Obligations Register Worksheet
Track every permit, regulation and customer requirement with owner, frequency and next due date, and see overdue items at a glance.
Safety & WorkforceHazardous Waste Container Inspection Log Worksheet
Log each container's label, closure, condition and days accumulated, and flag anything nearing your storage time limit.
Safety & WorkforceSpill Incident Report and Corrective Action Template
A structured form to record a chemical or oil spill, the response, notifications and corrective actions.
Safety & WorkforceStormwater Inspection Report Template
A routine site inspection form covering outfalls, material storage, housekeeping and best management practices.
More Safety & Workforce tools
See all- Hazard Identification and Risk Ranking Worksheet
- Plant HR and Labor KPI Definitions Reference
- Shift Work Fatigue Risk Assessment
- New Operator First Week Onboarding Checklist
- Production Supervisor Capability Self-Assessment
- Toolbox Talk Record Template
- Confined Space Entry Permit Template
- Hot Work Permit Template
- Emergency Action Plan Template