A Spreadsheet Thing for Keeping Your Candle Batches Straight
Most candle makers I know end up with scraps of paper, random notes on their phone, and a drawer full of leftover wax labeled "maybe soy maybe paraffin." The Tracker For Candle Making Cute is a Google Sheets template designed to catch all that before it turns into a mess. It is not fancy. It does what it needs to do. Each row is a single batch. Columns cover your wax weight, fragrance oil amount in ounces and percentages, wick type and size, pour temperature, cure time, and a free-form notes field for things like "melt pool too narrow on day three" or "throw was weak even after 14 days." There is also a results section where you log how the finished candle actually performed compared to what you planned. The cute part is just a light aesthetic header with pastel colors and small candle icons. The formulas are what matter.
How to Use It Without Getting Confused
Start by creating your own copy of the sheet. Work in your copy so you do not overwrite the original. The template has a settings tab and a batches tab. Do not edit the settings tab unless you are adding fragrance categories you actually use. Fill in the batches tab row by row as you make each batch, not all at once at the end of the week. Use the fragrance percentage calculator built into column E. Enter your wax weight in ounces in column B and your fragrance load in column C. Column D auto-fills the percentage. This sounds trivial, but I have watched people confuse grams with ounces and end up running at 18 percent fragrance on a batch of container candles, which causes seepage and a soupy finish. The auto-calc prevents that kind of stupid mistake more often than you would think. Record your wick in column F using the actual manufacturer code, not just "wood wick #3." Different batches from the same supplier can behave differently. I learned that the hard way when I switched reeds for a "bamboo square 6mm" order and the cold throw on three jars dropped noticeably because the new reed had a different core mass. Writing down the full supplier line item saved me from repeating that error.
Where This Approach Hits Real Limits
The tracker works well for small to medium production runs. If you are making fewer than about 40 batches a month, the manual entry process stays manageable. Once you cross that threshold, typing batch numbers by hand becomes a bottleneck. At that volume, you are better off using a lightweight inventory app or building your own Sheets template with barcode scanning. This template does not support scanning or bulk import. Another limitation is that the current version does not handle multiple wax types within a single batch natively. If you sometimes blend soy and paraffin or use a coconut blend in the same pour, you have to manually adjust the columns or create a separate batch entry. I worked around this by adding a quick label column where I note the blend ratio, like "soy 85 / paraffin 15," and then keep a separate notes line for pour temperature adjustments that those blends require. The template itself does not calculate blend behavior for you.
Get the Full Details
Download and Setup Details
You can find the Tracker For Candle Making Cute template at sheets for crafters dot com slash candle tracker. Make a copy and rename it with your studio name so you can tell which version belongs to you when you have multiple files open. The template is updated seasonally, usually in January and July, with minor column additions based on feedback from regular users. If a column seems to be missing something you actually need, check the version date in the footer and consider submitting a feature request rather than manually editing the shared copy. One thing I want to stress is that the tracker does not replace testing. Logging data only helps if you actually run controlled comparisons. I once filled two months of entries without realizing my pour temperatures were drifting because I never logged the actual pour temp, only the target. The columns were there. I just skipped one. Going back and auditing your own entries every quarter will catch those gaps faster than you expect.
Quick Workflow That Actually Holds Up
Before you melt anything, write the batch number and date. After you pour, fill in the pour temperature and wick details while they are fresh. After the candle cures, record throw, melt pool, soot, and any visual defects. Keep the notes column honest. A note like "wick drowned slightly near rim" is more useful later than a vague "needs improvement." The template is simple on purpose. Simple spreadsheets survive longer than complex ones because they do not break when you add a new fragrance or change suppliers. If you find yourself fighting the sheet more than using it, trim the columns down to the ones you actually fill in regularly and delete the rest. A lean tracker beats a full one that sits empty.
