The problem with running cosmetic formulation in spreadsheets
Almost every cosmetics business starts formulation in Excel, and a surprising number of nine-figure brands are still there. The reason is obvious: a spreadsheet is free, flexible, and every chemist already knows how to use one. The reason it eventually breaks is that a cosmetic formula is not a spreadsheet. It is a regulated artifact with versions, parent-child relationships, ingredient provenance, country-specific restrictions and a direct line into the Product Information File.
The symptoms are familiar. Three chemists each holding a slightly different copy of "MOIST_SERUM_v17_FINAL_real.xlsx". An ingredient that turned out to be restricted under Annex III at a different concentration in China than in the EU, discovered the week before launch. A CPSR signed off against a version of the formula that no longer matches what production is making. An auditor asking "show me the trail from this batch back to the formula version that was assessed" and a regulatory lead opening their email archive.
The cost is not the spreadsheet. The cost is rework, delayed launches, recalls, and the regulatory headcount you have to hire to brute-force what the software should do automatically.













