
Meal & calorie tracker for Sheets

Meal & calorie tracker for Sheets
Meal and Calorie Tracker is a Google Sheets tool for recording food intake and tracking calories and macronutrients. Users search for foods from USDA FoodData Central, select a matching entry, enter a portion amount and unit, and mark it for logging. The tracker calculates calories, protein, carbohydrates, fat, and fiber for the portion. Logged entries retain the values recorded at the time, along with the entered amount and its gram equivalent. The spreadsheet includes a daily logging tab, a custom foods and recipes tab, a unit conversion tab, and a dashboard. Users can save frequently eaten foods, create simple recipes, and set calorie and macronutrient targets for each weekday. The dashboard summarizes logged data with weekly averages, target hit days, logging streaks, a weekly budget view, and trend charts. A separate weight tab supports dated weight entries and an optional adult BMI reference; the BMI information is identified as screening information rather than medical advice. The download includes an empty tracker and a version prefilled with about 45 common USDA foods, as well as a quick start guide and walkthrough video. Setup requires a free Google account, Google Sheets in a desktop browser, and a free USDA key. The guide explains the permission process and setup. Daily use on a phone is not guaranteed for the current version.