Hazardous substances register template (Excel and PDF)
Excel register with all mandatory information required by the Hazardous Substances Ordinance – name, classification, H statements, quantities, work areas, safety data sheet – plus a PDF version for the folder.
As of PDF and ExcelAMS Go editorial team
Anyone working with hazardous substances in Germany must keep a register that states the name, classification, quantities and work areas and refers to the relevant safety data sheet (Section 6 (12) of the Hazardous Substances Ordinance). It must be accessible to all employees.
The Excel template contains all mandatory information plus the columns needed in practice: storage class, water hazard class, status of the safety data sheet, operating instructions and substitution check. The PDF version is suitable for posting in the warehouse or for the hazardous substances folder.
What the template contains
- Excel spreadsheet with 16 columns, drop-down lists for signal word, quantity range, storage class and water hazard class
- Example row to overwrite and 40 prepared rows
- Second worksheet with the nine GHS pictograms and their meaning
- PDF register in landscape format for posting
How to use the template
- 1
Take stock
Go through all storage areas, cabinets and workstations. Everything with a hazard pictogram on the label belongs in the register – including cleaning agents, sprays and small quantities.
- 2
Use the safety data sheet
Classification, H statements and signal word are in section 2 of the safety data sheet, storage class and water hazard class in section 15. Note the date and version of the data sheet.
- 3
Keep it up to date
Enter new substances immediately and remove those no longer used. Once a year, check whether the safety data sheets are still current and date the register.
Legal basis
- Section 6 (12) GefStoffV: hazardous substances register
- Section 14 GefStoffV: access to safety data sheets and register
- TRGS 400: risk assessment for activities involving hazardous substances
- TRGS 510: storage of hazardous substances in mobile containers
Frequently asked questions
What information must the hazardous substances register contain as a minimum?
The name of the hazardous substance, its classification or information on its hazardous properties, quantity ranges in the company, the work areas in which it is handled and a reference to the safety data sheet (Section 6 (12) GefStoffV).
Do cleaning agents also have to go into the register?
Yes, if they are classified as hazardous – recognisable by the pictogram on the label. The only exceptions are substances whose hazard is so low, given the quantity and use, that no additional protective measures are needed.
Is Excel good enough for the hazardous substances register?
For small inventories, yes. With many substances, several sites and regular updates of safety data sheets, maintenance becomes time-consuming. Software can read safety data sheets with AI and keep the register up to date automatically.
You may use and adapt the template freely in your own company and for your own clients. It reflects the regulations named as they stand, but does not replace legal advice or adapting it to your own company.
Never search a spreadsheet for a deadline again
In AMS Go, what this template covers lives in one system with reminders, history and records at the push of a button – mobile and with AI support.
