Guides / Free jewelry inventory spreadsheet (Excel and Google Sheets)
Free jewelry inventory spreadsheet (Excel and Google Sheets)
A spreadsheet is a fine way to start tracking jewelry stock. This one is built for jewelry, not generic goods: it knows about karat, grams, stones and certificate numbers, and it does the margin and stock-value math for you.
Download the spreadsheet (.xlsx)
Free to copy, edit and share. No sign-up. Works in Excel, Google Sheets, LibreOffice and Numbers.
What is inside
- Inventory tab: 500 rows with drop-downs for category, metal and status; SKU, karat or purity, weight in grams, stone, GIA / IGI certificate number, cost, price, quantity, location and date added.
- Automatic math: margin, margin %, cost value and retail value per row.
- Status tracking: In stock, Memo (out), On repair, Sold. Sold rows turn grey; low quantity turns red (you set the level).
- Summary tab: pieces in stock, stock value at cost and at retail, value out on memo, and a gold melt-value helper (weight x purity x price per gram).
How to use it in five minutes
- Open the file and read the "How to use" tab. Delete the four sample rows.
- Give every piece a SKU and write it on the tag. Photograph the piece and keep photos in a folder named by SKU.
- Enter karat and weight in grams. Karat to purity: 24k = 1.000, 22k = .916, 18k = .750, 14k = .585, 10k = .417, 9k = .375.
- Do a monthly cycle count: pick one case, count it, correct the quantity.
Where a spreadsheet stops working
Spreadsheets are great for stock. They get awkward when you also need sales receipts, a customer's balance, layaway payments, repair jobs with photos, and reminders in one place, or when more than one person edits at the same time. That is the point where a jewelry store app saves you time. Our jewelry store software guide lists what to look for.
Want this done for you?
Ayaro keeps the same inventory fields (karat, weight, stones, certificates, barcode labels) and adds sales, store credit, repairs and the live gold price.
Get Ayaro on Google Play Try it in your browser, no sign-up
Ayaro is a small jewelry store app by Pulad Labs (Istanbul): jewelry inventory, point of sale, layaway and store credit, repair tracking, live gold price. Android and any browser.
Frequently asked questions
Is the jewelry inventory spreadsheet really free?
Yes. Download, copy, edit and share it. No sign-up and no email required.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. The formulas, drop-downs and conditional formatting carry over.
What columns does it include?
SKU, item, category, metal, karat or purity, weight in grams, stone, certificate number, cost, price, quantity, status, location and date added, plus margin, margin % and stock value.