Why Excel breaks when you scale formulation (and what to use instead)

Almost every supplement, cosmetic, and food manufacturer starts formulating in Excel. It is flexible, familiar, and free of any learning curve. For the first few products, it works fine. The trouble starts when the catalogue grows — and the very flexibility that made Excel attractive becomes the reason it fails.

Why everyone starts in a spreadsheet

A spreadsheet asks nothing of you. You open it, type in ingredients and amounts, add a formula to total the cost, and you have a working tool in minutes. For a single product, or a handful, this is genuinely the right tool.

The problem is that the spreadsheet does not scale the way a business does. What works for five products quietly breaks at fifty.

Where it starts to break

Version chaos. "Final_v3_REAL_updated.xlsx". Every formulator recognises it. With spreadsheets, there is no single source of truth — there are copies, on different machines, in different inboxes, each slightly different. Nobody is quite sure which one is current.

No connection between data. Your ingredient costs live in one sheet, your formulas in another, your compliance limits in a third — if they exist at all. When an ingredient's cost or specification changes, nothing updates automatically. You hunt down every formula that uses it and edit by hand.

Compliance is invisible. A spreadsheet does not know that a nutrient has an upper limit, that an ingredient is novel, or that an allergen entered through an excipient. It happily lets you build a non-compliant formula, because it has no idea what compliance means. Every check is manual and external.

Errors hide. A mistyped figure, a formula dragged one cell too far, a unit confusion between mg and percent — spreadsheets are notoriously prone to silent errors. The number looks fine, so nobody questions it, until it shows up on a spec sheet or a label.

Knowledge walks out the door. The logic lives in the head of whoever built the sheet. When they leave, the team inherits a tangle of cells nobody fully understands.

The cost of "it still works"

The insidious thing is that Excel never fully stops working. It just gets slower, riskier, and more dependent on a few people who know where everything is. The cost is paid in time — hours rebuilding spec sheets, reconciling versions, re-checking compliance by hand — and occasionally in expensive errors that reach a customer or a regulator.

Because the failure is gradual, it is easy to keep tolerating. But the gap between what the business needs and what a spreadsheet can give keeps widening.

What a purpose-built system does differently

The alternative is not a fancier spreadsheet — it is a system that understands what a formula is.

One source of truth. The formula exists once. Everyone works from the same current version, and history is tracked rather than scattered across files.

Connected data. Ingredients, costs, specifications, and compliance rules are linked. Change an ingredient cost once and every formula that uses it reflects it. Adjust a dose and the cost, the compliance status, and the declarations update together.

Built-in compliance. The system knows about limits, claims, allergens, and reference values, and checks them as you formulate — turning compliance from a manual external step into something continuous.

Documents as outputs. Spec sheets, ingredient lists, and declarations are generated from the formula, not retyped — so they always match what is actually in the product.

When to make the move

The signal is usually felt before it is measured: version confusion, time lost rebuilding documents, a near-miss on compliance, a growing reliance on one person. When the spreadsheet is costing more time than it saves, it has outgrown its job.

The takeaway

Excel is the right tool to start with and the wrong tool to scale with. It breaks through version chaos, disconnected data, invisible compliance, and hidden errors — not all at once, but steadily, as the catalogue grows. A purpose-built formulation system replaces the spreadsheet's flexibility with structure: one source of truth, connected data, built-in compliance, and documents generated from the formula itself.

Lemoniq replaces the formulation spreadsheet with one connected system — live costs, built-in compliance, and documents generated straight from the formula. See how it works