Outfit Tracker Spreadsheet: A Free Template and Setup
An outfit tracker spreadsheet is a simple sheet where you list your clothes, log what you wear each day, and let formulas count how many times you've worn each piece. You can build one in Google Sheets or Excel in about 30 minutes with two tabs and a few formulas. Below is the exact setup, column by column, so you end up with a free outfit tracker template that does the math for you.
If your real problem is wanting wear counts without typing every item into a sheet, WORN is being built to give you those counts from one photo a day, so join the waitlist: Start my outfit diary
What an outfit tracker spreadsheet does
A good wardrobe spreadsheet answers four questions automatically:
- How many times have I worn each piece? (wear count)
- When did I last wear it? (last worn date)
- What did it cost me per wear? (cost per wear tracker)
- What have I never worn? (the "ghost" list)
People on Reddit who share their wardrobe spreadsheets often mention the same surprise: once the counts are there in black and white, it's obvious which clothes do the real work.
We'll use Google Sheets for the examples because it's free and works on your phone. Every formula here also works in Excel 365, with one note below.
Set up the columns
You need two tabs. Rename them at the bottom of the sheet to Closet and Log.
Tab 1: Closet (your wardrobe inventory spreadsheet)
One row per item. Give each item a short, unique name you'll recognize, like "black jeans" or "green hoodie."
| Column | Header | What goes in it |
|---|---|---|
| A | Item | Short unique name, e.g. "gray tee" |
| B | Category | Top, bottom, shoes, layer, dress, accessory |
| C | Color | Black, blue, white, etc. |
| D | Price | What you paid (leave blank if unknown or a gift) |
| E | Wears | Formula (below) |
| F | Cost per wear | Formula (below) |
| G | Last worn | Formula (below) |
| H | Days since worn | Formula (below) |
Tip: don't list underwear, socks or pajamas. You'll never finish, and they don't tell you much.
Tab 2: Log (your daily outfit tracker)
One row per day.
| Column | Header | Example |
|---|---|---|
| A | Date | 9/27/2026 |
| B | Top | gray tee |
| C | Bottom | black jeans |
| D | Shoes | white sneakers |
| E | Layer | green hoodie |
| F | Notes | "presentation day" |
Add dropdowns so names always match
This is the step that makes or breaks your clothes tracker spreadsheet. If you type "grey tee" one day and "gray t-shirt" the next, the counts break.
In Google Sheets:
- Select Log columns B through E (from row 2 down).
- Go to Data > Data validation > Add rule.
- Choose Dropdown (from a range) and enter
Closet!A2:A.
Now every cell is a dropdown of your own clothes. In Excel, it's Data > Data Validation > List with the same range.
Formulas that count wears
Paste these into row 2 of the Closet tab, then drag them down to the bottom of your list.
Wear count (column E)
=COUNTIF(Log!B:E, A2)
This counts how many times the item name appears anywhere in the Top, Bottom, Shoes or Layer columns.
Cost per wear formula (column F)
=IF(OR(D2="", E2=0), "", D2/E2)
Price divided by wears. It stays blank until an item has a price and at least one wear. Format the column as currency.
Last worn (column G)
=IFERROR(MAX(FILTER(Log!A:A, (Log!B:B=A2)+(Log!C:C=A2)+(Log!D:D=A2)+(Log!E:E=A2))), "")
This finds the latest date the item appears in any column. Format column G as a date. (FILTER works in Google Sheets and Excel 365, but not in older Excel versions.)
Days since worn (column H)
=IF(G2="", "", TODAY()-G2)
Two bonus views
Make a third tab called Results and add:
- Most worn, sorted:
=SORT(FILTER(Closet!A2:E, Closet!A2:A<>""), 5, FALSE) - Never worn:
=FILTER(Closet!A2:A, Closet!A2:A<>"", Closet!E2:E=0)
That's your whole outfit tracker in Google Sheets.
Logging in under a minute
A wardrobe tracker only works if you fill it in. Keep it fast:
- Pin the sheet to your phone's home screen. Open the Google Sheets app, open the file, and add a shortcut if your phone supports it.
- Log at the same time every day, like right after school or before bed.
- Use Ctrl+; (Cmd+; on Mac) in the date cell to insert today's date. On mobile, type it.
- Pick from the dropdowns. Four taps, done.
- Leave cells blank if you didn't wear a layer. Blanks are fine.
Weekly catch-up
Missed a few days? Scroll your camera roll on Sunday and fill them in from any photos you took. That's also why many people pair a spreadsheet with a quick outfit photo each morning. For a comparison of logging styles, see how to keep track of outfits.
Reading your results
After 30 days of logging, open your Results tab and look for:
- Your top 10. These are your real wardrobe. Build outfits around them.
- Zero-wear items. Were they out of season? If not, why are you skipping them?
- Low cost per wear. These were your best buys. Buy more things like them.
- High cost per wear. Pricey pieces you rarely wear. Wear them more, or learn from them before your next purchase.
- Days since worn over 60. Candidates to donate, sell or pass on.
For a deeper guide to what these numbers mean, read how to see what clothes you wear most.
When a spreadsheet gets old
Here's the honest truth about any outfit tracker template: the spreadsheet is the easy part. Entering your whole closet, keeping names consistent and logging every day is where most people quit. By week three, the Log tab has gaps, and the counts stop meaning much.
Signs your wardrobe spreadsheet has run its course:
- You've missed more days than you've logged.
- You bought new clothes and never added them to the Closet tab.
- You dread opening it.
WORN is being planned for exactly this moment. Instead of listing your closet and filling in rows, you take one photo a day with one tap. There's no tagging and no cataloguing your wardrobe first. After a month, WORN reads back the few pieces you really wear, the ones you never touch and an outfit for tomorrow from clothes you already own. Join the waitlist: Start my outfit diary
Spreadsheet vs Notion vs app
| Option | Best for | Downside |
|---|---|---|
| Google Sheets | Free, formulas, phone access | Manual entry every day |
| Excel | People who already use it | Older versions lack FILTER |
| Notion | Pretty databases with photos | Slower to set up and log |
| Outfit diary app | Less typing | Most need a full closet setup first |
If an outfit tracker Notion setup appeals to you, it's the same idea: one database for clothes, one for daily logs, linked by a relation. It just takes longer to build.
Skip the rows, keep the answers
WORN is a waitlist right now, and it's built only if enough people sign up. The plan swaps the spreadsheet for one photo a day, with your wear patterns read back after a month. Photos are private by default and you can delete them in one action. It's a one-time payment, and signup takes just your email.
FAQ
How do I make an outfit tracker spreadsheet in Google Sheets?
Create a Closet tab listing your clothes and a Log tab with one row per day. Add dropdowns so item names match, then use =COUNTIF(Log!B:E, A2) on the Closet tab to count wears for each item.
Is there a free outfit tracker template?
You can build a free outfit tracker template yourself in about 30 minutes with the columns and formulas above. Copying the layout means you're not relying on a paid download.
What is the cost per wear formula in Excel?
Divide the price by the number of wears: =D2/E2. Wrap it in an IF to avoid dividing by zero: =IF(OR(D2="", E2=0), "", D2/E2).
Does an outfit tracker spreadsheet work in Excel?
Yes. COUNTIF, IF and data validation all work in every modern version of Excel. The FILTER and SORT formulas need Excel 365 or Excel 2021 or later.
What should a wardrobe spreadsheet include?
At minimum: item name, category, color, price and a wear count. Last worn date and cost per wear make it much more useful for decluttering and shopping decisions.