A calorie counting spreadsheet is the first tool most people reach for when they decide to get serious about food. It costs nothing, it opens on your phone and your laptop, and once the formulas are in place it does the math for you.
The catch is somewhere else. A spreadsheet adds up perfectly, but it has no idea how much rice you scooped, it does not follow you to a restaurant, and it charges you a few minutes of typing at every meal.
Below you get a template you can rebuild in fifteen minutes, with the right columns and formulas, a sample day filled in with USDA values, and an honest look at the exact point where most people quit their sheet, plus what to do when that happens.
What a calorie counting spreadsheet is actually for
A good sheet answers two questions a day: how much you ate and how much is left before you hit your target. Everything else, from color-coded meals to pretty charts, is decoration.
It works best for three kinds of people:
- Beginners who want to see where the day's calories come from, line by line.
- Control lovers who want to see every formula and not depend on an app.
- People with a set target, such as 1,800 calories and 100 g of protein, who need to know whether the day closed on plan.
Tracking works, and the evidence backs it. A systematic review in the Journal of the American Dietetic Association found a consistent link between self-monitoring of diet and weight loss. The detail that matters: the effect shows up in people who log consistently, not in people who log for three days and stop.
Free calorie counting spreadsheet template
Open a blank file in Google Sheets or Excel and type these headers in row 1. This is the minimum that covers calories and protein without turning into a weekend project.
| Column | Header | What goes in it |
|---|---|---|
| A | Date | day of the entry |
| B | Meal | breakfast, lunch, snack, dinner |
| C | Food | same name as in your reference database |
| D | Grams | weight of what went on the plate |
| E | Calories per 100 g | value from the database |
| F | Protein per 100 g | value from the database |
| G | Calories | formula =D2*E2/100 |
| H | Protein (g) | formula =D2*F2/100 |
Drag the G2 and H2 formulas down. To total the day, use =SUMIF(A:A,A2,G:G), where A2 holds the date, and repeat it on column H for protein.
Weigh in ounces? Add a column for ounces and convert with =oz*28.35 to get grams. Then build a "Foods" tab with the 30 items you eat most and pull calories and protein with VLOOKUP. That cuts out the database search on every entry, which is the slowest step.
A sample day, filled in
Values per 100 g from the USDA FoodData Central database, rounded:
| Meal | Food | Amount | Calories | Protein |
|---|---|---|---|---|
| Breakfast | Whole wheat bread | 2 slices (64 g) | 161 | 7.9 g |
| Breakfast | Hard-boiled egg | 1 large (50 g) | 78 | 6.3 g |
| Breakfast | Banana | 1 medium (118 g) | 105 | 1.3 g |
| Lunch | White rice, cooked | 1 cup (158 g) | 205 | 4.3 g |
| Lunch | Black beans, cooked | 1/2 cup (86 g) | 114 | 7.7 g |
| Lunch | Chicken breast, roasted | 4 oz (113 g) | 186 | 35.0 g |
| Lunch | Olive oil | 1 tbsp (13.5 g) | 119 | 0 g |
| Subtotal through lunch | 968 | 62.5 g | ||
Look at the olive oil. You never see it on the plate, yet it is 119 calories that many sheets simply leave out. Measure the oil before it goes in the pan, or log one tablespoon per serving.
ContaCal
Count calories and macros with just 1 photo
Snap your meal and the AI instantly calculates calories, protein, carbs and fat.
Or see the ContaCal calorie tracking app.
4 mistakes that make a calorie counting spreadsheet useless
The formula rarely gets it wrong. The error lives in what goes into columns D and E.
- Mixing raw and cooked values. Cooked rice has about 130 calories per 100 g and dry rice about 365. Weigh it cooked, log the dry value, and that line nearly triples. Our guide on how to use a food scale shows how to avoid it.
- Eyeballing portions. "A scoop" can be 80 g or 180 g. Without a scale, lean on tablespoon to grams conversions and weigh each serving spoon once.
- Logging only main meals. Creamer in the coffee, the afternoon granola bar and Saturday's beers stay off the sheet and add up to more than any portion error.
- Filling it in at night, from memory. Memory shrinks portions. Log right after you eat, even if it is one quick line.
Where a calorie counting spreadsheet stops working
The sheet breaks in the same place for almost everyone: the friction of every single entry. Each row asks for four actions. Find the food in the database, weigh it, type the weight and check that the formula pulled the right value.
At home, with a scale and some time, that is doable. The trouble starts in the moments that look nothing like that:
- Restaurants and office lunches. No scale, and the plate has five things mixed together.
- Mixed dishes. Lasagna, chili and casseroles have no simple row in any database.
- Your phone. A sheet on a small screen means tiny cells and a keyboard covering half the view.
- Weekends. Barbecues, parties and trips break the routine, and one blank row turns into a blank day.
This is where consistency drops, and consistency is exactly what makes tracking work. In the Kaiser Permanente study published in the American Journal of Preventive Medicine, people who kept daily food records lost twice as much weight as those who kept none. The gain came from regularity, not from the format.
So the real question is not "sheet or app?". It is "which tool will I still be using in week three, on a Saturday, away from home?".
Spreadsheet, notebook or photo app: an honest comparison
| Spreadsheet | Notebook | Photo app | |
|---|---|---|---|
| Cost | free | free | free and paid plans |
| Automatic totals | yes, with formulas | no | yes |
| Food lookup | manual or VLOOKUP | manual | recognized from the image |
| Away from home | hard | possible, no math | photo of the plate |
| Control over formulas | full | full | the app's |
| Best for | calibrating and learning | habits and emotions | sticking with it for months |
No option wins everything. If you like seeing the raw math, keep the sheet at home and use the app where it cannot reach. What you cannot afford is having no record on the days that matter most. If what you want is the journaling habit, with moods and times, a weight loss food journal is the better format.
How to use the sheet in the first weeks, and what comes next
A path that works for most people:
- Weeks 1 and 2: log everything in the sheet and weigh what you cook at home. The goal is to learn what your usual servings of rice, beans and meat really weigh.
- Weeks 3 and 4: build the frequent-foods tab and check whether your daily average matches your target. If you still need that number, see how many calories to lose weight.
- From then on: keep logging with whatever tool asks the least of you. For many people that is a photo of the plate in ContaCal, with the sheet saved for occasional spot checks.
Important: tracking food is not right for everyone. If the sheet brings guilt, anxiety or an urge to make up for what you ate, stop and talk to a registered dietitian or a mental health professional, because these are warning signs of an eating disorder. If you have diabetes or kidney disease, are pregnant or breastfeeding, or take weight loss medication, set calorie and protein targets with a healthcare provider.




