Free template
Gemstone inventory spreadsheet template
A ready-made stock sheet for gem dealers. It opens in Excel and Google Sheets, has two example rows to delete, and covers the details every stone record needs. When your stock outgrows it, GemColony can import it.
Want this handled automatically?
GemColony keeps memos, consignments and stock records in one system, with every stone's history.
Learn more Download the CSV template
What is in it
- Stock No
- Stone Type
- Variety
- Shape
- Cut
- Colour
- Weight (ct)
- Length / Width / Depth (mm)
- Clarity
- Treatment
- Origin
- Lab and report no.
- Report date
- Purchase date and supplier
- Purchase cost and currency
- Cutting cost
- Asking and minimum price
- Status
- Location
- Memo holder and due date
- Notes
Read why each field matters.
Frequently asked questions
How do I use the template?
Download the CSV, open it in Excel or Google Sheets, delete the two example rows and start entering stones.
Can I import this into GemColony later?
Yes. GemColony can import your existing stock from Excel.
Why not use a spreadsheet forever?
Spreadsheets work for a small stock and one person. They lack an audit trail, memo tracking and multi-user control.