Skip to content
Calorie Tracker cover: a sample sheet with entries logged, total calories and average per entry and a pie chart, beside the Dashboard and Food log tabs

Calorie Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This tracker suits people who count calories and want a simple daily record. The Food log tab has one row per item, with the date, the meal (breakfast, lunch, dinner or snack), the food, a portion note and its calories. The Dashboard totals calories and entries, shows the average per entry, and charts the share of calories taken at each meal in a pie.

Take each figure from the nutrition label or a food database, and use the same source for a repeated food. Log drinks that contain calories, since they add up faster than most people expect. For a restaurant meal, enter your best estimate and say so in the portion column. Compare the meal split across a week to see where most of your calories fall.

Useful for

  • Counting calories during a weight-loss plan
  • Checking where most calories fall in a typical day
  • Sharing a short food record with a dietitian before a visit

What's included

  • 3 tabs: Dashboard, Food log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Food log: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Food log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Where do I find the calories for a food?

Use the nutrition label on packaged food, or a reputable food database for fresh and home-cooked food. Weigh or measure the portion when you can, because the same food in a different amount gives a different total. Stick with one source for repeat foods.

How do I log food I cooked for several people?

Work out the total calories for the whole dish, then divide by the number of servings. Log one row for your share, and write the serving count in the portion column, such as one serving of four.

Is calorie counting right for everyone?

Counting can help some people notice patterns, but it suits some people better than others. If you have had disordered eating in the past or a medical condition, ask your doctor or a registered dietitian before you track closely.

  • #fitness-tracker
  • #calorie-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More fitness tracker templates

See all 16

Also in Business operations

All business operations templates
Get this template

Preparing your template…