Calorie Tracker — Google Sheets Template
One-Minute Summary
This Google Sheets calorie tracker lets you log meals and snacks with calorie counts. A daily total auto-calculates and compares to your target. Simple, no-frills design — no app download, no subscription. Make a free copy to your Drive and start tracking. Ideal for weight loss, maintenance, or just understanding your eating patterns.
Preview & Access
Make a Copy (Google Sheets)How to Access
- Click the button above
- Sign in to Google (free)
- The template opens in your Drive
- Edit, share, or download as needed
What’s in this template
This Google Sheets calorie tracker uses a simple daily log: one row per meal type, columns for food description and calories. A Target cell at the top holds your daily goal. A SUM formula totals your calories and a simple subtraction shows remaining. A second tab summarizes the week.
Tab 1: Daily Log
Rows for Breakfast, Lunch, Dinner, Snacks. Optional columns: Time, Notes. The Total row sums all calories. A Remaining cell subtracts Total from Target. Conditional formatting can highlight when you’re close to target or over.
Tab 2: Weekly Summary
References the daily totals from the log. Shows each day’s calories and a weekly average. Add a simple bar chart (Insert → Chart) to visualize daily variance.
Key features and use cases
Lightweight tracking: No app to download, no subscription. If you already use Google Drive, this fits in. Quick to log, easy to review. Good for people who tried calorie apps and found them overwhelming.
Target flexibility: Change your target anytime. Cutting for a deadline? Lower it. In maintenance? Raise it. The formulas update. Some people alternate — lower on weekdays, higher on weekends. You can model that with a weekly target instead of daily.
Pattern recognition: The weekly tab reveals habits. Do you consistently overeat on Friday? Under-eat on Monday? Use that to plan — maybe meal prep more for Monday, or build in a controlled Friday treat.
How to customize
Adding macros later: If you want protein/carb/fat in addition to calories, add columns. The structure is the same — just more columns to fill. Or use our Macros Tracker template for built-in macro support.
Multiple users: Duplicate the tab for each person. Share the sheet with family. Everyone logs in their own tab. Useful for couples dieting together or parents tracking kids’ intake.
Date range: Duplicate the Daily Log tab for each week. Name them “Week 1,” “Week 2,” etc. Keeps history without one giant sheet. Or use a single log and add a Date column, then filter by week in the summary tab.
Related Templates
- •
- •
Frequently Asked Questions
Is this really free?
Yes. Make a copy and it's yours. No signup, no trial, no watermark. You need a free Google account.
How do I find calorie amounts for foods?
Use nutrition labels, USDA FoodData Central, or apps like MyFitnessPal. For restaurant food, check the menu or chain websites. Estimates are fine — consistency matters more than precision.
Do I need to track every single calorie?
No. Ballpark estimates work. Missing small things (a splash of milk, a few nuts) won't derail progress. Focus on main meals and larger snacks. Perfection isn't required.
Can I share this with a dietitian?
Yes. Click Share, add their email, and give them Viewer or Commenter access. They can review your log and give feedback. Export as PDF (File → Download → PDF) if they prefer a snapshot.
What if I go over my target?
Log it anyway. One day over won't ruin progress. The data helps you learn — maybe certain days or situations lead to overeating. Use that insight to plan better (e.g., prep snacks for busy days).