Contextures

Excel Calorie Counter

Get this free Excel calorie counter workbook. Choose from the list of foods, and add your favourite foods, and their nutrition information. Get the basic version, or the recipe calculator version.

Excel Calorie Counter Intro

Use the basic Calorie Counter workbook to keep track of the food that you eat, and the nutrients that it contains.

There is also an advanced Calorie Counter workbook that contains a recipe calculator. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protien, fibre and fat per serving. After you calculate the recipe's nutrients, you can add that as an item in the workbook's food list.

Daily Food

The main sheet is named FoodEntry. Each day, enter the date, and your target calories.

enter your target calories

Then, select the time (Breakfast/Lunch/Dinner/Snack) and the food category.

select a food category

In the Food Item column, select one of the foods from that category. Dependent data validiation is used here, to limit the selections, based on the choice in Category column.

select a food from the category

Finally, enter the quantity that you are eating, based on the amount that appears in the Measure column. In this example, the amount is 175 mL (about 6 oz).

Type a 1 in the Qty column, if you are eating a serving of that size. Or, type a different number, such as 0.5 or 1.5, if you are eating more or less than that.

After you enter a quantity, the Calories column will show the total calories in your serving.

calories are calculated

Save the Food Data

At the end of each day, click the "Save Daily Data and Clear" button, at the top of the FoodEntry sheet.

calories are calculated

That clears the green cells on the FoodEntry sheet, so you can start fresh the next day.

All the food data is pasted onto the DailyRecord sheet, below any previous entries.

calories are calculated

The Food List

To see the stored list of foods and their calories, go to the FoodList sheet. You can add new foods, or edit the existing foods.

IMPORTANT: After you make changes, be sure to sort the list again, by Category and Food Item.

The list must be sorted, or the dependent drop down list on the FoodEntry sheet will not work correctly.

calories are calculated

Food Summary

On the FoodPivot sheet, you can see a pivot table that summarizes the stored food data.

Choose different ways to summarize the data, by using Average or Max, or other functions. Or, use different ways to show the values, such as % of Column, as in the screen shot below.

calories are calculated

Download the Excel Calorie Counter

Excel Calorie Counter -- Download the basic Excel Calorie Counter workbook. The zipped file is in xlsm format and contains macros. Enable macros when you open the file, so the Save Data button will work correctly. ExcelCalorieCounter2007.zip 

Excel Calorie Counter With Recipe Calculator: Same features as basic Excel Calorie Counter, plus a Recipe Calculator --calculate nutrients per serving in your favourite recipes, and add those to the Food List. The zipped file is in xlsm format and contains macros. Enable macros when you open the file, so the Save Data button will work correctly. ExcelCalorieCounter2007Recipe.zip  

More Tutorials

Excel Weight Loss Tracker

Holiday Dinner Planner

Christmas Planner

Weekly Meal Planner

Data Validation Basics

Advanced Filter Introduction

Pivot Table Introduction

 

Search Contextures Sites

 

pivot power premium

 

 

pivot power premium

 

 

30 Excel Functions in 30 Days

 

Last updated: July 10, 2017 7:38 PM