• Free Diet Tracker App
• Free Printable Food Diary
• Free Food Tracker

This file will help you track what you eat. The file contains 17 food categories, eating diary and statistics. There are also some sample data for better orientation how it works. It’s very easy to use it. You simply choose food from the list and type the quantity. Excel automatically calculates everything else (like number of calories, carbohydrates, proteins, fats and fiber).

Perfect Diet Tracker is award-winning software for your Mac that can help you monitor your diet and achieve safe and consistent weight loss, maintaining that weight loss once you reach your target. The Perfect Diet Tracker is not a 'fad' diet, it is a software application that lets you manage your own diet based on firm scientific foundations. Keto diet plan is not an easy task to follow. The diet plan aims to lose about 3 to 5 pounds of the total weight of your body by shedding fat from your thighs, buttocks, hips, and abdomen. It works perfectly for the people who are trying to lose weight rapidly. The Keto Diet Plan Do's And Don'ts. Carb Manager is truly THE all-in-one Keto diet app built specifically for the low carb lifestyle. Easy-to-use food diary: Search 3M+ foods with macros and carb counts, including net carbs and sugar alcohols. Keto calculator: Track net carbs, macros, and more. Macronutrient tracker: Track carbs, fats, & protein.

How to write down my eating

Use the worksheet called “Eating diary”. For example, you eat 150 grams of Nestle Fitness Corn flakes with 100 ml Semi-skimmed milk. Each item must be entered separately.

1. Enter a date below the last line of the table.
2. Select the Type. (Grains)
3. Select the Item. (Nestle Fitness Corn flakes)
4. Enter the Quantity in units that are in the column Units (150). Units can be changed but not in this table!
5. Excel calculates everything else.
6. Repeat this procedure for the next food.

Statistics

Your diet statistics are made by an ordinary Excel PivotTable on the sheet “Statistics”. It shows sum of each day.

The Pivot table doesn’t show the newly added data immediately. It has to be refreshed or you have to save, close and open again the file. To refresh the statistics table, do:

1. Right-click somewhere into the statistics table.
2. Select “Refresh” from the menu.

My calculations

You can use the “My calculations” worksheet if you need more than basic day statistics. This is place for your own tables and formulas.

How to save or edit food into the database

You have to save the food into the database before the first use. The file contains 17 named categories of food and 2 custom categories. Each category is on the separate worksheet. The list of categories is below.

For example, I want to save Peanuts (1 oz, Calories: 161, Carbohydrates: 4.6, Proteins: 7.3, Fats: 14, Fiber: 2.4)

1. Find the right category. (Nuts & peanuts)
2. Enter the name of food below the last line of the table.
3. Enter the quantity.
4. Enter the unit.
5. Enter the rest of the values (Calories, Carbohydrates, Proteins, …).
6. Now you can use Peanuts in the Eating diary.

The basic unit does not to be exactly 1 oz. You can use cups, fl oz, gram, ml or whatever you need, it is up to you. The basic value also doesn’t to be 1. You can use any number.

For example, I bought a bag of chips and eat 150 grams. On the back side of the bag is a table with nutrition. But there are values only for 30 grams. So I enter this into the database.

Crusty Croc Chips: 30 g (grams), Calories: 158, Carbohydrates: 1.7, Proteins: 14, Fats: 10, Fiber: 1.2

Food categories

How to change the category name

I strongly recommend to do backup copy of your Eating diary file before any change in categories.

There is the hidden sheet named Type. It contains the list of categories that can be changed. The category name is joined with the name of the source table. Both have to be exactly the same (and without spaces). The name of the source table (table with items) can be edited in Formulas >> Name Manager or in Table tools >> Design >> Table Name.

In this video example, I will rename the Drinks & Juices category to Abcd. As you see, it doesn’t matter of the sheet name. Only the source table and the item in Type sheet is important.

How to add the new category

In this example, I will create the new category called CategoryName As in the previous, it doesn’t matter of the sheet name.

Free download

This file is free for any use.

Version with sample data: eating_diary.xslx

Clear version: eating_diary_clear.xlsx

Free Diet Tracker App

Edit. 02/10/2015

- added new videos: How to change the category name, How to add the new category
- repaired formulas in eating_diary_clear.xlsx
- removed sheets protection – feel free to do any updates or changes you want

Free Printable Food Diary

1. i love food

2. All values are inside of some range (or whatever it is) with blue borders. You can expand that range, add more values, etc. What is that?

3. Hi

4. • Left-click on the link > Save link as…

5. Thanks for the template, its really useful. but how can we add more rows, for example adding data for vitamins A. C, D etc.

6. Is there a similar one with standard rather than metric values? I might use it if there was. But converting everything to metric is otherwise a constant extra step for me.

   • Units are completely in your hands. There is no need to use metric values. Predefined values are only used as an example. BTW. there are also units like cup, teaspoon, …

7. How do I add Sodium to the list of nutrients?

8. Awesome template! Do you have free nutrition plan?

9. I track my keto diet with this. I can recommend it.

10. I believe that this will help me to low my body fat

11. Does anybody have list of nutritional values of common food? Like pastries, fruits, vegetables, meat,..

12. This really looks awesome! The only problem is I get this #NAME? error under unit, total calories etc on the eating diary and I can’t seem to find the solution! Has anyone else encountered the same issue? If yes, how did you solve it?

    • Hi,

      I have the similar issue. I see #REF error in unit, total calories etc on the eating diary.

      • Hi,

        as it is mentioned in video. #REF error will disappear after you enter all values: data, type and item.

    • Hi,

      #NAME error occurs mostly when Excel doesn’t recognize formula. Are you sure that you are editing the right cells? You can try to download version with sample data: eating_diary.xslx and fill your eating again.

13. I love this! Thanks for making my life easier
    I was about to create one myself but it would take ages…

14. I’m sending this again…..I received no conformation of my previous message delivery…..not sure if I was successful in proving that I am, indeed, a human………..but I am…..actually I’m a space alien in need earthly food education

    I am looking to find a spreadsheet to use for daily planning. I have no need for history of yesterday and before. I would like to be able to mix and match items……add or subtract…modify…..my daily menu and observe how each item reflects the daily goal in real time. Can I do this….will it work for Mac……..and where is the download button? Please advise….

15. I am looking to find a spreadsheet to use for daily planning. I have no need for history of yesterday and before. I would like to be able to mix and match items……add or subtract…modify…..my daily menu and observe how each item reflects the daily goal in real time. Can I do this….will it work for Mac……..and where is the download button? Please advise….

16. • Hello,

      there is “Free download” section on the article bottom.
      With version with sample data and clear version. Just click on the eating_diary.xslx.

17. Hello,
    looks pretty awesome but every cell in the eating diary is #REF!
    Can you help us to understand why ? What should be the formulas ?
    thanks

18. This is the best excel app for tracking calories and proteins. I used it in my training plan and it worked prefect.

19. It is great with my fitness tracking app in Excel.

    Thank you.

20. I need template with charts to see the progress of fat burning and calorie income. This calculator is great but some charts would it make perfect.
    Thank you

21. I need to make a chart for my Bio Life Science class. Need a template for a food log with all calories, fat, protein….etc

22. I would like to keep track of my sugar intake, How can I add a column for sugar on each sheet?

    • You can try to expand all tables (add a column). Then copy the formula from last column. Be careful, the copied formula has to be exactly the same as original formula. Only difference has to be that the number 8 changes to 9. I hope it helps. I think this is one of the best app to track calories and eating diary.

      • Thank you. This is what I have been looking for. It is much better than my Android app calorie counter. I can set everything in my way. Superb

        • I don’t think so. Mobile apps are much better. Try it. The best android app for calorie counter and diet is the FatSecret Calorie Counter and is for free.

          • You can update this Excel template and make calculations and statistics by your own needs. This is not possible in the mobile app.

23. Hi Jan. Here’s an issue that needs a fix.

    I autosave my file every 2 min, and save it after finishing some work.

    When I reopen the file, I’m getting a repaired error notification, which requires the file to be saved to a new name.

    Problem is, this happens every time I open the new file, too! The tables repaired are the same, however how do you identify them?

    Not sure what to do. Please advise.

    ”
    -
    error028400_01.xml
    Errors were detected in file ‘C:UsersPublicDocuments_Food keto eating_diary 2.xlsx’
    -
    Repaired Records: Table from /xl/tables/table3.xml part (Table)
    Repaired Records: Table from /xl/tables/table4.xml part (Table)
    Repaired Records: Table from /xl/tables/table5.xml part (Table)
    Repaired Records: Table from /xl/tables/table6.xml part (Table)
    Repaired Records: Table from /xl/tables/table29.xml part (Table)
    Repaired Records: Table from /xl/tables/table30.xml part (Table)
    Repaired Records: Table from /xl/tables/table45.xml part (Table)
    Repaired Records: Table from /xl/tables/table46.xml part (Table)

    “

24. Great spreadsheet! I’ve not used pivot tables before, so editing has been fun.

    I added food items, added a column to the food pages and the Eating Diary (and corrected the formula so it worked); changed the tab names; and update the TYPE tab. I checked all the new names in Eating Diary, and everything is working great there. The new column is pulling data from the pages.

    Statistics is not though, even with refreshing. It wants to show me various levels for each main line. It is not showing a total column I added, even though it is check in the Pivot Table control panel. I’m not sure what to do. Please advise.

    • I figured out the StatisticsTab. The Row Labels had all kinds of extra sorts, when it should have been just “Date.” I’m guessing it went wacko after I updated Types.

      BTW, when you change the Types and the Tabs, the respective tables are automatically renumbered. I didn’t have to change one of them.

      On Eating Diary a new minor issue has cropped up: Columns Carb, Fiber, Net Carbs (new), Protein and Fats all have “inconsistent error” flags. After the save, the formula for those columns had to corrected. Besides turning them off for all those cells constantly, I’m not sure what to do.

      The only other error is input. When I cross foot the calculations on the Statistics, I’m 100 calories off. A minor thing.

    • Okay, so my solution to the Eating Diary was to Move a Copy from the ‘eating diary clean’ Eating Diary tab to my file. I changed any columns I need (including adding and rearranging). I saved the document.

      Then I copied and pasted columns A, B, C, D from the original Eating Diary to this new one Eating Diary (2) tab. Once I verified the numbers were correct (using sum function for columns F-H (or what ever you have added) a few rows below the table, I created a new pivot report. Instructions are in the Help menu.

      On the new Statistics tab, I changed the color of the text for the Grand Totals so they nearly met the background. Grand totals don’t mean anything to me.

      Next I renamed Eating Diary and Statics to ‘Eating Diary 1″ and “Statics 1″ then hid them. I renamed my new Eating Diary Statistics tabs. Voila!

    • Because I make a lot the same recipes repeatedly, I use a fresh copy of Eating Diary and renamed it ‘Recipe Base.’

      To use it, I make another copy of it, naming it for the recipe. Ignoring the date field, I put together the ingredients.

      A few rows below the table I use sum to tally columns F-H (or what you have). I then divide those numbers by the number of servings. Next, I list the serving results on the appropriate page for the dish, so I can add it to the Eating Diary. I move this named recipe tab to the end of the tabs. It’s available to update and out of my way.

25. I found this template very helpful however, I have tried to add a new column (Total Sodium) and cannot get it to work. Is there something that I am missing? Again, thanks for developing this template – it is very helpful.

    • George, see my post.

      I too am having trouble with the formulas on Eating Diary after adding a new column. My comments might help you get fix some of your errors. Until I figure out how to change the default formulas for Eating diary, I change them for the group on a daily basis.

26. The eating diary is fantastic however I have encountered an issue I don’t know how to fix. Running Excel 2010

    When I get to line 27. Drop downs are no longer available and the Design tab goes away.

    How can I keep this going after line 26?

    This is fantastic but after two days I’m no longer able to enter data in the eating diary worksheet due to no drop downs

    • Very valid, pithy, suntccci, and on point. WD.

    • I experienced the same problem — go to the last good line – start at the date and tab to the end – it will go to a new line and all will be restored so that you can enter data again.

27. Excellent template…saved me an hour of work by just googling, and downloading!

    I am on a low carb/ketogenic diet, and this works great for tracking my meal breakdown.

    Thanks again!

    • I’d venrtue that this article has saved me more time than any other.

28. Hi there,

    Just come across this and it is brilliant. How do i manage to change each category or add additional categories?

    Thank you

29. Thanks so much for putting this invaluable tool together. I keep in my Dropbox so that wherever I am and whatever device I am using I can add as I go through my day. Using this has helped me keep under 60 grams of carbs a day and that along with increasing my exercise slightly has helped me lose 12.5 pounds from December 26 to Jan 30.

    • Thanks for inciodutrng a little rationality into this debate.

30. I think your blank document doesn’t have all the formulas. I just used the sample one and cleared the data. That might be why the poster from February couldn’t get it to work.

    • @Sam

      yes i am having the same complications with the blank sheet, i would love to edit and add in my own tabs and fully customize everything as my own but this file is protected,

31. Excellent .A+ .Unfortunately does not work in Excel 2013

    • Why does this have to be the ONLY rellbaie source? Oh well, gj!

One of the most cited reasons for any deficiency in the body is concerned with nutrition. Hence, to keep nutrition level in check, there are some nutrition software that regularly tells you how you should go about your diet. These software are trusted and mostly used by doctors and dieticians for the purpose. With highly professional design, these tools have won the confidence of leading nutrition experts across the world.

DietMaster

This software in your pocket works just like having a leading nutrition expert by your side. The food required for your body are suggested by leading dieticians. The software comes with two variants, one compatible with Windows and the other compatible with both Windows and Mac.

Weightmania

This is basically an analysis software that analyzes your weight, workouts, loss if any and suggests you meals accordingly. It gives a detailed account of the nutritional level of the food that you take. This software is available on all leading operating systems.

nutrition

This software is mostly used by gym trainers. It records and analyzes the body growth, weight gain and loss, diabetes and other diseases. There is a food diary in the software which can be taken as a meal assistant for healthy living. This amazing nutrition software comes for just $49.95 only.

Free Food Tracker

Other Platforms

Nutrition Software comes on other important operating systems as well. Since we are using Mac and Android a lot these days and find really less time to care for our foods, companies have designed effective nutrition analysis software that works brilliantly on these operating systems.

Calorie Counter – Nutrition software, free download on Android

For all the Android users, here is software that will help you immensely if you are willing to shed some extra fat from your body. With over 6 million food solutions to help your body, this software periodically checks your calorie level to help you lose some extra weight. It is a must have utility on every Android device.

Diet Controller – Nutrition Analysis Software on Mac

This is a cross-platform diet chart compatible on Mac OS X 10.8 and OS x 10.7. The software automatically creates a chart of your food intakes, exercises schedules and monitors your daily progress. The software gives a day by day report of the food and nutrition taken by the user. There is a trial version coming for absolutely free.

Diet Power – Professional Nutrition Analysis Software for Windows

This is highly professional diet analysis software that can be used both individually and commercially. It tracks the nutrients in your diets from the highly important vitamins to the micro zinc and other metals. The record of your body stats are perfectly secured with this software. There is a 15 days trial version available. The developers give the 1-year money back guarantee.

FitDay – The Popular Nutrition Analysis Database

This is an online food and nutrition journal. The user can simply make an account for free and browse through a lot of food and nutrition resources available on the database. Based on the input given by the user, nutrition suggestion, and food intakes are also suggested by this journal.

What is Nutrition Software?

Since our lifestyle has become highly vague these days, we need some assistance on the food and nutrition that goes inside our body. Nutrition software which are very newly conceptualized gives the user an overview of his/her body requirements. The nutrition and food suggestion on these software are given by leading nutrition experts from around the globe. These software are so important because they also help in checking some of the most common yet deadly problems such as diabetes, BP issues etc.

So, these software are an ultimate requirement for both young and old today for maintaining a healthy life.Food is the basic need for sustaining life. However, we must know what food to eat to keep a healthy body. Download these nutrition software now and you will get a virtual professional nutrition analysis software expert for all your diet needs.