You’re about to check out on a pair of Dunks and stop: don’t you already own that colorway? The answer is somewhere in a stack of boxes in the closet, and opening them all is not happening. The bigger a collection gets, the harder it is to keep track of from memory.
This guide covers how to catalog a sneaker collection: which columns you need, rules that keep the data clean, how to split it across sheets, and how to get started without entering everything in one sitting. It works in Google Sheets, Excel or a paper notebook.
It is written by the developer of KickRota, an iPhone app that records the same details for each pair (view on the App Store).
What this guide covers
- Which columns you need, depending on what the catalog is for
- A column template you can copy (essential and optional)
- How to record style codes, condition (DS and VNDS) and sizes
- Why wears, care and wishlist belong on separate sheets
- How to catalog a big collection in manageable chunks
Copy this: essential columns with an example row
Here is the template up front. Select and copy the table below, paste it into your spreadsheet, and it lands in separate columns. Row 2 is an example; delete it before you start.
| Brand | Model | Colorway | Nickname | Size | Condition | Role | Photo file name |
|---|---|---|---|---|---|---|---|
| Nike | Air Max 1 | Anniversary Red | Red Maxes | 10 | Worn | Rotation | nike_airmax1_anniversaryred.jpg |
The rest of this guide explains each column and the optional ones worth adding.
Start with what the catalog is for
Decide what you will use the catalog for before you build columns. It keeps the sheet from growing more columns than you’ll ever fill.
| Goal | Columns that matter most |
|---|---|
| Never buy the same pair twice | Brand, model, colorway, photo |
| Sell or trade without scrambling | Style code, size, condition, purchase date, price, extras |
| Find a pair in the box stack | Storage location, photo |
| Actually wear what you own | Role (Rotation, Keep, Retired), wear log |
If you only have one goal, start with those columns. Adding a column later is easy; too many columns can make the first round of setup hard to finish.
The column template
Essential columns
| Column | Example | Notes |
|---|---|---|
| Brand | Nike | Pick one spelling (see the rules below) |
| Model | Air Max 1 | Include the line and any retro detail, such as ’86 |
| Colorway | Anniversary Red | Official name if you know it; otherwise describe the colors |
| Nickname | Red Maxes | A name no other pair shares; used to refer to the pair in your wear and care logs |
| Size | 10 | Pick US men’s, US women’s or EU and stay consistent |
| Condition | Worn | DS, VNDS or Worn |
| Role | Rotation | Rotation, Keep or Retired |
| Photo file name | nike_airmax1_anniversaryred.jpg | Links the photo to the row |
Optional columns
| Column | Example | Notes |
|---|---|---|
| Style code | e.g. AB1234-100 | Printed on the box label |
| Purchase date | 2026-04-12 | Useful for resale and warranty |
| Price | 140 | Numbers only, no $ sign |
| Purchased from | Nike app | Store or site |
| Storage location | Closet, top shelf, left | Cuts down on box digging |
| Release date | 2026-03 | Helps separate retros and limited releases |
| Extras | Spare laces, tags | Check before you sell |
| Notes | Avoid in rain | Anything else |
Matching your photo file names to your columns (brand, style, colorway and so on) makes it easy to connect each photo to its row[2].
Data entry rules that keep the sheet usable
Inconsistent naming makes a catalog harder to sort and filter. Once the same thing is written several ways, sorting and filtering stop working.
- One spelling per brand. “Nike”, “NIKE” and “nike” should not all appear. In Google Sheets or Excel, use data validation (a dropdown) so brand is picked from a list
- One size system. Mixing US and EU sizes makes comparisons impossible. If you want both, use two columns
- Numbers only for prices. “$140.00 USD” can’t be added up. Enter 140 and format the column as currency
- One date format. Use a format your spreadsheet recognizes as a date, such as 2026-04-12
- Dropdowns for condition and role. Limit these to the values you’ve defined
Finding the style code
The style code is the number the manufacturer assigns to a product. It appears on the box label alongside the size[1]. It helps tell similar-looking pairs apart, so note it down while you still have the box.
Recording condition: DS and VNDS
| Term | Meaning | When to use it |
|---|---|---|
| DS (deadstock) | Brand new and unworn; on StockX, that includes the original box[1] | Never worn. If you might sell, also note whether the box and extras are complete |
| VNDS (very near deadstock) | Used in this guide to mean “almost new” | Definitions vary between people and platforms, so set your own rule |
| Worn | Regular wear | Everything else |
Because VNDS has no single definition, write your own rule in a note at the top of the sheet, such as “tried on indoors only” or “worn outside three times or fewer”, and apply it consistently.
Split it into sheets: pairs, wears, care, wishlist
Adding everything to one sheet produces a very wide table that is hard to read. Anything that happens repeatedly should go on its own sheet, one row per event.
| Sheet | Each row represents | Columns |
|---|---|---|
| Pairs | One pair | The template above |
| Wears | One day worn | Date, pair name, note |
| Care | One care session | Date, pair name, type (cleaning, waterproofing, etc.), cost |
| Wishlist | One pair you want | Brand, model, colorway, target price, note |
For the pair name on the Wears and Care sheets, use the Nickname column and make sure no two pairs share one (add “(pair 2)” if you own two identical pairs). Type it exactly as it appears on the Pairs sheet. Then COUNTIF and SUMIF on the Pairs sheet can total wears and care costs for every pair automatically. For the formulas that turn those totals into cost per wear, see sneaker cost per wear. To use your wear log to decide what to wear next, see how to build a sneaker rotation.
Getting started: don’t enter everything at once
With a big collection, the first round of data entry is the hardest part.
- Put all your pairs in one place and group them by brand, then by model[2]
- Catalog one brand or one model per session[2]
- Photograph each pair sitting on its box. A side-on or angled shot is enough[2]. Using the same angle every time makes pairs easier to compare
- Rename each photo to match your columns[2]
- Label each box with the pair’s name using a marker or sticker[2]
- Fill in the essential columns first and come back for the optional ones
After that, update the catalog right away whenever you buy, sell or trade a pair[2]. That habit is what keeps it accurate.
Paper vs. spreadsheet vs. app
| Paper notebook | Spreadsheet | Collection app | |
|---|---|---|---|
| Getting started | Immediate | Some setup | Depends on the app |
| Sort and search | No | Yes | Yes |
| Photos | Print and paste | Link by file name or insert images | Depends on the app |
| Counts and totals | By hand | Automatic once formulas are set | Depends on the app |
| On your phone | Carry the notebook | Through the spreadsheet app | Yes |
Which one fits depends on how many pairs you have and what you want from the catalog. A short list is fine on paper. If you want sorting and totals, use a spreadsheet. If you also want to log what you wear every day without building formulas, a collection app is an option.
If you’re using a paper notebook
Split the notebook into three parts so you can keep adding to it:
- First section: one line per pair. Number, brand, model, colorway, size, condition, role, storage location
- Middle section: wear log. One line per day with the date and the pair’s number
- Last section: care log. Date, pair number, what you did, cost
Linking everything by number means you never have to write out a pair’s full name again. Write the same number on the box and finding it in the stack gets easier too.
Cataloging with KickRota
KickRota records nearly the same fields as this template on your iPhone.
- Fields: brand, model, colorway, nickname, size, style code, release date, condition (DS, VNDS, Worn), price, purchase date, purchased from, storage location, spare count, story and tags
- Add with just a photo or a name: only one of the two is required; fill in the rest later
- Roles: set Rotation, Keep or Retired. KickRota suggests a pair from your rotation each morning
- Photo album: keep several photos for each pair
- Search and sort: search, tags, and seven sort orders (recently worn, longest unworn, most worn, lowest cost per wear, purchase date, price, name)
- Wears, care and wishlist: wears and care are linked to each pair, and the wishlist is its own list (tap Got it to move a pair into your collection)
KickRota can’t import from or export to a spreadsheet. For moving to a new phone, it exports and imports a ZIP backup that includes your photos.
Every feature is free. The free version holds up to 15 pairs (Rotation, Keep and Retired combined; wishlist items don’t count). KickRota Pro, a one-time purchase, removes the limit and the watermark on share cards. Your data stays on your iPhone, and no account is needed.
View KickRota on the App Store
Summary
- Decide what the catalog is for (avoiding duplicates, selling, finding, wearing) before adding columns
- Essential columns: brand, model, colorway, a unique nickname, size, condition, role and photo file name
- Fix brand spelling, size system and price format up front, and use dropdowns to enforce them
- Keep wears, care and wishlist on separate sheets, one row per event
- Enter your collection one brand or model at a time
Sources
- StockX, “How to Follow StockX’s Condition Requirements for Sneaker Boxes” (deadstock condition; size and style code on the box label) https://stockx.com/news/how-to-follow-stockxs-condition-requirements-for-sneaker-boxes
- Sneaker Freaker, “How to Catalogue Your Sneaker Collection” https://sneakerfreaker.com/features/how-to-catalogue-your-sneaker-collection
(All checked October 26, 2026)
This article organizes information from a recording and organizing perspective. If you notice an error or outdated information, please contact us. Last verified: October 2026

