Free lab resource

Chemical Inventory Excel Template for Research Labs

Keep a list of the chemicals in your lab and a separate record for every bottle or vial. This workbook links the two, so samples of the same compound can have different quantities, batches and storage locations.

Free .xlsx download. No account or email needed. Two worksheets, with fictional examples you can replace.

Workbook structure

One compound, several physical samples

The Compounds worksheet holds chemical identity, registration group, CAS, SMILES, formula, molecular weight, DOI, tags, CLP assessment, storage class, precursor settings and compound-wide low-stock thresholds. Add each compound once.

The Items worksheet records each bottle or vial with its quantity, location, cell, status, supplier, catalogue and lot references, dates, solution details, responsible person, project, analyses, acquisition cost, storage requirements and custom fields. Existing batch numbers, label identifiers and record timestamps have optional columns too.

Two vials can share a compound reg number and still have different item IDs, amounts and locations. The compound name on Items is looked up automatically from Compounds. An unrecognised reg number shows Unknown compound.

  • Filterable tables, frozen headers and fixed identifying columns on both worksheets.
  • 200 prepared entry rows per worksheet, with fictional examples in the first few rows.
  • Unit and status dropdowns, numeric quantities and sortable dates.
  • No macros, external connections or sign-in required.

Filled example

Two vials of the same compound stay separate

These are the same fictional records included in the download. Fill in CAS and SMILES fields using identifiers you have checked for your actual compounds.

Compounds worksheet

Chemical identities
Compound reg numberCompound nameCAS / SMILES
LAB-0001Research compound ANot entered
LAB-0002Research compound BNot entered
REA-0001Solvent exampleNot entered

Items worksheet

Individual samples and remaining amounts
Item IDCompound reg numberCompound nameRemainingStorage pathCell
S-0001LAB-0001Research compound A45 mg/Room 24/Freezer/Shelf 1/Box 1A1
S-0002LAB-0001Research compound A120 mg/Room 24/Freezer/Shelf 1/Box 1A2
S-0003LAB-0002Research compound B80 mg/Room 24/Cabinet/Shelf 2—
S-0004REA-0001Solvent example450 ml/Room 24/Solvent cabinet/Shelf 1—

LAB-0001 has 45 mg in A1 and 120 mg in A2. Those are two separate samples. The solvent record contains 450 ml remaining in a bottle on a shelf, with no cell.

Download this workbook

Every field in the workbook

Fill in the information you already have. Use the compound reg number to link the worksheets, a full path for storage, an email for the responsible person, and a code and name for the project.

Compounds worksheet — 21 columns
FieldWhat to enter
Compound reg number A unique reference linking each compound to its items.
Compound name The compound name used by your laboratory.
CAS CAS registry number, stored as text.
SMILES Chemical structure in SMILES format.
Notes Optional migration notes for the setup team.
Group Name of the compound registration group.
Formula Known molecular formula. Molhaven calculates it from the structure.
Molecular weight (g/mol) Known molecular weight. Molhaven calculates exact molecular weight from the structure.
DOI DOI of a publication associated with the compound.
Tags Tag names separated by spaces.
Hazard assessment Use not_assessed until a hazard assessment is available. Values are not_assessed, assessed.
Hazard assessed at Existing assessment timestamp, when known.
CLP classifications (JSON) List of class_code, category_code, statement_codes, source_type and source_reference records.
Storage class Manually assigned TRGS 510 storage class, when known.
Precursor override (JSON) Existing list of Molhaven precursor catalogue codes. A blank cell uses structure matching.
Low stock threshold Compound-wide remaining-stock threshold. Enter its unit in the next column.
Low stock unit Unit for the compound-wide threshold. Values are mg, ml.
Salt form Existing salt form, when known. Molhaven derives it from the structure.
Parent SMILES Existing parent structure, when known. Molhaven derives it from the structure.
Created Original record creation timestamp, when known.
Updated Original record update timestamp, when known.
Items worksheet — 42 columns
FieldWhat to enter
Item ID Your existing reference for this individual bottle or vial.
Compound reg number Matching reference from Compounds column A.
Compound name (auto) Formula looking up the compound name. Keep this formula.
Quantity Remaining quantity, using the unit in the next column.
Unit mg for mass or ml for volume. Values are mg, ml.
Storage path Full storage address, such as /Room 24/Freezer/Shelf 1/Box 1.
Cell Human-readable container cell label, such as A1.
Status Current sample status. Values are available, reserved, quarantine, empty, disposed.
Lot Supplier lot or laboratory batch reference.
Supplier Supplier name.
Received Date the sample arrived.
Expires Expiry date, when known.
Project Project name.
Notes Additional sample information.
Catalog number Supplier catalogue reference.
Opened Date the sample was opened.
Concentration Solution concentration. Fill in its unit alongside it.
Concentration unit Unit for the concentration. Values are mg/ml, mmol/l, mol/l, %.
Solvent Solvent used for the solution.
Responsible user email Email of the responsible laboratory member.
Project code Existing project code.
HPLC purity (%) A numeric percentage from 0 to 100, such as 97.5.
NMR reference NMR analysis identifier or file reference.
MS reference Mass spectrometry identifier or file reference.
HPLC reference HPLC analysis identifier or file reference.
FTIR reference FTIR analysis identifier or file reference.
Melting point Melting point or range with its unit, such as 120–122 °C.
Price Acquisition cost of Price quantity, using Currency.
Currency Three-letter currency code, such as PLN or EUR.
Price quantity Amount covered by Price, using the same Unit as Quantity.
Storage requirements (JSON) Object containing required temperatures, protection flags and storage notes.
Additional fields (JSON) List of objects containing name and value for each custom field.
Cell index Existing one-based cell index, when known. Keep it consistent with Cell.
Cell count Total number of cells in the destination container.
Cell rows Number of rows in a rectangular container.
Cell columns Number of columns in a rectangular container.
Batch number Existing batch sequence within the compound, when known.
Barcode ID Existing Molhaven barcode identifier. Leave blank for new labels.
QR token Existing Molhaven QR UUID. Leave blank for a new record.
Import ID Existing Molhaven import UUID. Leave blank for a new record.
Created Original record creation timestamp, when known.
Updated Original record update timestamp, when known.

Fields containing lists or structured details

For CLP classifications, enter a JSON list of classification records with class_code, category_code, statement_codes, source_type and source_reference. Supported sources are sds, echa_harmonised, echa_notified and manual. Keep the assessment status and date alongside the classifications.

Precursor override accepts a JSON list of existing Molhaven catalogue codes. Leaving it blank lets Molhaven match the chemical structure during setup.

Additional fields uses name and value pairs, such as [{"name":"Vial type","value":"Glass"}]. Values can be text, numbers or booleans.

Storage requirements accepts temperature_min_c, temperature_max_c, protect_from_light, keep_dry, inert_atmosphere, ventilated, flammable_rated, secondary_containment and notes. For example, {"temperature_min_c":2,"temperature_max_c":8,"protect_from_light":true} records refrigeration and light protection requirements.

Dates use YYYY-MM-DD. For acquisition costs, fill in Price, Currency and Price quantity together. A price of 25 PLN for 500 ml describes the original purchase while Quantity records the remaining amount. Keep existing Barcode ID, QR token, Import ID and batch values when available. Molhaven generates identifiers for new records.

Start your inventory

Replace the examples with your lab’s records

  1. Register compounds first. Give each a unique, stable reg number. Use your existing numbers if you have them. Use separate records for distinct chemical identities, including different salts or stereoisomers where appropriate.
  2. Add one row per bottle or vial on Items. Enter the matching compound reg number in column B. Keep the formula in column C to fill in the compound name automatically.
  3. Record the remaining amount. Enter a number in Quantity and choose mg or ml in Unit. Convert grams or litres to milligrams or millilitres before entering them. Keep the unit separate from the number.
  4. Write the full storage address. Use a consistent path such as /Room 24/Freezer/Shelf 1/Box 1. Put A1 in Cell if the sample occupies a position in a box. Leave Cell empty for an ordinary shelf.
  5. Fill in the details you know. Dates, lot, supplier, status and project help colleagues distinguish samples. Add analysis references, solution concentration and acquisition cost when known. Leave unknown information blank.

The workbook prepares 200 rows on each sheet, including formulas in Items column C. When you need more, expand the Excel table, copy the formula and dropdowns down, and extend the compound lookup range beyond row 205.

Keep it useful

Update the row when a sample changes

After using a sample, record its remaining amount. After moving it, update its storage path and cell. Add a fresh row for a new batch or bottle, even when its compound is already registered.

Filter by compound reg number to find every sample of it, or by storage path when checking a shelf. During a stocktake, compare the table with the actual bottles and record the check in Notes. Keep a dated backup before a large edit.

Quantities use the units entered beside them. Convert compatible units before adding amounts, and keep mass and volume separate.

When the spreadsheet grows

We can help move your Excel inventory into Molhaven

When several people update the same collection, you may want structure search, item history, stock alerts, barcode labels and a shared storage tree. Molhaven keeps compounds linked to their physical samples, following the same separation as this template.

Create a free laboratory and upload your workbook through Bring your existing data. We help prepare and map the compounds, items and storage locations, then review the result with you. We provide assisted Excel migration. For SDF files, you can map fields yourself in the app.

The Free plan includes every feature for up to 3 users, 1,000 compounds and 1 GB of files, with no time limit.

Questions about the template

Can I use it without Molhaven?

Yes. The workbook is a standalone .xlsx file. It needs no account, subscription, macros or connection to Molhaven.

Can a compound have no CAS number?

Yes. In-house compounds may have no CAS number. Give them a stable reg number and record their structure as SMILES when available.

Can I import the workbook directly?

You can upload it for assisted setup. We review and prepare the data with you.