Excel template
Calculate the nutrition information by weight from the ingredients of your recipe. It opens in Excel or Google Sheets.
Per 100 g calculation with the seven mandatory values · Template in Spanish
Let Recipok calculate it for you
Type your recipe or upload a photo. Recipok suggests the ingredients and gives you back the nutrition table, the allergens and the technical sheet as a PDF.
Calculate my nutrition tableThree recipes with no sign-up · No card
What this template is for
If you pack what you make to sell it in a shop, to a distributor or online, the label has to carry the nutrition information. And even when it is not required, more and more customers look for it before choosing. This template lets you calculate it yourself, recipe by recipe, from the ingredients and their weights, without paying for a lab analysis.
It has been the most downloaded file on our blog since 2022. We have reviewed it so it follows what Regulation (EU) 1169/2011 asks for today: the seven mandatory values, per 100 g and in the right order.
When is nutrition information mandatory?
The general rule of Regulation (EU) 1169/2011 is simple: pre-packed food carries a nutrition declaration. The most common exceptions in a workshop or a kitchen are these:
- Unwrapped products: the bread, cakes or dishes you sell loose or pack at the customer's request at the time of sale. There, what is mandatory is the allergen information, not the nutrition table.
- Small quantities sold directly: Annex V exempts food, including craft products, that the manufacturer supplies directly in small quantities to the final consumer or to local retailers that sell to the consumer.
- Single-ingredient products and a few other cases in the same Annex V, such as water, spices or herbal infusions.
As soon as you sell through an intermediary (a distributor, a chain, a third-party online shop), they will normally ask for it on the label and on the technical sheet. If you are unsure about your case, ask the food authority that inspects you.
The seven values your table must include
Article 30 of the Regulation sets what is declared and Annex XV sets the order. Always per 100 g or per 100 ml:
| Value | Unit | What to bear in mind |
|---|---|---|
| Energy | kJ and kcal | Both, side by side. |
| Fat | g | Total fat. |
| of which saturates | g | Written like this, under fat. |
| Carbohydrate | g | Not counting fibre. |
| of which sugars | g | Both those naturally in the ingredients and added ones. |
| Protein | g | |
| Salt | g | Sodium × 2.5, if your supplier gives you sodium. |
You can voluntarily add fibre, monounsaturates or polyunsaturates, starch, polyols, vitamins or minerals, always following the rules of the same regulation.
How to fill in the template, step by step
The template calculates by weight: it adds up what each ingredient contributes in proportion to its weight in the recipe. It is the method accepted by Article 31 of the Regulation and the one almost every workshop uses.
- Enter the ingredients with their weight. In grams, exactly as they go into the mix. One row per ingredient.
- Copy the nutrition of each one. The values per 100 g from the label or from your supplier's technical sheet. If an ingredient does not come with it (a fresh egg, a piece of fruit), use a recognised food composition database for your country.
- Enter the final weight of the product. What it weighs after baking or cooking. It is the figure people forget most often and the one that changes the result most: if a sponge loses 12% of its water in the oven, its nutrients become more concentrated.
- Check the result per 100 g. Compare it with a similar product. A fat-free muffin or a salt-free sauce almost always means an ingredient with an empty row.
- Round it and move it to the label. Using the rounding rules below, and with the version date so you know when you made it.
If you want to understand the calculation behind it, with a full example, we explain it in how to calculate the nutrition information of a recipe.
How to round the values
In 2012 the European Commission published a guidance document on tolerances that sets how each value is rounded. It is the one inspectors follow:
| Value | How it is rounded |
|---|---|
| Energy | To the nearest whole kJ and kcal. |
| Fat, carbohydrate, sugars, protein | 10 g or more: to the nearest gram. Between 0.5 and 10 g: to one decimal place. 0.5 g or less: “0 g” or “<0.5 g”. |
| Saturates | 10 g or more: to the nearest gram. Between 0.1 and 10 g: to one decimal place. 0.1 g or less: “0 g” or “<0.1 g”. |
| Salt | 1 g or more: to one decimal place. Between 0.0125 and 1 g: to two decimal places. Below that: “0 g” or “<0.01 g”. |
How to put the table on the label
The nutrition declaration is presented as a table, with the figures aligned. Only if there is not enough room can you write it on a single line (“Energy 1512 kJ / 360 kcal; fat 15 g, of which saturates 8.2 g; …”). Also:
- You can add the value per portion or per unit, stating how much a portion weighs and how many the pack contains.
- If you express any value as a percentage of the reference intake, add the sentence “Reference intake of an average adult (8400 kJ / 2000 kcal)”.
- On the label, the table sits alongside the ingredients list with the 14 allergens highlighted, the net weight, the lot and the date. We go over it in the article on nutrition labelling for pastry shops and bakeries.
This is what a correct table looks like, the same one Recipok produces for a sponge cake:
| Nutrition information | Per 100 g |
|---|---|
| Energy | 1512 kJ / 360 kcal |
| Fat | 15 g |
| of which saturates | 8.2 g |
| Carbohydrate | 50 g |
| of which sugars | 27 g |
| Protein | 7.7 g |
| Salt | 0.13 g |
The most common mistakes
- Dividing by the weight of the raw dough. If the product loses water in the oven, the table comes out lower than it really is. Always divide by the final weight.
- Counting the water in the recipe as if it contributed something. It adds no nutrients, but it does add weight to the mix: include it in the ingredients and let the final weight do its job.
- Forgetting semi-finished products. A pastry cream or a base dough is first calculated as a recipe of its own and then goes in as one more ingredient.
- Keeping the old table after changing supplier. A different flour or a different butter changes the figures. The table has to change with them.
- Confusing sodium with salt. If the supplier's sheet gives sodium, multiply it by 2.5.
Template or software? When each one pays off
With a few recipes that hardly ever change, the template is enough. The problem comes with volume: one template per recipe, and every change to an ingredient means opening them all.
| Excel template | Recipok | |
|---|---|---|
| Price | Free, for ever | Free up to 12 recipes |
| Ingredient nutrition | You copy it from each label | From the database, from the manufacturers' portal or read from their technical sheet |
| If an ingredient changes | You redo every recipe | Every recipe that uses it is recalculated |
| Semi-finished products | By hand, on another sheet | Counted automatically with their own nutrition |
| Label and technical sheet | Separately | They come from the same recipe, with the allergens |
| Value per portion | Another column to maintain | One tick box |
In Recipok, nutrition information is included in every plan, the free one too, and it flows automatically to the pre-packed label and to the technical sheet. If you sell in the United States, it also produces the Nutrition Facts panel. You will find the details in the help centre: nutrition information of the recipe.
A gift for downloading the template
With a free Recipok account you get 12 recipes with their costing, their label, their technical sheet and their nutrition information calculated from the ingredients. Nothing to install, no card and for ever. And if your recipes are already in Excel or in a notebook, Recipok reads them from the file or from a photo.