Fragrance Collection Tracker v1.0
$9 on Etsy
Keep your whole perfume and cologne collection in one spreadsheet: every bottle with its notes pyramid and ml left, a wear log with cost per wear, decants and samples, spend and value history, a printable insurance record, sales and swaps, and a wishlist, all on one dashboard.
Works in Excel and Google Sheets. No subscription.
What it does
- Every bottle: house, fragrance name, perfumer, year, concentration, note family, top / heart / base notes, bottle size, ml remaining and % left, price and more
- Wear Log: sprays, occasion, weather, compliments and how long it lasted, with cost per wear
- Decants & Samples: cost per ml and a verdict (Buy full bottle / Maybe / Pass)
- Notes Explorer: how many bottles contain each note, how often you wear them and your average rating
- Spend & Value History: monthly snapshots with a chart
- Insurance Record: a dated, printable record if you ever need it for insurance
- Sales & Swaps: fees, net proceeds and cost basis pro-rated by ml
- Wishlist: rows turn green when the price you enter reaches your target
- 11 tabs; Collection holds 500 bottles, Wear Log 3,000 entries
- Standard formulas only: no macros, no add-ins
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. Currency is a label you choose. Amounts aren't converted.
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
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.