How to Catalog Your Sneaker Collection: A Spreadsheet Column Template and Data Entry Rules

KickRota

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.

  1. Put all your pairs in one place and group them by brand, then by model[2]
  2. Catalog one brand or one model per session[2]
  3. 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
  4. Rename each photo to match your columns[2]
  5. Label each box with the pair’s name using a marker or sticker[2]
  6. 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:

  1. First section: one line per pair. Number, brand, model, colorway, size, condition, role, storage location
  2. Middle section: wear log. One line per day with the date and the pair’s number
  3. 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

  1. 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
  2. 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

Copied title and URL