Your precious metals inventory spreadsheet, valued at live prices
Everything you own, at live metal prices.
Every coin and bar you own in one place, valued at live metal prices. Record a one-line entry or the serial number on a bar, whichever you feel like, and the figures that need years of price history are worked out for you. Bring the file you already keep and it comes across in one go.
What it works out for you
Every figure here comes from what you already entered, and keeps itself current.
- What the metal was worth the day you bought it. Separates the premium you paid from what the price has done since.
- What each shop charges you over the metal. Your purchases grouped by shop, each measured against the metal on its own purchase day.
- Melt and retail, side by side, never blended. Melt is math on a published price. Retail estimates what a dealer would ask for that exact product.
- Your stack as it actually grew. The ounces you held on each day you held them, stepping up as you bought.
- An insurance schedule, printed on demand. Every holding with weight, purity, serial numbers, cost and value, at the prices it names and dated.
- Thirty-three currencies, and each purchase stays in the one you paid. Converted at the rate published for that date rather than today's.
- What it is selling for right now. The magnifier on any row pulls live dealer prices and eBay listings for the same piece.
- Won a lot? It is already yours. A lot you won at auction moves in with one click, metal, weight and hammer price carried across.
What it is worth, and what you paid for it
The value of everything you hold, over whatever window you pick. Underneath it, what you paid set against what the metal was worth on the days you bought, so the premium and the price movement stay separate.
When you sell
Sold pieces move to their own list: what came in, the net, the ounces that left and your biggest single sale. Every row shows what the metal was worth that day and how far over it you sold. Change your mind and un-selling is one click.
Bring the file you already have
You do not have to start again, and you do not have to rename a single column. Upload a CSV or an Excel file and the app reads your headings, works out which mean weight, purity, price and date, and shows you every row it understood before anything is saved. Any column it guessed wrong is a dropdown away from right, and a file with no headings at all is fine because you can map every column yourself. Rows that look like holdings you already have are flagged and left out unless you say otherwise, so importing the same file twice does not double your stack. Getting out is the same in reverse. Export the whole vault to CSV whenever you like, sold items and all, and print an insurance schedule on any plan. Nothing here is a one-way door.
- It reads your column names, whatever you called them. Wt, Weight (ozt), Troy oz and Ounces all land in the same place.
- It reads the description too, the way it reads an auction catalog. A row that just says 1 oz PAMP Suisse Silver Bar .999 comes in with its metal, weight, purity and refiner already set.
- It refuses to guess at money. An asking price, an estimate or a reserve is never imported as what you paid, because a fabricated cost would quietly wrong every figure in your vault.
- It refuses an ambiguous date rather than picking one. 03/04/2026 could be two different days, and the metal price on those days is not the same.
- Rows it could not read are shown to you, not dropped. You fix them or add them by hand.
- The file is read in your browser and never uploaded. Only the rows you confirm are saved.
A free precious metals inventory spreadsheet
If you would rather keep your own sheet, take ours. The columns are already named, four rows are filled in as examples, and it opens in Excel, Numbers, Google Sheets or anything else that reads a CSV. No account, no email address. Keep it for as long as it suits you, and the day it stops being enough it imports here without renaming a single column, because it was written against the same reader.
Download the spreadsheet template- Weight is per piece and Quantity multiplies it. That is the one thing a hand-kept sheet usually gets wrong, so the file shows a hundred dimes to make it obvious.
- A gift is not a purchase with the price left blank. Those are opposite facts, and the How acquired column keeps them apart.
- Delete the four example rows before you import. Every one of them says so in its Notes column.
Available fields
Enough to describe the piece properly, and nothing that pretends to be tax advice. Only the metal, weight, purity and how many are ever required. The rest is there when you want it.
What it is
- What is it?
- Metal
- Weight
- Unit
- Purity
- How many
- Form
- Mint or refiner
- Year
- Condition
Which one exactly
- Country or issuer
- Face value
- Mint mark
- Catalogue number
- Graded by
- Certificate number
- Serial number
What it cost, and where it came from
- When did you buy it?
- Where did you buy it?
- Price
- Buyer's premium
- Tax
- Shipping
- Other fees
- Currency
- This was a gift or inherited
If you sell it
- Date sold
- What you were paid
- Shipping you paid
- Seller fees or commission
Yours to use however you like
- Your labels
- Notes
Where you buy, measured against the metal that day
Where you buy changes what you get, and it hides completely one purchase at a time. This measures what you paid against what the metal was worth on the day you bought it, then groups that by shop, so two dealers you used years apart compare fairly. Beside it, your average cost per ounce as it built up, stepping only on the days you actually bought.
Kept secure, and yours to take or delete
Your vault is encrypted in transit and at rest, backups included, and the privacy policy sets out exactly how. Export it all to CSV any time, print an insurance schedule of the lot whenever your insurer asks for one, delete any of it any time, and closing your account deletes everything.
What it costs
The free plan holds 15 holdings, which is enough for a real stack rather than a taste of one. Stacker holds 75, Pro holds 200, and Pro Plus is unlimited. If you ever go back to free nothing is deleted: your whole vault stays readable, editable and exportable, and the only thing that stops is adding more.
See all the plansQuestions
Can I import my existing spreadsheet?
Yes, and you do not have to reformat it first. Upload a CSV or an Excel file and the app works out what your columns mean, including when the useful detail is buried in a description rather than in tidy columns. You see everything it found, and what it could not read, before anything is saved.
How is my stack valued?
Against live metal prices, for the metal content only. You see two figures side by side and they are never blended: melt, which is the metal at spot, and a retail estimate, which is roughly what a dealer would ask for the same thing. Melt is a fact and the retail figure is an estimate, so we label them that way rather than showing one number called value.
Does it include collector or numismatic value?
No. It measures metal. A key date, a low mintage, a high grade or special packaging can carry a premium that a metal calculation never sees, so a piece worth far more to a collector will still show here at its metal value. Use it for the metal side and bring your own knowledge for the rest.
Can I look up what one of my holdings is worth to buy or sell?
Yes. Every row has a magnifying glass. It pulls current dealer prices from our own price feed, plus live listings from eBay in the US and Canada, for the same kind of piece. What gets searched is deliberately narrow: the metal, the weight, the purity, the year, and the mint or refiner when it is one we recognise. What you called the item, your notes, where you bought it and every amount you entered stay on your device and are never sent anywhere. So the lookup can tell you what a one-ounce Maple Leaf is going for without anyone learning that yours is the one your father left you or what you paid for it.
Can I track what I sold?
Yes. Mark something sold with the date and the price and it moves out of your stack into its own list, showing what you paid, what you received and the difference, with charts for what came in and which metal it came from. Nothing is deleted, so the history stays. It is math on figures you entered yourself and it is not tax advice.
What happens to a price I entered wrong?
You just edit it. Open the holding, change the price, and that is the figure everywhere from then on. You can correct anything you record, as often as you like.
Can I use more than one currency?
Yes. Switch the whole page between currencies at any time. What you paid always stays in the currency you paid in, because converting a purchase from three years ago at today's rate would produce a number that was never true.
Is it really free?
The free plan holds 15 holdings and needs no credit card. Stacker holds 75, Pro holds 200, and Pro Plus is unlimited. Nothing is ever deleted for downgrading.
Can I print a list for my insurer?
Yes, on every plan. One button prints an insurance schedule of everything you currently hold, with weight, purity, quantity, serial and certificate numbers, what you paid, what the metal is worth today and what it would cost to replace. It names the metal prices it used and the date it was prepared, which is what an underwriter asks for. Save it as a PDF from the print dialog. It is not an appraisal and it says so.
Bring your stack over
Import your spreadsheet or add the first piece by hand. It takes a minute.
Open my vaultFree account, no credit card.