Wardrobe Inventory Spreadsheet Template (Free Copy)
A wardrobe inventory spreadsheet template is a sheet with one row for every piece of clothing you own, and columns for things like category, color, season and where it's stored. The free template below is built for a personal closet, not a shop's stock list, so it skips SKUs and reorder levels and adds what you actually need: fit, season and how often you wear it. Copy it into Google Sheets or Excel in about two minutes.
If you want to know not just what you own but what you actually wear, WORN is being built to track that from one photo a day, no cataloguing required: Start my outfit diary
Why keep a wardrobe inventory
Most clothing inventory templates online were made for retailers. They track quantities, suppliers and stock value. A personal closet needs something different.
A personal wardrobe inventory helps you:
- Answer "how many clothes do I own?" Most people are surprised by the number.
- Stop buying duplicates. Before you buy another black tee, check how many you have.
- Pack faster. Travel lists come straight from your wardrobe inventory list.
- See your real palette. Sort by color and your style shows up.
- Prepare for an audit. An inventory is the base layer for any closet review.
It's also genuinely satisfying. Seeing everything you own on one screen changes how you think about the next thing you buy.
What to list for each piece
Keep columns to what you'll really fill in. Ten is plenty. Here's the wardrobe inventory template:
| Item | Category | Subcategory | Color | Season | Fits? | Storage | Date added | Times worn | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Straight-leg jeans | Bottoms | Jeans | Mid blue | All year | Y | Closet | 2025-09 | 22 | Favorite |
| Wool sweater | Tops | Knitwear | Cream | Winter | Y | Under-bed box | 2024-11 | 4 | Itchy at neck |
| Linen shirt | Tops | Shirts | White | Summer | Y | Closet | 2026-05 | 7 | Wrinkles fast |
| Black ankle boots | Shoes | Boots | Black | Fall/winter | Y | Shoe rack | 2025-10 | 15 | Resole soon |
Column guide
- Item: a name you'd recognize instantly.
- Category / Subcategory: see the next section.
- Color: main color only.
- Season: summer, winter, spring/fall, all year.
- Fits?: Y or N, today.
- Storage: closet, dresser, under-bed box, at another home. Handy if you split time between two places.
- Date added: month and year you got it. Helps spot impulse buys.
- Times worn: optional but powerful. More on this below.
- Notes: repairs, care, what it pairs with.
Categories that make sense
Retail categories are too detailed for a personal clothing inventory spreadsheet. Use broad categories with a few subcategories.
Main categories:
- Tops (tees, shirts, knitwear, sweatshirts)
- Bottoms (jeans, trousers, skirts, shorts, leggings)
- One-pieces (dresses, jumpsuits, sets)
- Layers (jackets, coats, cardigans, hoodies)
- Shoes
- Accessories (bags, belts, hats, scarves)
- Activewear
- Sleep and loungewear
Skip underwear and socks unless you really want them. They add rows without adding insight.
Tip for Google Sheets: put your categories on a second tab and use Data → Data validation to make the Category column a dropdown. It keeps sorting clean.
Photos or no photos?
This is where most people give up on a closet inventory spreadsheet. Photographing every piece, cropping, and linking each image can take a whole weekend.
No photos (recommended to start):
- Much faster. You can list a whole closet in an hour or two.
- Good names do the job: "cream cable knit sweater" is clear enough.
Photos (optional later):
- Nice for resale or packing.
- Add them only for items where the name isn't enough.
- In Google Sheets,
=IMAGE("url")shows a thumbnail from a link.
A middle path: photograph the closet rail and each drawer, one photo per section. Ten photos cover everything, and the list does the rest.
Keep it updated
An inventory is only useful while it's accurate. The good news: keeping it up to date takes a couple of minutes a week.
The simple update routine
- New item in: add a row the day it arrives.
- Item out: don't delete the row. Add a "Gone" column with the date and where it went (donated, sold, passed on). This history shows your patterns.
- Each season: filter by Season, check the Fits column, update anything that changed.
The times worn column
A wardrobe inventory tells you what you own. Adding a times worn count tells you what you use, which is where the real insights live. The catch is that counting requires logging every day, and that's the step that fades fastest.
Updating a spreadsheet every day for every outfit is where most inventories stall. WORN is being built to do the "what did I wear" part without any spreadsheet at all: one photo a day, one tap, no tagging and no cataloguing your wardrobe first. After a month it reads back the few pieces you really wear and the ones you never touch. Start my outfit diary
If you do log wear counts, you're halfway to a full audit. The wardrobe audit template adds verdict columns, and how to do a wardrobe audit walks through the sorting.
Download and copy the wardrobe inventory spreadsheet template
No sign-up, no download link needed. Copy this header row into cell A1 of a new sheet:
Item | Category | Subcategory | Color | Season | Fits? | Storage | Date added | Times worn | Notes
In Google Sheets, select the cell, then use Data → Split text to columns and choose a custom separator of |. In Excel, use Data → Text to Columns with the same separator.
Useful formulas for your wardrobe inventory excel or Sheets file
| What you want | Formula |
|---|---|
| Total items | =COUNTA(A2:A) |
| Items per category | =COUNTIF(B:B,"Tops") |
| Items that don't fit | =COUNTIF(F:F,"N") |
| Never-worn items | =COUNTIF(I:I,0) |
| Most-worn item | =INDEX(A:A,MATCH(MAX(I:I),I:I,0)) |
Add a second tab called "Summary" with these formulas and you've got a tiny wardrobe dashboard.
Know what you wear, not just what you own
A wardrobe inventory spreadsheet template shows everything in your closet; WORN is being built to show which of those pieces you actually wear, from one photo a day, with photos private by default. Join the waitlist with your email in under a minute. It's for ages 13 and up and only gets built if enough people sign up.
FAQ
How do I make a wardrobe inventory?
Open a spreadsheet, add columns for item, category, color, season, fit and notes, then go through your closet one category at a time, adding a row per piece. Skip photos at first to save time. Most closets take an hour or two.
Is there a free wardrobe inventory spreadsheet template?
Yes, copy the header row above into Google Sheets or Excel and split it into columns. It's built for a personal closet rather than a store. Add the formula tab for quick totals.
What should be on a clothing inventory list?
Each piece's name, category, color, season, whether it fits and where it's stored. A times-worn column is optional but shows which pieces you actually use. A "gone" column helps track what leaves.
Should I include photos in my closet inventory spreadsheet?
Not at first. Photos slow the process down a lot, and good item names usually do the job. Add images later only for pieces where a name isn't clear enough.
Is there a wardrobe inventory app instead of a spreadsheet?
Several closet apps exist, but most ask you to photograph and tag every item first. WORN is a planned outfit diary, currently a waitlist, that would skip cataloguing and learn what you wear from one photo a day.