Candle Quantity Spreadsheet Calculator

Candle Quantity Calculator Spreadsheet

Calculate how many candles you can make from your wax, fragrance, additives, and jar size using an editable spreadsheet built for candle production planning.

Candle production planning can be frustrating when you are trying to estimate how many finished candles a batch will make. This spreadsheet helps you turn your wax weight, fragrance amount, additive weight, and container size into a clearer production count so you can plan batches with less waste.

What this spreadsheet helps calculate

• total wax weight
• fragrance and additive weight
• jar or container size
• estimated candle quantity
• batch planning totals
• production yield

Best for

This spreadsheet is best for candle makers planning production runs, bulk candle batches, test batches, and inventory for handmade candles.

How it works

Enter your actual wax, fragrance, container, supply, time, or batch details based on the calculator. The spreadsheet uses pre-built formulas to calculate costs, usage, or production totals so you can make better decisions for candle and wax melt projects.

Helpful next steps

Browse more editable candle pricing spreadsheets, compare related tools like candle cost spreadsheet in lbs and candle cost spreadsheet in grams, or get lifetime access to the full Craft Calculators spreadsheet vault if you want access to every current and future pricing spreadsheet.

✔ Candle quantity spreadsheet

✔ Estimates candles per batch

✔ Uses wax, fragrance & jar size

✔ Google Sheets & Excel

✔ Imperial/metric + local currency

✔ Free future updates