Free Coin Inventory Spreadsheet (Excel)
What's in the coin inventory spreadsheet
One tab, Coin Inventory, holds up to 150 coins: name/type, year, grade (a dropdown from MS-70 down to Good-4), quantity, purchase price, and an estimated value field you fill in yourself.
Total cost, total value and gain/loss calculate automatically for every coin from quantity times price - no manual multiplication needed as your collection grows.
The summary below the table rolls up total pieces owned, total cost basis, total estimated value, total gain/loss, and how many coins are graded MS-70.
Why this goes beyond a printable label sheet
Most free coin templates found online - collector-forum inserts, printable album labels - are designed to be printed and slipped into a coin holder. They don't track purchase price, current value or gain/loss as a structured dataset.
This spreadsheet treats your collection as inventory: every coin is a row with real numbers attached, so you can sort by value, filter by grade, and see your total collection value and gain/loss update as you add coins or update estimates.
Estimated value: manual entry, by design
Coin values move with grading, market demand and metal content, and there's no reliable free live-pricing feed for numismatic values the way there is for stocks. So estimated value here is a field you fill in yourself.
Update it from a current price guide, recent auction results (PCGS, Heritage, eBay sold listings) or your own appraisal whenever you review the collection - the gain/loss column recalculates the moment you do.
How to use it
- List every coin with its year, grade, quantity and purchase price.
- Enter your own estimated current value per coin - this template does not pull live pricing.
- Check the summary below the table for total value, total gain/loss, and grade rollups.
Download the free Free Coin Inventory Spreadsheet (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Does this pull live coin market prices?
No. Estimated value is a field you enter yourself from a price guide or recent sale data - the spreadsheet calculates cost, value and gain/loss from what you type in.
How many coins can I track?
Up to 150 coins on the Coin Inventory sheet.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets.
Is this an appraisal for insurance purposes?
No. It's an organizing and tracking tool for your own purchase and value history - it doesn't set insurance or resale value.
What's the usage license?
Personal use only. It's not meant to be resold or redistributed as a template product.