Calorie & Macro Tracker | Google Sheets Template

Count calories and macros without an app or a subscription. Pick a food from the list, type the servings and this Google Sheet adds up your calories, protein, carbs, fat and fibre, compares them with your targets and draws 6 charts for you.

WHAT'S INSIDE (8 tabs)

- START HERE: quick setup steps and tips

- Dashboard: latest day vs your targets (calories, protein, carbs, fat), what is left for the day, 7-day average, current weight and change, calories per day vs target, calories by macro, macros by meal, 7-day macro split, progress to your goal weight, your top foods and the last 7 days

- Food Log: date, meal, food (dropdown) and servings, with serving size, calories, protein, carbs, fat and fibre filled in automatically

- Daily Totals: one line per day with calories vs target, difference, macros, protein vs target and a status (Under, On target, Over)

- Weekly Averages: Monday to Sunday averages for calories, macros, fibre and weight

- Weight Log: weigh-ins with change, total change and distance to your goal

- Food Library: 70 everyday foods with calories, protein, carbs, fat and fibre per serving, plus room for your own

- Setup: kg or lb, height, age, activity level, goal (lose, maintain or gain), calorie target, macros as a % split or grams, meal names and food categories

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Set your targets once, then log what you eat. Totals, averages and charts update automatically.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for you (the food library is kept in both)

- Estimated maintenance calories and a suggested target for your goal (Mifflin-St Jeor formula)

- Set macros as a % split (for example 25 / 45 / 30) or type your own gram targets

- Works in kg or lb

- Food values are typical averages for generic foods. Edit them to match the labels of what you buy

- A simple log for your own records, not medical or nutrition advice

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, reply to your download email and I will be happy to help