I track my wardrobe inventory and log my outfits using Airtable, which is a free (with paid tiers) and very easy to use web app (with mobile app) that’s a combination spreadsheet and relational database. You can view the schema I use and copy the template here. Scroll down to see screenshots of more mobile and desktop views of the tracker.
If you decide to sign up for Airtable, you can use my referral link which will give me a few Airtable credits at no cost to you. Otherwise, you can sign up through the non-referral template link in the previous paragraph or simply at https://airtable.com/. I am not partnered with Airtable and otherwise do not receive any money for plugging it. I’m just sharing because I have personally found it a very useful service.
What’s in my closet?
See items I’ve worn recently including brands and wear counts at the following links (I would embed these directly on this page, but I’m on a WordPress plan that doesn’t support plugins). These views are easier to work with on desktop, where you can zoom in and out of the browser to adjust how many tiles you can see at once. (hold down cmd or ctrl key while then hitting the + or – key)
- Clothing and accessories worn in the past 30 days
- Just clothing worn in past 30 days
- A spreadsheet-like view of my Current Wardrobe items
- Item Gallery All items, which you can filter manually by category, tag, etc.
All About Airtable
I like it because I can easily log outfits from the mobile app, and then do planning/evaluation of my wardrobe from a large view in a desktop browser where I can easily filter and sort things to visualize them. It helps me do things like
- come up with new ideas for outfits by seeing items of a similar style in one view
- plan for a trip by seeing all items that are good for certain temperature ranges
- find items that I’ve only worn a handful of times in the past year and may be good candidates for donation if I didn’t even like any of the associated outfits with them
- identify ‘wardrobe holes’ or things I should try wearing more by viewing items by category and sorting by wear counts
- filter to view outfits that I particularly liked or didn’t like and look for patterns of items, colors, and styling details
I wrote a whole post about Wardrobe Inventory and Outfit Logging Methods, including some simpler ones (not everyone should want to be this involved with their own wardrobe 🙃). If you’re considering starting some sort of outfit or item log but aren’t sure where to start, check it out! I also have some Google Sheets templates for wardrobe tracking there.
I do a “wardrobe round-up” every month where I go over wear counts, purchases, purged items, and favorite outfits. The posts are filed under the Wardrobe Tracking category.
This version of the database was started in January 2018, although I’ve been tracking in some form or another since the latter part of 2016.
I haven’t totally filled out all of the fields. The base includes a lot of fields because I figured there’s a wide variety of things people could be interested in tracking, but personally I’m more interested in an easy way to track and visualize wear count and outfit type, not optimizing cost-per-wear or tracking item sizes. If you have questions about sizing or quality on a particular item, feel free to contact me (Instagram DM is probably fastest) and I will do my best to answer.
These read-only views are easier to work with on desktop, where you can zoom in and out of the browser to adjust how many tiles you can see at once. (hold down cmd or ctrl key while then hitting the + or – key). Note that in not read-only views, the UI is richer and you can jump to linked records across tables which is really handy. Unfortunately I don’t think there’s a way to share a whole base with those links working in read-only mode.
- Outfits Gallery
- Item Gallery
- A spreadsheet-like view of my Current Wardrobe items including fields for
- general notes
- temperature bucket(s) it’s suited for
- various wear count statistics (per month and year, wear rate, cost-per-wear)
- various fields for ease of filtering items (style category, whether it was worn in the past 30 days, whether it’s an accessory or clothing item, etc)
Please note that Airtable’s free tier has a limit of 1,200 records and 2GB of attachments per base, so you won’t be able to use the same base indefinitely without upgrading. Their lowest non-free tier is at the time of writing $10 or $12 per month. I do literally use it every day so there’s certainly an argument for coughing up, but at the same time I’m calibrated to google sheets being free and Netflix being $8/month ($4 since I share with my boyfriend) so that pricing scheme just seems a bit much. However, you can have unlimited bases, so you can always duplicate an existing base and keep the previous year’s worth of outfits with it, clearing out old outfits and records of items that were donated/sold/thrown out (that’s what I do).
If you’re interested in a spreadsheet-only version with similar functionality, you can find a copy of a google sheet I made over at the OG Wardrobe Inventory and Outfit Logging Methods post.
Sample view of adding an outfit on the Airtable mobile app
A gallery view on desktop browser
Handy for pulling up all outfits with a particular item like “midi skirts”, or with any tag
Spreadsheet-style view on desktop browser
Spreadsheet-view on mobile app (requires a lot more scrolling, but it’s there)
View of item entry for the “fallen petals” earrings above