laboratory-inventory-template.csv — plain CSV, opens in Excel, Numbers, or Google Sheets.
Download the inventory worksheet
Use this worksheet to record items, lots, quantities, locations, and expiry dates. It is a general planning file, not a direct ScientivoLab import file.
Moving items into ScientivoLab?
Download the separate item-import CSV, add one item per row, then upload it on the in-app Import items page. The file has the exact headers the importer accepts and starts empty, so you will not accidentally import example products.
The item importer creates items and optional categories and suppliers. It does not import lots, stock quantities, storage locations, or expiry dates. Add those records in the app after importing items.
What's in the template
| Field | What it means |
|---|---|
item | The product: name as your lab refers to it (e.g. "PBS buffer 1x"). |
lot | The physical batch, with its own identity. Leave empty for non-batched consumables. |
quantity | How much is currently there. |
unit | How you count it: bottles, vials, pieces, grams. |
location | Where it lives — be specific: room, freezer, shelf, or rack. |
supplier | Who you buy it from. |
expiry date | Per lot, in YYYY-MM-DD format. Empty when the item has no expiry. |
minimum stock | The level that triggers a reorder — set from your consumption rate. |
How to use it
- Download the CSV and add one row per item (or per lot where expiry matters).
- Fill in location precisely — "Freezer -20C / Rack A" beats "freezer."
- Set a minimum stock value for anything that runs out unnoticed today.
- Keep the file where your team actually looks, and review the expiry column when you add stock.
Why these fields
The template mirrors the concepts that make lab inventory manageable: items as the products you buy, lots as the batches that expire, quantities tied to specific places, and a minimum stock line that turns stockouts into warnings. If you later outgrow the file, a lab inventory management system keeps exactly these concepts — items, lots, stock per location — plus alerts, movement history, and multiple users.
From template to system
To move from this worksheet into ScientivoLab, copy each distinct product into the item-import CSV. Use name for the product name, units for the unit, and minimumStock for the reorder threshold. You can also include category, description, supplier, product code, and price. Upload the file to preview validation errors before confirming the import. Record each lot, quantity, location, and expiry date separately after the item import. The principles in our inventory management guide explain how the item/lot/stock model works in practice.