Capsule Wardrobe Spreadsheet Template (Free to Copy)

7 min read · WORN

A capsule wardrobe spreadsheet template is a simple sheet with one row per piece of clothing and columns for category, color, season, fit and how often you wear it, plus a second tab that maps outfits. Copy the free template below into Google Sheets or Excel, fill it in over about 30 minutes, and you will see your duplicates, your gaps and your real favorites on one screen.

If the hard part for you is knowing how often you actually wear each piece, WORN is being built to fill in that column for you from one photo a day: Start my outfit diary

What the capsule wardrobe spreadsheet is for

A wardrobe spreadsheet is not homework. It is a map. Most people have a rough picture of their closet in their head, and that picture is usually wrong in two ways: we think we own fewer things than we do, and we think we wear more of them than we do.

A good capsule wardrobe spreadsheet answers three questions:

1. What do I own? A full clothing inventory, not a guess.
2. What goes with what? Which tops work with which bottoms and shoes.
3. What is missing or doubled? Three nearly identical black tees and zero jackets that fit, for example.

You will see a lot of wardrobe spreadsheet Reddit threads where people share giant sheets with 30 columns, formulas and charts. Those are fun, but they are also why people quit on day two. The free capsule wardrobe template here keeps only the columns that change a decision.

The columns you need

Here is the whole wardrobe spreadsheet template. Make one tab called Pieces and paste these headers into row 1.

Optional columns (only if you like numbers)

• Price paid, then a cost per wear column: price divided by times worn. A cost per wear spreadsheet is a great reality check before shopping.
• Pairs with, a short list of item names.
• Photo link, if you keep closet photos in a folder.

That is it. If you have seen a capsule wardrobe Notion template or a paid Etsy capsule wardrobe planner, they are mostly these same columns with nicer colors.

How to fill in your wardrobe spreadsheet in 30 minutes

Set a timer. Speed beats perfection here.

1. Minutes 0-5: pull out one category. Start with tops, since there are usually the most.
2. Minutes 5-15: type fast. One row per item. Item, category, color, season. Skip fit and notes for now.
3. Minutes 15-22: bottoms, layers, shoes. Same fast rows.
4. Minutes 22-27: fit scores. Go down the list and give each piece a 1, 2 or 3 from memory. If you hesitate, it is probably a 2.
5. Minutes 27-30: the honest column. Mark "Worn last 30 days?" for each row.

Leave underwear, socks, sleepwear and gym clothes out unless you want a complete wardrobe inventory list. Most capsule wardrobe checklist methods, including Project 333, skip them anyway.

Using it as a Project 333 template

Project 333 is a well-known challenge from Courtney Carver: 33 items, including shoes and accessories, for three months. To turn this sheet into a Project 333 template, add a column called In the 33? and filter for "Yes." When the filter shows 33 rows, your Project 333 wardrobe list is done.

Map outfits from your pieces

Now make a second tab called Outfits. This is your outfit planner spreadsheet.

Put your bottoms down column A and your tops across row 1. In each cell where the pair works, type an "x" (or the shoes that finish the look). You now have an outfit combinations chart.

A quick example with a small capsule:

• Bottoms: dark jeans, black joggers, khaki pants
• Tops: white tee, gray hoodie, striped long sleeve, navy sweater

That is 12 possible pairs. If 10 of them get an "x," your capsule mixes well. If only 4 do, one or two pieces are fighting the rest, and the sheet just told you which.

A tip for the outfit tab

Count the x's per row and per column. A top with zero x's is a top that has no job in your closet. A bottom with x's in every column is a hero piece, and the first thing you should replace when it wears out.

Spot gaps and duplicates

Sort the Pieces tab by Category, then by Color. Duplicates jump out right away: five gray tops in a row is hard to miss.

Then filter "Worn last 30 days?" to No. This is the part most people find uncomfortable, and it is also the most useful. Here is where a spreadsheet alone gets tricky, though. That column depends on your memory, and memory is generous. You remember the cute outfit from two weeks ago. You forget you wore the same hoodie four days running.

WORN is being built to take the guessing out of that column. You take one photo a day of what you actually wore, one tap, no tagging. After a month it reads back which few pieces you really wear and which ones you never touch, so your "Keep?" decisions come from evidence instead of memory. Start my outfit diary

Once you trust the data, gaps are easy to read:

• Many tops, few bottoms? Most outfits will fail on the bottom half. That is a gap.
• All cold-weather layers score 1 on fit? You need one good jacket, not three more tees.
• A color with only one piece? It probably matches nothing. Mark it Maybe.

If you are building a list for school, the same method works for a smaller closet. See our back to school capsule wardrobe on a budget guide for how to turn the gap list into a cheap shopping list.

Copy the free capsule wardrobe spreadsheet template

You do not need to download anything. Open a blank Google Sheet or Excel file and paste this row into A1 of a tab named Pieces:

Item | Category | Color | Season | Fit (1-3) | Worn last 30 days? | Times worn | Keep? | Notes

(In Sheets, paste it, then use Data > Split text to columns with "|" as the separator.)

Then add a tab named Outfits with bottoms down column A and tops across row 1. Add a third tab called Gaps with just two columns: "What's missing" and "Why." That is the entire free capsule wardrobe template.

A few settings that make it nicer:

• Add a dropdown (data validation) on Category, Season and Keep? so spelling stays consistent.
• Use conditional formatting to shade "No" in the worn column light red.
• Freeze row 1 so headers stay visible.

Want to know how many rows you should end up with? Our post on how many clothes you actually need gives a formula based on your laundry schedule.

Fill the capsule wardrobe spreadsheet with real data

A capsule wardrobe spreadsheet template is only as good as the "worn" column, and that is the column people guess. WORN is a waitlist for a private outfit diary: one photo a day, no cataloguing your wardrobe first, and after a month a readback of what you really wear. Photos stay private by default and can be deleted in one action. Joining takes an email and less than a minute.

Start my outfit diary

FAQ

Is there a free capsule wardrobe spreadsheet template for Google Sheets?

Yes, the one on this page. Paste the header row into a blank Google Sheet, split it into columns, and add the Outfits and Gaps tabs. It works the same way in Excel or Numbers.

What should a wardrobe spreadsheet include?

At minimum: item name, category, color, season, fit score and whether you wore it in the last 30 days. Times worn and price paid are useful extras if you want cost per wear.

How do I make a Project 333 wardrobe list in a spreadsheet?

Add an "In the 33?" column to your clothing inventory and mark Yes on the pieces you choose, including shoes and accessories. Filter by Yes, and when you have 33 rows, that is your list for the next three months.

Is a capsule wardrobe Notion template better than a spreadsheet?

Neither is better, they just feel different. Notion is nicer for photos and galleries, while a spreadsheet is faster for sorting, counting and outfit grids. Pick the one you will actually open again next month.

How often should I update my wardrobe tracker?

A quick update when you buy or remove something, and a full review once a season. If you track times worn, a daily entry is the most accurate, which is exactly the habit a one-photo-a-day diary is meant to make easy.