My Cosmetics Inventory Spreadsheet

There’s curiosity about my cosmetics inventory spreadsheet so I thought I would devote an entry on how it came to be.  I created my cosmetics spreadsheet on Sunday July 26, 2009 (as revealed by the Excel file properties). At the time, it was primarily a way to track my growing nail polish collection so that I didn’t duplicate any of my Essie shades (at present count, I own 73 bottles of Essies – it is my favourite nail polish formula).

Eventually I expanded the spreadsheet to include the following tabs:

  • eye shadows
  • eyeliners
  • blushes
  • face products
  • lip gloss / lip balms
  • lipsticks
  • nails
  • tools (brushes)
  • skincare
  • hair
  • scents

The initial set up of the spreadsheet was a daunting task. If I had created the spreadsheet from the inception of my first beauty product purchase, it would have been a breeze. But I had to essentially do a full inventory of my stash to build the spreadsheet – item by item, line by line.

Continue reading