Formulating

Cosmetic Formula Spreadsheet Template

Posted on by Perry Romanowski

If you’re interested in making cosmetic products from scratch but you don’t have fancy software to do it, you can easily make them using a simple spreadsheet formula.

Here’s a video that explains the process.  It allows you to make different batch sizes, calculates ingredient masses, and also costs out the formula.

Cosmetic Formula Template

Avatar
Perry Romanowski

Perry has been formulating cosmetic products and inventing solutions to solve consumer problems since the early 1990’s. Additionally, he has written and edited numerous articles and books, taught continuing education classes for industry scientists, and developed successful websites. His latest book is Beginning Cosmetic Chemistry 3rd Edition published by Allured.

10 thoughts on “Cosmetic Formula Spreadsheet Template”

  1. Avatar
    Stephine says:

    Love the spreadsheet. Huge fan from Nigeria, i was trying to download the excel sheet i could not. Can you please kindly send it to me thanks.

    Reply
  5. Avatar
    Angelica Fiume says:

    Just want to make sure I am correct – the number in column ‘amount in batch’ is the weight? This is the percentage converted into grams?

    Reply
  6. Avatar
    Hershey says:

    THANK YOU!! I’m so poor in knowledge on excel so I’ve been using MS word and calculating from scratchhhh. This has been my life saver!!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *