Watch Collection Tracker v1.2
$12
A spreadsheet for watch collectors: value and gain/loss, service due dates, cost per wear, accuracy, full specs, paperwork and sales on one dashboard. Pick your currency. Works in Excel and Google Sheets. No subscription.
If your collection lives in a notes app and a pile of receipts, this puts it in one place.
Buy on Gumroad – $12Buy on Etsy – $12
What it does
- Dashboard with collection value, cost and gain/loss
- 8 spec columns: lug width, lug-to-lug, thickness, water resistance, crystal, caliber, power reserve, strap
- Photo link column with a clickable Open photo link
- Currency choice (label only, no conversion)
- Cost per wear and a Resting flag
- Accuracy log with seconds-per-day rate
- Value history with a chart for any watch you pick
- Insurance & papers tab; Sales & flips with net profit
- Service due dates with overdue and due-soon highlighting
- Room for 500 watches, 1,000 service entries, 2,000 wear days, 1,000 accuracy readings, 2,000 value entries and 500 sales
- 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. Not affiliated with or endorsed by any watch brand, retailer or marketplace. Sample brands are fictional and for illustration only.
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.
Try the free Lite first
A free starter spreadsheet for up to 15 watches. Log what you paid and what you estimate each watch is worth, and see your totals and gain or loss in one simple summary. Works in Excel and Google Sheets.
Get the free LitePrefer Notion? See the Watch Collection Tracker for Notion.
Questions? collectorapps.support@proton.me
Get a free Lite tracker
Most of our spreadsheet trackers have a free Lite version, so you can try the format before you buy. Leave your email and we'll send you the free Lites for watches, trading cards, comics and fragrance, plus a note when a new one comes out (a coin Lite is on the way).
We'll ask you to confirm your email first. Unsubscribe any time. See Privacy.
Don't see your collection?
Tell us what you collect and what you'd want to track. The most-requested ideas go on our list for future trackers.