Skip to content
Macro Tracker cover: a sample sheet with protein (g), carbs (g) and fat (g) and a stacked chart, beside the Dashboard, Food log and Daily targets tabs

Macro Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This tracker suits anyone who counts macronutrients in grams rather than calories alone. The Food log tab lists each food with its meal, protein, carbs and fat in grams, plus an energy column that converts the grams into kilocalories. The Dashboard totals each macro, shows the protein share of energy and charts grams by meal. The Daily targets tab turns an energy goal and a macro split into gram targets.

Weigh food when you can, because a label's grams apply only to the amount you eat. Set the split on the Daily targets tab first, then adjust it after a week of logging. The three shares must total 100 percent, and the share check line shows whether they do. Read the Dashboard after your last meal rather than midway through the day, since the totals only mean something across a full day.

Useful for

  • Setting a protein target for a strength training block
  • Checking the carb and fat split across a week
  • Comparing grams per meal with a dietitian's plan

What's included

  • 4 tabs: Dashboard, Food log, Daily targets, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Food log: a table
  • Daily targets: a ready-to-fill form
  • 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

How are the calories worked out?

Protein and carbs each give 4 kilocalories per gram, and fat gives 9. The energy column multiplies each macro by its factor and rounds the total for each food. This is the usual convention, though some labels differ slightly.

What is a good protein share?

The right share depends on your goals, body and medical history, so no one split suits everybody. The sample split uses 30 percent protein, 40 percent carbs and 30 percent fat as a rough start. Run it by a dietitian or doctor if a condition affects your diet.

Why do my totals miss the daily targets?

The targets are a plan, and the food log is what you actually ate. A gap of a few grams a day is normal. Look at the trend over a week, and adjust the targets or your portions if the gap stays large.

  • #fitness-tracker
  • #macro-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…