Article 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

42

42 comments

  1. trisha

    what if you are not sure on the percentages yet? How do you figure that out? I am experimenting with a product and I wrote down how much of each product I used which is primarily in cup and spoon measurements, but I am uncertain how to translate that into percentages. Your video is super helpful!

    1. Perry Romanowski

      Hello Trisha – if you have cup and spoon measurements, you need to convert them to grams. There are conversion calculators online that will help you.

  2. Susanne

    Such a nice formulation spreadsheet – thank you! I tried to “delete” the column D (Actual amn.) and copy the column C in it because I so much like to have both 500grams and 1000grams recipe in same spreadsheet. But it does`nt work. Do you have any suggestion for me how to have 2 columns (C and D) with respectively 500 gram recipe and 1000 gram recipe?

    1. Perry Romanowski

      You can just insert another column. Then copy the formula from column C to the new column. You’ll have to adjust the cells in the formula to point to the proper values.

  3. Terri-Anne

    HI, could you explain what the column called Actual Amt is for please? Thanks πŸ™‚

    1. Perry Romanowski

      That is the amount that you actually weigh out and put in the formula. It changes based on the size of the batch.

  4. Pingback:How to make cosmetic formulations – a complete overview – Chemists Corner

  5. tiffany newman

    Hi — Quick question…How do you add a line for additional ingredients?

    1. Perry Romanowski

      I think you can just go to ‘Edit’, ‘Insert’, ‘row’

  6. Julie

    I needed a formulation sheet quickly for a client’s custom formula. Thank you so much for this, Perry, and for all that you have shared.

  7. Harrison

    Hi Perry,
    What cell formula did you use?

    1. Perry Romanowski

      You can download the spreadsheet and find that out. I’m not sure what cell you are talking about.

  8. S

    Excellent explanation.
    Thank you

  9. Selina Jackson

    Thanks you so much for this, I can’t tell you how much learning these steps has relieved so much of my stress, thanks again

  10. Shawn

    The first video link is broken.

    1. Perry Romanowski

      Thanks I fixed it.

  11. Cosmetic Formulation Software

    I really like your post.It’s really informative and interesting. I really appreciate that.
    We provide an affordable, secure web-based software application for empowering cosmetics businesses. This is a complete formulation and cosmetic production software solution. You can create formulas, do formulation costing, and print out batch sheets.

    1. Perry Romanowski

      How is your software superior to just using a spreadsheet for formulating?

  12. Charina ting

    Hi… is the uploaded spreadsheet still active? We are a startup company and would like to check how we can make our research and costing templates more structured and efficient…. hope you can upload them again…. thank you

    1. Perry Romanowski

      Yes the spreadsheet should still work.

  13. CYNTHIA UZOETO

    Thanks alot.I want to start up my cosmetics line and u v bn very helpful.

  14. Jenneine

    Hi Perry,
    The video formulation template is not loading, neither on firefox nor chrome, wont download either says file not file or technical problem. Can you check this out I need to watch video, something i dont understand on your template.

    thanks

    1. Perry Romanowski

      Thanks for letting me know. I updated it to show the video.

  15. Azmar Ahmad

    Hi there! Thank you for sharing! πŸ˜€

  16. jennifer

    please put the template back on!!! you made it look so easy on the video πŸ™‚ I would love to work with it.

    1. Perry Romanowski

      I’ll get to it shortly. We lost all of our links when the website went down.

  17. Vianca

    Hello, I just started my own hair products line…and I created a spreadsheet template for my formulas that also calculates the cost of my product including packaging, as well as my profits and my retailers profits πŸ™‚ Took me a week to get it right as it required some very intricate equations. I can share if you’d like?

    1. jennifer

      please do!!

    2. Beverley

      Hello Vianca,
      Happy Holidays! I started experimenting on face creams. I would love if you share your spreadsheet template with me. It sounds like something I could really use.
      Thank you.
      Beverley πŸ™‚

    3. Rafaella

      Hey Vianca, hope you are doing well. I am having a hard time trying to creat my spreadsheet. Could you please share it with me? Thank you so much.

    4. Deja gordon

      Hey Vianca,

      Im starting my own hair care line as well and was wondering if you could supply me with the spreadsheet you created?
      Thank you,
      Deja

      1. Amaka

        Hi Vianca
        Please can you share this spreadsheet with me. Anyone else that has this spreadsheet, please I will be very happy to hear from you.
        Thanks

  18. Sharon

    Hi

    Thanks so much for this – really helps! Video was very useful to – however if I would prefer to change from pounds to Kg or Litres and British pound Β£ how would I do that without messing up your spreadsheet πŸ™‚

    I have been working on a soap formula – which this will work perfectly. Do you have any other spreadsheets that can be used to work out packaging for a formula?

    Once again that’s for making my life simple πŸ™‚
    Sharon

    1. Perry Romanowski

      Thanks for the ideas. The spreadsheet is open so you can easily adapt it for your own uses.

  19. Pingback:The Best Formulation Software Options for Cosmetic Chemists

  20. Amanda

    Thank you!

  21. Lorraine

    Oh My God…..YOU rock Perry, Loving you, Thank you!

  22. Bernadette

    Thank you Perry, that was very helpful. I have not started out yet but I’m supposed to make a batch of 10kg of deodorant and pack it in 50ml bottles. I do not know how many 50ml bottles 10kg will give me, this will help me determine the price of my product in relation to the cost of producing a 10kg product. How do I calculate this because I am dealing with volumes and weights here?
    Thank you again.

    1. Perry Romanowski

      Well, you just need an approximate value and can use the fact that 1mL ~ 1 g.

      So, 10 kg = 10,000 g = 10,000 ml
      10,000 / 50 = 200 bottles. But you have to figure you are going to lose about 10% of your batch so realistically, 10kg = 180 bottles.

  23. Pingback:Calculating Cosmetic Formula Costs

  24. luis

    Hi perry,

    Can you help me with developing a new formula for bleach gel. I hope to hear from you soon.

  25. cc_joy

    Nice demo ….. it get give an idea how cosmetic chemist work

Leave a Reply

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