Makeratory Resources / Filament guides
Filament inventory template
How to build a useful 3D printer filament inventory spreadsheet
A spreadsheet can be an excellent filament tracker when the collection is still manageable. The key is recording only the fields that help you answer real workshop questions instead of creating a database you will stop updating.
The columns worth starting with
A practical one-row-per-spool sheet can begin with these fields:
- Spool ID — a short unique label if you own duplicates.
- Brand — manufacturer name.
- Material — PLA, PETG, ABS, ASA, TPU, or another material.
- Color — preferably the manufacturer's color name.
- Starting grams — the filament weight when full.
- Remaining grams — your current estimate.
- Location — shelf, dry box, AMS, dryer, cabinet, or bin.
- Purchase cost — useful for material-cost calculations later.
- Status — sealed, open, loaded, low, or empty.
Useful optional columns
Add fields only when you will actually use them. Depending on your workflow, useful extras can include purchase date, vendor, lot number, drying date, recommended print temperature, nozzle notes, reorder threshold, or a favorite flag.
The goal is not maximum detail. It is a sheet you will keep current.
How to track partial spools
The simplest repeatable method is to weigh the loaded spool and subtract the empty spool weight. That gives an estimate of filament remaining without measuring the filament directly.
Loaded spool weight − empty spool weight = estimated filament remaining.
When a spreadsheet starts to break down
A spreadsheet is still working if it stays current and answers your questions quickly. The warning signs are operational: duplicate purchases, stale remaining weights, uncertainty about where a spool is, several people editing different copies, or repeatedly rebuilding the same material information for products and production.
At that point the problem is not that spreadsheets are bad. It is that filament has become connected to printers, products, jobs, purchasing, and cost decisions that a flat table does not naturally maintain.
Spreadsheet vs dedicated filament inventory software
Use a spreadsheet when you want a free, flexible list and do not mind updating it manually.
Use dedicated software when the same spool data needs to drive production planning, product recipes, low-stock decisions, cost calculations, or multiple workflows without duplicate entry.
When you outgrow the template
Makeratory is built for the next stage: filament inventory connected to printers, products, production, parts, and shop planning in one workspace.