YouLookFab Forum » Topic: creating a spreadsheet to keep track of what you wear

YouLookFab Forum » Topic: creating a spreadsheet to keep track of what you wear https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear Style Advice for Fashion Lovers en-US Thu, 16 Apr 2026 12:09:55 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q https://youlookfab.com/welookfab/search.php Anonymous on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-2233315 Thu, 21 Oct 2021 14:38:28 +0000 Anonymous 2233315@https://youlookfab.com/welookfab/ Please remove my comment from 9 years ago. Thank you Tai on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-2107096 Thu, 19 Mar 2020 20:44:07 +0000 Tai 2107096@https://youlookfab.com/welookfab/ I would love to have a copy of this spreadsheet. Can you email it to me at taiablas@gmai l.com christopher5610 on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-1026456 Wed, 11 Sep 2013 05:03:37 +0000 christopher5610 1026456@https://youlookfab.com/welookfab/ Can you send me your template for keep track of what you wear? rachelnator on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-949281 Wed, 05 Jun 2013 21:37:16 +0000 rachelnator 949281@https://youlookfab.com/welookfab/ Glad I could help!  I'm hoping this weekend I'll actually go through all my items & log them. Right now I'm just logging as I wear them, which has actually encouraged me to wear some things I haven't worn in months! Gabrielle on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-949278 Wed, 05 Jun 2013 21:36:11 +0000 Gabrielle 949278@https://youlookfab.com/welookfab/ I think it will be interesting to see how my wardrobe evolves as I recognize pieces that I wear and those that never get taken out of the closet.  Hopefully, I will start wearing more of the special clothes I am "saving" for some nameless event.  Again, thank you.   Gabrielle on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-949272 Wed, 05 Jun 2013 21:34:00 +0000 Gabrielle 949272@https://youlookfab.com/welookfab/ This is really helpful.  Thank you so much.  I will start on this project this coming weekend.   rachylou on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-949123 Wed, 05 Jun 2013 18:16:55 +0000 rachylou 949123@https://youlookfab.com/welookfab/ Oh, great example! I see how layer is used now. Love that you filled in with actual colour in the cells. Seriously appreciate the work. I am going to try out your spreadsheet now rachelnator on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear/page/2#post-948772 Wed, 05 Jun 2013 05:51:29 +0000 rachelnator 948772@https://youlookfab.com/welookfab/ <a rel="nofollow" href="http://i.imgur.com/Jv8Mut4.png">http://i.imgur.com/Jv8Mut4.png</a> Here's some of what I have so far, so you can get an idea of what it will look like. The ones w/#NUM! haven't been worn yet, but were items I added while at work And if anyone needs help figuring out how to update any fields just let me know. I'll do a screen recording so you can get a walk through. rachelnator on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-948770 Wed, 05 Jun 2013 05:44:19 +0000 rachelnator 948770@https://youlookfab.com/welookfab/ Just an outer layer, but not a coat. It's rare for me to just wear a top (I have an indecent amount of cardigans...) But feel free to adjust it as you see fit! That's the best part about this.  rachylou on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-948492 Tue, 04 Jun 2013 22:54:16 +0000 rachylou 948492@https://youlookfab.com/welookfab/ Oh my goodness! Bless your soul! This is great. I'm even a technical writer, but just folded at the thought... lol. Out of curiosity, what do you mean by layer? rachelnator on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-948430 Tue, 04 Jun 2013 21:22:06 +0000 rachelnator 948430@https://youlookfab.com/welookfab/ I recently found this thread thanks to some googling & thought I'd share my newly created google doc for clothing tracking.  <a rel="nofollow" href="https://docs.google.com/spreadsheet/ccc?key=0AhYZi3t1pJ6cdHRpYmhXamEtQVdLcTgwMUlXY0hiN2c&usp=sharing"><a href="https://docs.google.com/spreadsheet/ccc?key=0AhYZi3t1pJ6cdHRpYmhXamEtQVdLcTgwMUlXY0hiN2c&usp=sharing" rel="nofollow">https://docs.google.com/spread.....sp=sharing</a> </a> Please let me know if you have questions...I'm not an excel/spreadsheet pro by any means. But this is working for me!  Tips:  - For the "last worn" date to show correctly make sure you're putting the date in the field, not just an x or 1 or anything else.  - If you want to change what's in the drop down of "Type", highlight all the rows (except 1 where Type is entered). Right click, click on "data validation", then just change the list that is showing in the field.  - You shouldn't have to enter anything in the "Last Worn" or "# of Times Worn" columns. Those will auto-update based on what you're entering in the date columns.  - I'm not personally using columns F, G, or H, but I wanted to leave them there in case any of you found them useful.  I hope this helps! Keix on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-667635 Fri, 13 Jul 2012 15:32:34 +0000 Keix 667635@https://youlookfab.com/welookfab/ I've played around a lot with spreadsheets, being a card-carrying member of the OCD listmakers' guild, but have yet to tackle CPW. I would love to get a copy of your template! NY Stella on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-667566 Fri, 13 Jul 2012 14:48:32 +0000 NY Stella 667566@https://youlookfab.com/welookfab/ This sounds amazing!!! And sooo super organized Excel awesomeness! Like others Teri I plan my outfits in advance when I travel and print out an excel spreadsheet (super simple compared to yours) noting what days I will be away, what the activities are, and what I will be wearing morning, afternoon and night. It is SO helpful and rewarding to put in some time to think it over and then be stress-free during the vacay. I would love to have a template if possible!! Looking forward to taking it for a spin Kiwichik on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-600132 Fri, 20 Apr 2012 18:50:40 +0000 Kiwichik 600132@https://youlookfab.com/welookfab/ Ha I definitely need to explore this further. My nickname at work is the spreadsheet queen but clearly you are the spreadsheet empress and I bow in homage to your greatness. Anonymous on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-600125 Fri, 20 Apr 2012 18:42:08 +0000 Anonymous 600125@https://youlookfab.com/welookfab/ Hi Kate, can you please e-mail me your awesome template?! Sounds awesome. Thanks! <a href="mailto:mackenzie.ayer@gmail.com">mackenzie.ayer@gmail.com</a> Anonymous on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-591400 Mon, 09 Apr 2012 11:58:36 +0000 Anonymous 591400@https://youlookfab.com/welookfab/ This sounds like too much work, even for my OCD self, lol! If I had more time on my hands, I'd probably do it, though. hilaryl on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-589557 Fri, 06 Apr 2012 15:38:17 +0000 hilaryl 589557@https://youlookfab.com/welookfab/ Can you please send me your template for your spread sheet. I have a new obsession with fashion and organizing and excited to try it out. Thanks! <a href="mailto:Hilarylogue@gmail.com">Hilarylogue@gmail.com</a> Lisa on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-470412 Sat, 19 Nov 2011 00:57:02 +0000 Lisa 470412@https://youlookfab.com/welookfab/ Genius! I've been tracking what I wear for the past year, but never added CPW to the columns. I like this formula, thanks Kate! cheryl on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-470197 Fri, 18 Nov 2011 21:43:07 +0000 cheryl 470197@https://youlookfab.com/welookfab/ I have a google spreadsheet of all of my items and last date worn but i want to start listing what i wore it with and how many times i have worn it. I have never really worried about cpw because i am such a bargain shopper anyway and dont have too many expensive pieces in my wardrobe. Laura (rhubarbgirl) on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-470109 Fri, 18 Nov 2011 20:37:23 +0000 Laura (rhubarbgirl) 470109@https://youlookfab.com/welookfab/ Super-cool. I started making a list of all my items by category in Excel right after I joined YLF, but I don't think I ever officially finished it, and I hadn't thought to note actual wear days. I think I'd shock myself with how many items I actually have if I ever sat down and wrote down literally everything I own. Marley on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469975 Fri, 18 Nov 2011 17:38:32 +0000 Marley 469975@https://youlookfab.com/welookfab/ This is super! There is a part of me who would really like to try this. I don't know if my computer skills are up to the level of actually making this work for me without a lot of hair-pulling and temper-tantrums - but I'd like to give it a try! I will PM you! bj1111 on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469937 Fri, 18 Nov 2011 16:47:22 +0000 bj1111 469937@https://youlookfab.com/welookfab/ ya know...i'm frightened to do this because i will just confirm what i already know in my soul. the average cpw of my entire closet is so outrageously high, that i can't shop EVER if i hope to bring it down to a reasonable level. Janet on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469801 Fri, 18 Nov 2011 14:13:47 +0000 Janet 469801@https://youlookfab.com/welookfab/ Wow, the slightly OCD list-maker in me loves this idea! The right-brained, Photoshop master, Excel-avoiding artist part recoils... Still, I'd be tempted to open Excel and give it a try. teri on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469800 Fri, 18 Nov 2011 14:10:30 +0000 teri 469800@https://youlookfab.com/welookfab/ WOW... and I thought I was being crazy keeping track of my outfits... lol I just keep a folder on my desktop. I take a daily photo and organize it by weeks (so this week is week 46 and I have Mon-Friday pic in there). I can easily look between the folders and see what I;ve worn recently. If I find an outfit that I especially like I print it onto paper and I keep these in my closet for quick outfit references. I've really enjoyed keeping track of my outfits. It really cuts down on figuring out what to wear each day. It's also very helful when packing for a trip. I'll take my pics and come up with a clothing agenda for the trip. I know exactly what to pack and what to wear on each day. Makrame on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469790 Fri, 18 Nov 2011 12:54:06 +0000 Makrame 469790@https://youlookfab.com/welookfab/ Oh, one thought that came to mind this morning, as I was thinking of inputing the sweater I am wearing into the spreadsheet - it will be also interesting for me to see how many times I can wear an item before it has to be discarded due to wearing out. I know that most sweaters font last too long for me, maybe one or two seasons, but it will be interesting to see what this means in terms of CPW. I want to compare this number with CPW for jackets or dry-clean only skirts, which might actually last longer and cost less per wear, even though the purchase price may be higher. lyn67 on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469740 Fri, 18 Nov 2011 10:49:53 +0000 lyn67 469740@https://youlookfab.com/welookfab/ Wowww!!! I'm subscribing for that template, too-thus, I really think you could built up a business on this!!!:-)) Hats off, Kate! Astrid on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469736 Fri, 18 Nov 2011 10:31:32 +0000 Astrid 469736@https://youlookfab.com/welookfab/ This is fantastic! May I ask you for that template? I think this could be useful in combination with my list. Although I still have to sort my through my things together with the list, I just didn't have the time the last few weeks. bella on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469691 Fri, 18 Nov 2011 06:13:52 +0000 bella 469691@https://youlookfab.com/welookfab/ Ok, right what you said makes a lot of sense too. Good call on the visuals.:) Kate on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469687 Fri, 18 Nov 2011 06:04:10 +0000 Kate 469687@https://youlookfab.com/welookfab/ Bella, haha, I was thinking of it in terms of a row goes horizontally and a column goes vertically, but you are also right that the columns appear across the top (horizontally) and rows appear down the side (vertically). How confusing! I'll edit the post to include a link to a visual that should better explain rows and columns. Sylvie on "creating a spreadsheet to keep track of what you wear" https://youlookfab.com/welookfab/topic/creating-a-spreadsheet-to-keep-track-of-what-you-wear#post-469683 Fri, 18 Nov 2011 05:56:04 +0000 Sylvie 469683@https://youlookfab.com/welookfab/ Wow! Your system is intense (and I mean that in the best possible way). I stick with google docs for portability but if I wanted something fuller featured, I would want something very similar to what you're using.