Closet Inventory Spreadsheet
For anyone organizing a wardrobe, planning a capsule closet or documenting clothing for insurance. Track items, brands, quantity and what you paid to see what you actually wear.
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 |
|---|---|---|---|---|---|---|---|---|---|
| Main Closet | Wool Overcoat | J.Crew Ludlow | 1 | 2025-10-18 | 398 | auto | Yes | Dry clean in spring | |
| Main Closet | Leather Ankle Boots | Blondo Waterproof | 1 | 2025-11-02 | 170 | auto | Yes | Worn weekly in winter | |
| Dresser | Merino Crewneck Sweaters | Uniqlo Extra Fine Merino | 3 | 2025-09-05 | 40 | auto | No | Two navy, one gray |
ƒ = 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
- Mark items you haven't worn in a year in the notes and decide at each season change whether to donate or resell them.
- Group by category in the room column (closet, dresser, storage bin) so seasonal swaps are quick.
- Record purchase price for coats, shoes and bags; they make up most of a wardrobe's replacement value.
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 SpreadsheetWine Collection Inventory Spreadsheet