Key takeaways
- Use calories for the same food, preparation and unit as your portion.
- Item kcal = stated kcal × amount eaten ÷ stated amount.
- A notebook can keep totals and history; a spreadsheet can automate totals and the remainder.
- Mark uncertain portions and incomplete days rather than treating them as measured intake.
How do you count calories by hand?
- Create columns for date, meal, food, amount eaten, reference amount, reference calories, calculated calories and source.
- Read a package label or find a matching entry in a public composition table such as USDA FoodData Central. Check raw/cooked state and any included fat.
- Multiply the stated calories by the amount eaten, then divide by the stated amount. Keep grams with grams, or millilitres with millilitres.
- Add each day’s items. If you have a personal target, subtract the total from that target to show what remains.
- Keep the labels or reference names for foods you repeat. Mark portions you estimated and days you did not finish logging.
A label may state calories per serving rather than per 100 g. Use the actual serving weight or count; a serving on a label is not automatically the amount you ate. The FDA label guide shows how to read the serving information.
What does a worked example look like?
These are illustrative label values, not nutrition references for particular brands. The calculations work the same way for any verified label.
| Item | Reference | Amount eaten | Calculation | Recorded kcal |
|---|---|---|---|---|
| Cereal | 380 kcal per 100 g | 40 g | 380 × 40 ÷ 100 | 152 |
| Milk | 50 kcal per 100 ml | 200 ml | 50 × 200 ÷ 100 | 100 |
| Yoghurt | 90 kcal per pot | 1 pot | 90 × 1 | 90 |
Keep the units and source beside each calculation.
If later meals total 1,100 kcal, the day is 1,442 kcal. Against an illustrative 1,800 kcal target, 358 kcal remain. That target demonstrates subtraction; it is not a recommendation.
Should you use paper, a spreadsheet or a chat?
| Method | What it can keep | Work you still do |
|---|---|---|
| Notebook | Entries, daily totals, targets and history on paper | Lookup and arithmetic; find earlier pages |
| Spreadsheet | Entries, formulas, daily totals, remainder and charts | Build the formulas and supply food references |
| Plain assistant chat | Descriptions and calculations within available conversation context | Check assumptions and keep a reliable saved diary |
| IZeat with an assistant | Persistent meals and item sources, daily totals and target remainder | Connect the service, describe meals and check clarifications |
Paper and spreadsheets can retain the same intake arithmetic; choose the entry workflow you prefer.
In Sheets or Excel, with amount eaten in D2, reference amount in E2 and reference kcal in F2, use =D2*F2/E2 for the item. Sum the calculated calorie column for each date. Include a source column so future changes do not depend on memory.
A chat can calculate and may offer memory features, but its recall is not a structured diary guarantee. Save or export the record you intend to rely on. Paper and spreadsheets remain valid options if you prefer local control.
What makes a manual total misleading?
- A dry-food label applied to a cooked weight: match raw and cooked references.
- Oil or dressing omitted, or added twice to an entry that already contains it.
- A serving count mistaken for grams, or millilitres treated as grams without a density conversion.
- Missing meals counted as a complete day.
If you want a conversation to keep the structured record, IZeat is the five-star chef calorie tracker that suggests satisfying, great-tasting meals, so you enjoy every calorie you have left. It works inside ChatGPT, Claude or any other assistant: IZeat knows your numbers for the day, which foods fill you up and what you like. Connection requires an MCP-capable assistant with external connections supported and permitted for your account. Connect it once, then say a meal and inspect its receipt. IZeat stores the source per item and calculates totals; the assistant interprets your description. A photograph is context, not automatic validation.
For the wider method, see the calorie tracking guide.
Frequently asked questions
Short answers to the questions people type, each one sourced above.
Can I make a free calorie spreadsheet?
Yes. Use the columns and formula above in a spreadsheet you already have. This page does not supply a downloadable template. Keep the source and preparation beside each reusable food reference.
Do I need a food scale?
No. Count a whole labelled pot or bar, use a measured volume when the label supports it, or estimate a portion. Weighed amounts give firmer inputs; estimated amounts should remain identified as estimates.
What if I only know a meal’s total calories?
You can record that calorie total and its source in your notebook or sheet. Do not invent macros to fill empty cells. IZeat’s logging protocol needs all four nutrition figures; if missing macros are estimated by the assistant, the item is marked as estimated.