Meal Prep Tracker Excel Template: Plan, Prep & Track Macros Without an App

Published August 2026 · 14-minute read · Category: Fitness & Nutrition

Most meal prep fails at the same point every week: Thursday. You planned Sunday's meals with good intentions, but by midweek the plan has drifted, you're guessing what's left in the fridge, and the takeaway app is open. The problem isn't willpower — it's that the plan lives in your head or on a sticky note, not in a system that calculates what you actually need.

A meal prep tracker template fixes that. It's a spreadsheet that plans your meals for the week, calculates calories and macros automatically from the foods you select, generates your grocery list, and keeps a running check on whether you're hitting your nutrition targets — all without a subscription app, an account, or an internet connection.

This guide covers what a good template includes, how to calculate your own macro targets, how to build a tracker from scratch in Excel (with the exact formulas), and how a template compares to apps like MyFitnessPal. Everything here works in Excel, Google Sheets, and LibreOffice.

Quick Answers: Meal Prep Tracker Templates

What is a meal prep tracker template?

A pre-built spreadsheet that plans your weekly meals, auto-calculates calories and macronutrients from a food database, generates your grocery list, and tracks your progress. The core mechanic: pick a food from a dropdown, enter the grams, and VLOOKUP formulas do the nutrition math for you.

How do I track macros in Excel?

Build a food database with calories, protein, carbs, and fat per 100g; use a dropdown to select foods in your meal planner; then use =VLOOKUP(food, FoodDB, column, FALSE) * grams / 100 to calculate nutrition for any portion. Sum by day and compare against your targets.

How much does a meal prep tracker template cost?

Between $0 and $15. Free if you build it yourself (5-10 hours of work), or $9 USD one-time for a complete 7-tab pre-built template with a 100+ food database. Subscription macro apps run $20-25/month — $240-300/year.

What is the best meal prep tracker template?

The best meal prep tracker template for most people is a 7-day Excel planner with a built-in food database, auto-calculating macros, and an auto-generated grocery list — meal planning, macro tracking, and shopping in one offline file with no subscription. The Meal Prep & Macro Tracker is a complete $9 example.

How do I calculate my macro targets?

Multiply bodyweight (lbs) by 12-13 to lose fat, 14-16 to maintain, or 16-18 to gain. Set protein at 0.7-1g per pound of bodyweight, then split remaining calories between carbs and fat based on your activity and preference.

Is Excel or Google Sheets better for meal prep tracking?

Google Sheets if you edit from your phone at the store or share with a partner; Excel for offline reliability. Templates built on standard formulas (VLOOKUP, SUMIF, data validation) work identically in both — plus LibreOffice Calc and Apple Numbers.

How do I create a grocery list from a meal plan?

Use =SUMIF(Planner!B:B, food, Planner!C:C) to total the grams of each food across your weekly plan. Any food with a total above zero goes on the list, sorted by store aisle. The whole list builds itself in one formula refresh.

What a Meal Prep Tracker Template Actually Includes

Not all meal prep spreadsheets are equal. Most free templates online are just a blank weekly grid with "Breakfast / Lunch / Dinner" headers — a meal plan, but not a meal prep tracker. The difference matters: a plan records intentions; a tracker calculates nutrition, generates shopping quantities, and shows whether you hit your targets.

A complete meal prep tracker template includes seven components:

  1. A food database. At minimum 100 common foods, each with calories, protein, carbs, and fat per 100g. This is the engine of the whole system — without it, every meal must be nutritionally calculated by hand.
  2. A 7-day meal planner. Rows for breakfast, lunch, dinner, and snacks; columns for the seven days. Each cell lets you pick a food from a dropdown (data validation against the food database) and enter a gram amount.
  3. Auto-calculating macros. Formulas that pull nutrition data from the database for each food selected and scale it to the portion entered. This is what turns a menu into a nutrition system.
  4. A daily totals panel. Sum of calories, protein, carbs, and fat per day, ideally colour-coded against your targets — green when you're within range, amber when close, red when you've missed.
  5. An auto-generated grocery list. Every unique food in the plan, with the total grams needed for the week. This is the single biggest time-saver: the plan and the shopping list can never go out of sync.
  6. A meal prep schedule. A cooking plan for your prep session — what gets batch-cooked Sunday, what's cooked fresh, what gets frozen.
  7. A progress tracker. Weekly weight or measurement log with a simple trend, so the plan can be adjusted based on real results rather than guesses.
Key takeaway: If a template doesn't have a food database and auto-calculating macros, it's a menu — not a tracker. The database-to-planner link is what saves you the 10-15 minutes of manual nutrition math per day that makes most people quit tracking within two weeks.

Step 1: Calculate Your Macro Targets (Real Numbers)

Before any template is useful, you need targets. The standard method, used across evidence-based nutrition coaching, takes three steps:

1. Estimate daily calories

Multiply bodyweight in pounds by a factor matched to your goal:

An 80 kg (176 lb) moderately active man maintaining would target roughly 176 × 15 = 2,640 calories. A 65 kg (143 lb) woman aiming for gradual fat loss would target roughly 143 × 12.5 = 1,790 calories.

2. Set protein first

Protein is the one macro with a firm evidence-based range: 0.7-1 g per pound of bodyweight (1.6-2.2 g/kg) for anyone training. The 80 kg man targets 160-176g; the 65 kg woman targets 100-143g. Protein is set first because it protects muscle in a deficit and drives recovery — the rest of the budget is negotiable, protein isn't.

3. Split the remainder between carbs and fat

Whatever calories remain after protein get split by activity and preference. Endurance training leans carbs (50-55% of total calories); sedentary days and low-carb preferences lean fat (30-35%). Both work — adherence beats optimisation.

Worked example — 80 kg male, maintenance, trains 4x/week

Calories: 176 lb × 15 = 2,640 kcal

Protein: 176 × 0.9 = 160g = 640 kcal

Remaining budget: 2,640 − 640 = 2,000 kcal. Split 55/45 toward carbs (4x weekly training):

Carbs: 1,100 kcal ÷ 4 = 275g · Fat: 900 kcal ÷ 9 = 100g

Final targets: 2,640 kcal · 160g protein · 275g carbs · 100g fat (check: 640 + 1,100 + 900 = 2,640 ✓). A good template has a target row above each day so you can see these numbers against your actuals at a glance.

Step 2: How to Build a Meal Prep Tracker in Excel From Scratch

If you'd rather build than buy, here's the minimum viable build. Expect 5-10 hours including the food database — the database alone is the bulk of the work, since each food needs accurate per-100g values for four nutrients.

Tab 1: Food Database

Five columns: Food, Calories, Protein (g), Carbs (g), Fat (g) — all per 100g. Name the range (Formulas → Name Manager → "FoodDB") so formulas stay readable. A 100-row database covering the foods you actually eat weekly beats a 10,000-row download you'll never search. You can pull values from any USDA-style food composition source.

Tab 2: Meal Planner

Rows: Breakfast, Lunch, Dinner, Snack 1, Snack 2. Columns: Day, Food (dropdown via data validation pointing at FoodDB column 1), Grams, then four formula columns:

Cell B2 is the food selected from the dropdown; C2 is the gram amount. The /100 converts per-100g values to your actual portion. One formula, four nutrient columns, every meal calculated the moment you enter a portion.

Tab 3: Daily Totals

Use =SUMIFS to roll each day up: =SUMIFS(Planner!E:E, Planner!A:A, "Monday") for Monday's calories, repeated for each macro. Add conditional formatting (green/amber/red) against your target row. This is the panel you'll actually look at every morning.

Tab 4: Grocery List

For each food in the database: =SUMIF(Planner!B:B, A2, Planner!C:C) totals the weekly grams needed. Filter out the zeros, sort by store section, done.

The build is straightforward spreadsheet work — the time sink is the food database. That's exactly why pre-built templates exist: the formula logic is 30 minutes, the 100+ food database with verified per-100g values is the product.

Meal Prep Tracker Template vs Macro Apps: Honest Comparison

Macro tracking apps are good products. But for meal prep specifically — planning a week ahead, batch cooking, and shopping once — a spreadsheet has structural advantages. Here's the honest comparison:

FeatureFree app (MyFitnessPal free)Premium app (MFP / Cronometer)Excel template (pre-built)DIY spreadsheet
Cost$0 (ads, locked features)$20-25/month ($240-300/yr)$9-15 once$0 + 5-10 hrs
Plan meals a week aheadClunky — built for logging past mealsClunky — samePurpose-built 7-day gridWhatever you build
Auto-calculated macros per mealYes (huge database)YesYes, from 100+ food databaseYes, if you build the formulas
Auto-generated grocery listNoNoYes — totals grams for the weekYes, if built
Meal prep / batch-cook scheduleNoNoYesManual
Works offlineNoLimitedFully — it's a fileFully
Data ownershipTheir platformTheir platformYour file, foreverYour file
Phone logging of past mealsBest in classBest in classView-only on mobileView-only
Ad-freeNoYesYesYes

The pattern: apps win at retrospective logging ("what did I just eat?"); spreadsheets win at prospective planning ("what will I eat this week, and what do I need to buy?"). Meal prep is prospective by definition — you're deciding Thursday's lunch on Sunday. Some people run both: app for the day-of logging, template for the weekly plan and shop. But if you're prepping your meals in advance and eating what you planned, the template alone covers both jobs, because the plan is the record.

How Much Does a Meal Prep Tracker Template Cost?

Direct answer: a good one costs $9-15 as a one-time purchase, or free if you build it yourself over a weekend. What you're paying for isn't the grid — it's the 100+ food database with verified nutrition values, the formula wiring between planner and database, and the grocery list automation. Against a $20/month premium app subscription, a $9 template pays for itself in two weeks and saves $230+ in year one.

Free options exist — search "meal planner template" and you'll find hundreds of blank weekly grids. Just check the component list above before committing: if there's no food database, no dropdowns, and no macro math, you're downloading a menu with formatting, and you'll be doing the nutrition math by hand within a week.

The Weekly Meal Prep Workflow (How to Actually Use It)

A template only works inside a routine. Here's the workflow that survives past Thursday, designed around one 45-minute planning session and one 2-hour cook session per week:

  1. Saturday, 15 minutes — plan. Duplicate last week's plan tab (or pull from your 4-week rotation), swap the meals you're bored of, and check the daily totals panel. Adjust portions until each day lands within ±5% of your calorie and protein targets.
  2. Saturday, 5 minutes — shop. Open the auto-generated grocery list. Delete anything you already have. Order the rest by store section and shop once.
  3. Sunday, 2 hours — prep. Follow the prep schedule: batch-cook proteins and carbs, portion into containers, prep snacks. Foods that don't survive 4 days (salad greens, cut fruit) get flagged for a midweek 15-minute top-up.
  4. Mon-Fri — eat and glance. Because you're eating what you planned, tracking is mostly passive. Glance at the totals panel each evening; if you deviated (work lunch, dinner out), enter what you actually ate — the dropdown makes it a 30-second correction.
  5. Sunday, 5 minutes — review. Log your weekly weight in the progress tracker. Trend flat for 2 weeks while targeting fat loss? Drop daily calories by 100-150 and re-run the plan. This feedback loop is the whole point.
Key takeaway: The 4-week rotation is what makes this sustainable. Once you've built four weeks of plans that each hit your macros, meal planning stops being a weekly creative task and becomes a 5-minute shuffle. That's also why a template with a rotation tab beats a blank planner — the blank one makes you start from zero every week.

Five Mistakes That Kill Meal Prep Tracking

  1. Tracking to the gram forever. Weigh everything for your first two weeks to calibrate your eyeball portions. After that, ±10g on a 150g portion is invisible in your weekly trend. Perfectionism is what makes people quit, not inaccuracy.
  2. Planning seven dinners you've never cooked. Week one should be meals you've made before. Novel recipes triple your prep time and guarantee the rotation dies. Add one new recipe per week, maximum.
  3. No buffer meals. Life happens — plan two emergency meals per week (frozen protein + microwave rice + frozen veg, macro-counted in the database). A plan with no slack breaks on the first unexpected late night.
  4. Ignoring the weekly trend. Daily weight fluctuates 1-2 kg from water, sodium, and carbs. Review the weekly average only; adjust targets only after two flat weeks. Adjusting after one bad day creates a see-saw nobody sustains.
  5. Prepping food you don't like eating. A perfectly macro-balanced container of boiled chicken and broccoli is a plan you'll abandon by Wednesday. Hit your macros from foods you actually enjoy — the database doesn't judge.

The Complete Template: Meal Prep & Macro Tracker

Everything in this guide — the 100+ food database, dropdown meal planner, auto-calculating macros, auto-generated grocery list, prep schedule, progress tracker, and a 4-week rotation system — is packaged in the Meal Prep & Macro Tracker, a 7-tab Excel template built exactly around the workflow above.

Meal Prep & Macro Tracker — 7-Day Excel Planner

7 tabs: Dashboard, 100+ Food Database, 7-Day Meal Planner, auto-generated Grocery List, Meal Prep Schedule, Progress Tracker, and 4-Week Rotation. Pick foods from dropdowns, enter grams, and every macro calculates automatically. One-time $9 — no subscription, works offline in Excel, Google Sheets, LibreOffice, and Numbers.

Get the Template on Gumroad →

Pair it with a training plan and the system is complete: the 12-week home workout plan covers progressive training with no equipment, and the 90-day habit tracker keeps the prep-session streak alive while the new routine bedded in. If meal prep is part of a broader life reset, the 30-day productivity reset walks through rebuilding your whole weekly operating system, meals included.

Related guides from Kowhai Goods