Free Chemical Inventory Template (Excel)
What's in the chemical inventory template
Chemical Inventory logs up to 150 products: name, CAS number (stored as text so leading digits and dashes display correctly), quantity and unit, location, hazard class (flammable, corrosive, toxic, oxidizer, reactive, irritant, or non-hazardous), and whether an SDS is on file.
The SDS status column flags MISSING SDS automatically the moment you mark SDS on file as No - and only then, so a blank row never gets flagged before you've entered anything.
Location Rollup lists each storage location once, up to 15, and pulls chemicals-stored and missing-SDS counts automatically from Chemical Inventory using COUNTIF and COUNTIFS - so you can see at a glance which lab or storage room has the most compliance gaps.
Structured tracking versus the basic university and vendor files
The free chemical inventory files currently ranking are mostly raw XLSX spreadsheets published by university EHS departments - basic name/location/contact columns with no maintained structure, hazard classification, or SDS tracking built in.
The one alternative offering richer fields is a SaaS safety-management platform where the spreadsheet export is secondary to the paid platform itself.
This template sits between those two: a genuinely free, standalone Excel/Sheets file with hazard classification, a missing-SDS flag, and a location rollup - the structure the raw university files skip, without a platform subscription attached.
Who this template is for
Lab managers, EHS coordinators, and small manufacturers who need to keep an organized chemical inventory for OSHA HazCom compliance and want to spot missing safety data sheets before an inspection, not during one.
It's an organizational tool for your own inventory - it doesn't store, generate, or link to actual SDS documents. Keep your SDS files in their required accessible location and use this template to track which products still need one on file.
How to use it
- On Chemical Inventory, list every chemical with CAS number, quantity, location, hazard class, and whether an SDS is on file.
- Any row marked SDS on file = No is flagged MISSING SDS automatically.
- Check Location Rollup for chemicals stored and missing SDS count per location.
Download the free Free Chemical Inventory Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Does this store or link to actual SDS files?
No. This template tracks whether an SDS is on file for each chemical and flags gaps - it doesn't store, generate, or hyperlink to the actual safety data sheet documents.
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. Both tabs and every formula keep working.
Why is CAS number stored as text?
So leading zeros and the dash-separated format display exactly as written - if it were a number field, Excel could misinterpret or reformat the CAS number.
How many chemicals and locations does it support?
Up to 150 chemicals on the Chemical Inventory tab and up to 15 locations on Location Rollup - add more rows if you need additional capacity.
Is this a substitute for a full OSHA HazCom compliance program?
No. This is a compliance aid to organize your chemical inventory - verify your actual program against OSHA HazCom (29 CFR 1910.1200) and your local fire code requirements.
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.