Wardrobe Audit Template: Free Sheet to Copy

6 min read · WORN

A wardrobe audit template is a simple sheet with one row per piece of clothing and columns for category, color, fit, condition, times worn and a keep/maybe/let-go verdict. The free version below is ready to copy into Google Sheets, Excel, Numbers or even a notes app, with nothing to buy. Its most important column is "times worn," which most paid templates leave out.

If you'd fill in a template but have no idea what numbers go in the "times worn" column, WORN is being built to count them for you from one photo a day: Start my outfit diary

What the template tracks

A lot of wardrobe audit templates for sale are really just lists: item, color, maybe a photo. That's an inventory, which is useful, but it doesn't help you decide anything.

This template tracks four things that lead to a decision:

• What it is (so you can find it and group it)
• How it fits and holds up (so you know if it's wearable)
• How often you actually wear it (so you know if it earns its place)
• What you decided (so the audit ends in action)

If you just want a full record of everything you own, the wardrobe inventory spreadsheet is built for that. This one is for making decisions.

Columns explained

Here's the free wardrobe audit template. Copy the header row into a new sheet.

What each column means

• Item: a short name you'll recognize. "Blue straight jeans," not "jeans #3."
• Category: top, bottom, layer, one-piece, shoes, accessory. Keep it to six or so.
• Color: the main color. This shows your real palette at a glance.
• Fits? (Y/N): does it fit today? No "almost."
• Condition (1-3): 3 = great, 2 = worn but fine, 1 = damaged.
• Times worn: how many times you wore it during your logging period. The key column.
• Last worn: a rough date, or "unsure." A lot of "unsure" answers tell you something.
• Verdict: keep, maybe or let go.
• Notes: why. "Scratchy," "only works with one top," "need a belt."

Optional columns

Add these only if you'll use them:

• Season (summer, winter, all year)
• Cost (for a cost-per-wear column: cost ÷ times worn)
• Photo link (if you like visuals)

How to fill it in one afternoon

You can set up the whole closet audit spreadsheet in an afternoon. Here's the order that keeps it fast.

1. Set up the header row (5 minutes). Copy the columns above. Freeze the top row.
2. Go category by category (1-2 hours). Start with bottoms; there are fewer. Then tops, layers, shoes.
3. Fill in Item, Category, Color, Fits and Condition as you hold each piece. Leave Times worn and Verdict blank for now.
4. Take a break. You've just built a wardrobe inventory list, which is already more than most people have.
5. Fill Times worn once you have data (see the next section).
6. Fill Verdict last, after you can see the numbers.

Speed tip: use a dropdown for Category and Verdict (Data → Data validation in Google Sheets). It stops typos and makes sorting easier later.

Adding wear counts

This is where most wardrobe audit worksheets fall apart. Everything else you can fill in by looking at the clothes. Times worn needs a record over time.

Three ways to get your times worn numbers

1. Log forward (most accurate). For two to four weeks, add a tally to the Times worn column each day for every piece you wore. At the end, the numbers are real.

2. Hanger trick (easiest). Turn every hanger backwards. When you wear something, hang it back the right way. After a month, backwards = 0 wears. It doesn't give exact counts, but it catches the zeros.

3. Estimate (fastest, least reliable). Guess from memory. Be aware most people overestimate the pieces they love and underestimate everyday basics.

Logging every piece, every day, into a spreadsheet is the part nobody keeps up. WORN is being built to do it with one tap: one photo a day of what you actually wore, no tagging, no cataloguing your wardrobe first. After a month it reads back which pieces you really wear and which you never touch, so your times-worn column finally has real numbers behind it. Start my outfit diary

Reading the results

Once Times worn is filled in, sort by that column (highest first). Your wardrobe audit results will usually show a clear shape.

What to look for

• The top of the list: a handful of pieces with high counts. These are your real wardrobe. Protect them, and replace them when they wear out.
• The middle: pieces worn once or twice. Check the Notes column. Is there a fixable reason (needs a belt, needs a matching top)?
• The bottom: zeros. Filter for Times worn = 0 and Fits = N. That's your easiest let-go list.

Quick formulas that help

• Count per category: =COUNTIF(B:B,"Top")
• Total wears: =SUM(F:F)
• Never-worn items: =COUNTIF(F:F,0)
• Cost per wear: =IFERROR(J2/F2,"") (if you added cost in column J)

Turning results into verdicts

A simple rule: worn = keep, fits but unworn = maybe, doesn't fit or damaged = let go. Then adjust by hand for seasonal and sentimental pieces. If you want more detailed wardrobe audit questions for tricky items, run them through the closet audit checklist.

After a few audits, many people notice a small group of pieces doing most of the work. If that sounds familiar, the 80/20 rule wardrobe post explains how to measure it properly.

Copy the wardrobe audit template

Here's everything in one block. Paste it into the first row of a new Google Sheet or Excel file; each | becomes a column when you use Data → Split text to columns with a custom separator.

Item | Category | Color | Fits? (Y/N) | Condition (1-3) | Times worn | Last worn | Verdict | Notes

That's your free wardrobe audit template. Duplicate the sheet each season and name the tabs "Spring 2026," "Fall 2026," and so on, so you can compare how your wear counts change.

Get real numbers in your times-worn column

Any wardrobe audit template is only as good as its wear counts, and WORN is being built to gather them for you from one photo a day and read back your month: most-worn, never-worn, and tomorrow's outfit from clothes you own. Joining the waitlist takes one email. It's for ages 13 and up and only gets built if enough people sign up.

Start my outfit diary

FAQ

What should a wardrobe audit template include?

At minimum: item name, category, color, fit, condition, times worn and a verdict. Times worn is the column that turns a list into a decision. Notes help you remember why you decided what you did.

Is there a free wardrobe audit template for Google Sheets?

Yes, copy the header row above into a new Google Sheet. It works the same in Excel or Numbers. Add dropdowns for Category and Verdict to keep it tidy.

What's the difference between a wardrobe audit template and a wardrobe inventory template?

An inventory template lists what you own. An audit template adds wear counts and a keep/maybe/let-go verdict, so it helps you decide what to do. Many people start with an inventory and add the audit columns later.

Is there a wardrobe audit app?

Some closet apps let you catalogue items, but that usually means photographing every piece first. WORN is a planned outfit diary, currently a waitlist, that would skip the cataloguing and learn what you wear from one photo a day.

How do I count how many times I wear each item?

Log forward for two to four weeks, adding a tally each day for what you wore. The hanger trick is a quicker way to spot the zeros. Estimating from memory is fastest but least reliable.