Choose different ways to summarize the data, by using Average or Max, or other functions.Use the filter at the top of the pivot table, to focus on specific parts of the food data.On that sheet you can see a pivot table that summarizes the stored food data. To see a summary of the food data, go to the sheet named FoodPivot sheet. In the Then By drop down, choose Food ItemĪt the end of each day, you click a button to store that day’s food data on the DailyRecord sheet.In the Sort By drop down, choose Category.On the Excel Ribbon, click the Data tab, then click the Sort button.To sum up, After you add new food items, or make changes to the existing food items, follow these steps, to sort the list Updating this sheet is easy with “Dropdown feature in Excel”. The workbook automatically picks up the value from the master data in terms of calorie. This worksheet is the place where you capture your daily records. Now, after updating the food information and creating a database, you will have to move to the “ FoodEntry” Worksheet. You can define measures, calorie from each recipe and categorize them. This is done so that you can have a set of food you usually take.
These two worksheets are the master data of all the recipe that you have. In this template, daily food calorie counter, you will have to update the following worksheet in the beginning – Mainly for target calories, food data in the workbook. You should consult a professional before using this for personal use. This will help you for future references and keep better track of nutrients you get from each food.ĭisclaimer : This template is created for support purpose. Input all of the recipe ingredients in the workbook, and Excel workbook calculates the calories, carbs, protein, fibres and fat per serving.Īfter you calculate the recipe’s nutrients, you can add that as an item in the workbook’s food list. This is useful for both personal and consultancy / dietician professionals. About daily calorie counter excel templateĭownload and use this basic food Calorie Counter spreadsheet to keep track of the food and nutrition that you eat each day, and the nutrients that the food contains.
Get basic version, or Recipe Calculator version. Choose from the built-in list of foods, and add your favorite foods with their nutrition details.
If you need any other meal and food planners, make sure to check out our main collection of meal planner templates where you can find various printables from this category available for download in PDF.Download this free Excel food calorie counter workbook to track your daily food and nutrition calorie intake. Also, you can customize the size and choose the one that will work for you. Before getting your template you can also download free printable food log template sample to see if it meets your needs and looks good enough for you. Overall, you can use daily food diary for various purposes.Īll templates are available in PDF format but you can easily convert them in excel or word via free online services. You can capture what you ate during a day and write down the calories that meals were worth by obtaining the numbers from online calory calculators. Looking for a simple tool that would help you keep track of your food intake to stick with the diet and finally take control over your weight? Search no further, because these printable food journal templates are made exactly for that.Ĭhoose the food activity journal that will help you organize your exercise fitness routine, develop healthy food consumption habits and just capture your daily meals in a journal.