Coin Collection Tracker v1.1

$12

A spreadsheet for coin collectors: grades and certification, melt value from your spot prices, four pre-loaded US series checklists with key dates flagged, a sales log, monthly value history and a printable insurance sheet. Works in Excel and Google Sheets. No subscription.

If your coins are spread across albums, tubes and slab boxes, this keeps the records in one place.

Buy on Gumroad – $12

What it does

• 4 pre-loaded US series (417 date-mint lines) with key and semi-key dates flagged
• Melt value per coin and per metal from the spot prices you enter
• Grade dropdown (1 to 70), raw or certified, grading service, cert number and cert lookup links (PCGS, NGC)
• Sales & Trades log with profit, ROI and days held
• Monthly Value History with a chart
• Printable Insurance Sheet with totals
• Photo link column with a clickable Open photo link
• Currency choice (label only, no conversion)
• Room for 2,000 coin rows, 2,000 checklist lines (60 sets), 1,000 sales, 120 snapshots and 300 wishlist coins
• Excel 2010+ and Google Sheets; no macros, no add-ins, no subscription

Looking for cert lookups, price guides or care tips? See helpful collector resources.

Values are your own estimates; the template doesn't pull live prices and isn't an appraisal or insurance valuation. Melt value is metal content only. Key-date flags are a general guide. Not affiliated with or endorsed by PCGS, NGC, any other grading service, or any mint.

Spreadsheet or app?

	This tracker	A collection app
Cost	One payment, no subscription	Often free to start, some charge a subscription
Your data	In your own Excel or Google Sheets file. The file doesn't send anything by itself.	Stored in the app's account
Prices	You type values; the template doesn't pull live prices.	Some apps look up market prices for you
Photos and phone use	Photo link column (paste a web link to a photo)	Usually easier: snap a photo on your phone
Changing it	Standard formulas, no macros: add columns, sort and filter as you like	You get the app's layout

If you want automatic price lookups or a phone camera workflow, an app may suit you better. If you want a file you own, that works offline and has no subscription, a spreadsheet is a good fit.

Questions? collectorapps.support@proton.me