Fragrance Collection Tracker, Perfume Inventory Spreadsheet, Excel & Google Sheets, Wear Log, Cost per Wear, Decants and Samples, Wishlist

Pay once. No subscription. Yours to keep.
You buy the file one time and it stays yours. There are no monthly fees, no yearly renewals and no account to keep paying for.

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 TRACKS
• Every bottle: house, fragrance name, perfumer, year, concentration, note family, top / heart / base notes, bottle size, ml remaining and % left, price, date, where bought, batch code, production date, box and cap condition, season, occasion, longevity, projection and rating
• Wear Log: sprays, occasion, weather, compliments and how long it lasted. Each bottle gets wears, cost per wear, last worn and days since worn
• 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, plus a yearly budget on the dashboard
• Insurance Record: batch codes, price paid and replacement estimates. 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
Start Here · Dashboard · Collection (500 bottles) · Wear Log (3,000 entries) · Decants & Samples · Notes Explorer · Spend & Value History · Insurance Record · Sales & Swaps · Wishlist · Settings

WHAT YOU GET
• One .xlsx file in a .zip, as an instant digital download
• Excel 2010 or newer (Windows), Excel 2011 or newer (Mac), Excel for the web
• Google Sheets: upload the file to Google Drive and open it. No add-ons needed
• Standard formulas only: no macros, no add-ins
• Sample rows show how it works. Delete them and start fresh

GOOD TO KNOW
• 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.
• Digital download: nothing is shipped. Your files are ready as soon as payment goes through, on your Etsy Purchases page and in your order email.
• Because it's an instant download, returns, exchanges and cancellations aren't accepted. If a file won't download or open, send us a message on Etsy and we'll help you get it working.
• For personal use only. Please don't resell, share or redistribute the files.
• Sample houses, fragrances and perfumers are fictional and for illustration only.
• Not affiliated with or endorsed by any fragrance house, retailer or marketplace.
• Made with AI: Collector Apps built this template with AI tools, which were used for the formulas, layout and text. Every tab was tested before release.

Questions? Send us a message on Etsy.