Posted in

5 Free Food Journal Templates in Excel

5 Free Food Journal Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A food journal template is a simple tool for writing down what you eat and drink, when you eat it and how you feel afterwards. Keeping a record for even a week or two often reveals habits that are hard to notice otherwise, such as skipped breakfasts, late-night snacking or low water intake. On this page you can download five free food journal templates in Excel: a daily food journal that totals calories, protein, carbs, fat and water against your goal, a weekly food diary that shows seven days side by side, and a food and symptom tracker for spotting links between meals and how you feel, plus a hydration and meal journal and a weekly food prep journal.

All five are real, editable .xlsx workbooks created for this page. Type into the yellow cells and the totals and averages calculate automatically. They also open in Google Sheets, LibreOffice Calc and Numbers, and they print cleanly if you prefer to write by hand.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Food Journal?

A food journal, also called a food diary or food log, is a record of everything you eat and drink over a period of time. A basic journal lists the time, the food and the portion size. A more detailed journal adds calories and nutrients, water, hunger and mood before and after eating, physical activity and any symptoms. The level of detail depends on your goal: general awareness, weight management, sports nutrition or helping a doctor or dietitian understand a health issue.

The value of a food journal comes from honesty and consistency. It is not about judging what you ate. It is about having accurate information so you can make small, realistic changes and see whether they help.

Why Keep a Food Journal in Excel?

  • Totals are automatic. Calories, protein, carbohydrates, fat and water add up as you type, and the daily template shows how much of your calorie goal is left.
  • Patterns are easier to see. The weekly diary shows seven days side by side, and the symptom tracker highlights entries with high severity.
  • It is private and free. Your data stays in your own file. There is no account to create and no subscription.
  • It is flexible. Add columns for fiber, sugar or sodium, change your goals or rename meals to fit your routine.
  • It is easy to share. You can print a week or share the file with a dietitian or doctor.

Download the Free Food Journal Templates

Each template is hosted on this website and free to download. The preview shows each file as it opens.

1. Daily Food Journal

Daily food journal template in Excel with meals, calories, water and mood

The daily food journal has one row for each meal or snack, with columns for the food and portion, calories, protein, carbohydrates, fat, water and a short note about mood or hunger. Enter the date and your calorie goal at the top. The total row adds up each column, and the remaining calories cell shows how much of your goal is left, turning red if you go over.

Below the totals, the template shows the share of calories coming from protein, carbohydrates and fat, using 4 calories per gram for protein and carbohydrates and 9 for fat. A notes box at the bottom gives space for sleep, activity or anything else that affected your day. The sample entries show how a completed day looks; replace them with your own.

2. Weekly Food Diary

Weekly food diary template in Excel with meals for each day of the week

The weekly diary is ideal if you prefer to see the bigger picture rather than count every gram. Enter the first day of the week and the template fills in the dates for all seven days. Each day has space for breakfast, a morning snack, lunch, an afternoon snack, dinner and drinks, plus rows for total calories, cups of water, minutes of exercise and an energy score from 1 to 5.

At the bottom, the template calculates weekly averages for calories, water, exercise and energy. Comparing these averages week by week is a simple way to see whether changes, such as drinking more water or walking after dinner, are making a difference.

3. Food and Symptom Tracker

Food and symptom tracker template in Excel for recording foods, symptoms and severity

Some people keep a food journal to understand symptoms such as bloating, heartburn, headaches or skin reactions. The food and symptom tracker records the date and time, what you ate or drank, any symptom, its severity on a scale from 0 to 5 and how many hours after eating it started. Entries with a severity of 3 or more are highlighted, and a counter at the bottom shows how many there were.

After two to four weeks, sort or filter the sheet by symptom to see which foods appear most often before the worst entries. Take the tracker to your doctor or dietitian; it gives them far more to work with than memory alone. This tracker is a personal record and not a diagnosis tool.

4. Hydration and Meal Journal

Hydration and meal journal template in Excel with daily meals, drinks and a short note

A simple daily record of breakfast, lunch, dinner, how much you drank, and a short note (a walk, a rushed evening). It is a personal diary to look at yourself or to take to a clinician if you have been asked to keep one — not a diet plan, a diagnosis, or nutrition advice. You can write “usual” or leave a meal blank; honesty matters more than a perfect grid. The header counts how many days you have logged.

5. Weekly Food Prep Journal

Weekly food prep journal template in Excel with what was prepared, portions, storage and a change note

A look-back on batch cooking, not a calorie log. Note the prep day, what you prepared, portions, where it was stored, and what you would change next week. Cool and label food promptly. This is a kitchen habit sheet, not medical or dietetic advice. Use it with a meal planner so Sunday’s cooking matches lunches you will actually eat. If a dish was wasted, say so in the last column so the next week’s portions come down.

How to Keep a Food Journal That Works

  1. Choose your goal. Decide whether you want general awareness, to manage calories, to improve energy or to track symptoms. Pick the template that fits.
  2. Write it down as you go. Record food straight after eating. Entries written at the end of the day are usually incomplete.
  3. Be specific about portions. “Rice” is less useful than “1 cup cooked rice”. Use household measures or a kitchen scale for a few days to calibrate your estimates.
  4. Include drinks and extras. Sauces, cooking oil, sugar in coffee and drinks often add more than people expect.
  5. Note how you feel. Hunger before eating, mood and energy add context that numbers alone cannot provide.
  6. Review once a week. Look at the totals and averages, notice one pattern and choose one small change for the next week.
  7. Keep going for at least two weeks. One day is not representative. Two to four weeks shows real habits.

Where to Find Calorie and Nutrient Values

Packaged foods list calories, protein, carbohydrates and fat on the nutrition label; multiply the per-serving values by the number of servings you ate. For fresh foods and home-cooked meals, use a trusted nutrition database from a government food agency or a reputable app, and keep a list of the meals you eat often so you only need to look them up once. Estimates are fine. A food journal is about trends over weeks, so being roughly right every day is more useful than being exact on some days and skipping others.

Paper or Spreadsheet?

Some people find it easier to write in a printed journal kept in the kitchen, while others prefer to type entries on their phone. Both work. If you prefer paper, print the weekly diary and fill it in by hand, then type the totals into the spreadsheet at the end of the week to keep the averages. If you prefer digital, open the daily journal in the Google Sheets app so you can add entries straight after each meal. The best format is the one you will actually use every day.

Tips for Healthy, Realistic Changes

  • Change one thing at a time. Adding vegetables to lunch or swapping a sugary drink for water is easier to keep than a complete diet overhaul.
  • Do not skip meals to hit a number. Long gaps often lead to overeating later. Use the journal to plan balanced meals instead.
  • Watch water as well as food. Many people feel more energetic simply by drinking more water through the day.
  • Be kind to yourself. Treat the journal as information, not a report card. An honest record of a difficult day is more useful than a perfect but inaccurate one.
  • Get professional advice when needed. If you have a medical condition, are pregnant or have a history of disordered eating, talk to a doctor or registered dietitian before changing your diet.

You can also check these important templates like the weekly meal planner templates for planning balanced meals before the week starts, and the daily planner templates for fitting meals, exercise and sleep into your routine.

You may also like the house cleaning checklist templates for keeping the kitchen in order, and the monthly budget templates for keeping your grocery spending on track.

Frequently Asked Questions

What should I write in a food journal?

Write the time, what you ate or drank and the portion size. For more detail, add calories and nutrients, water, hunger, mood and any symptoms afterwards.

How long should I keep a food journal?

Two to four weeks is usually enough to see real patterns. Many people keep a lighter journal longer term to stay aware of their habits.

How are protein, carb and fat percentages calculated?

The daily template multiplies grams of protein and carbohydrates by 4 calories and grams of fat by 9, then divides each by your total calories.

Can I use these food journal templates in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and highlights carry over, and you can fill it in on your phone.

Is a food and symptom tracker a medical tool?

No. It is a personal record that can help you and your doctor or dietitian look for patterns. Always seek medical advice for persistent or severe symptoms.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.