Lab Chemical Inventory Spreadsheet
For school, university and QC labs tracking reagents, solvents and buffers by container. Record lot, storage location, quantity and expiration to support safety reviews and avoid duplicate orders.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Lot # | Location | Unit | Qty | Min Qty | Statusƒ | Expiry | Days to Expiryƒ | Unit Cost | Valueƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ethanol, 200 Proof, 4 L | Solvents | ET25-0912 | Flammables Cabinet 1 | bottle | 3 | 2 | auto | 2027-01-31 | auto | 98 | auto | Benchmark Scientific Supply |
| Sodium Chloride, ACS Grade, 500 g | Salts | NA25-3301 | General Shelf B | jar | 4 | 2 | auto | 2027-06-30 | auto | 21.5 | auto | Benchmark Scientific Supply |
| Hydrochloric Acid 1 M, 1 L | Acids | HC25-1187 | Acid Cabinet | bottle | 2 | 1 | auto | 2027-03-31 | auto | 34 | auto | Lakeside Lab Chemicals |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Lot #
- Location
- Unit
- Qty
- Min Qty
- Status — calculated automatically
- Expiry
- Days to Expiry — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
Tips for using this template
- Note the storage group (flammables, acids, bases, oxidizers) in the location column so incompatible chemicals aren't shelved together.
- Write the date opened on every container and add it to your notes; some reagents degrade faster once opened.
- Keep safety data sheets linked or filed by the same item name used here so they are easy to find.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateMedical Office Supply Inventory TemplateDental Office Inventory SpreadsheetVeterinary Clinic Inventory TemplateFirst Aid Kit Inventory TemplateSpa Inventory TemplateTattoo Shop Inventory SpreadsheetPPE Inventory TemplateJanitorial Supply Inventory Spreadsheet