Wine Collection Inventory Spreadsheet
For home wine collectors tracking bottles across a cellar, wine fridge or rack. Record producer, vintage, quantity, cost and where each bottle sits so the right one gets opened at the right time.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Room | Item | Brand / Model | Serial # | Qty | Purchase Date | Purchase Price | Totalƒ | Receipt? | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Cellar | 2019 Napa Cabernet Sauvignon | Hillcrest Estate | 6 | 2025-03-11 | 65 | auto | Yes | Rack B, Row 3; drink 2027-2035 | |
| Wine Fridge | 2022 Willamette Pinot Noir | Fernhill Vineyards | 4 | 2025-06-28 | 38 | auto | Yes | Shelf 2; drink now-2029 | |
| Cellar | 2018 Vintage Champagne | Maison Delorme | 2 | 2025-12-15 | 95 | auto | No | Rack A, Row 1; save for anniversary |
ƒ = calculated automatically by formula.
What's included
- Room
- Item
- Brand / Model
- Serial #
- Qty
- Purchase Date
- Purchase Price
- Total — calculated automatically
- Receipt?
- Notes
Tips for using this template
- Use rack row and slot in the notes so you can find a bottle without pulling half the cellar.
- Add a drink-from and drink-by window to each wine in the notes and sort by it each month.
- Update quantities as soon as you open a bottle; a cellar list is only useful if it's current.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateHome Inventory for MovingHome Inventory for InsuranceDorm Room Inventory ChecklistAirbnb Inventory ChecklistRental Property Inventory TemplateCollectibles Inventory SpreadsheetCloset Inventory Spreadsheet