If you have ever searched for a free way to track your weight loss progress, creating a weight tracker or nutrition tracker in Google Sheets is an obvious starting point. It is free, works on any device, and gives you full control over your data.
In this guide, you will learn exactly how to build a weight tracker from scratch in Google Sheets — complete with formulas, rolling averages, and a progress chart. Then we will cover why thousands of users choose BunnyCal as the best weight tracker app and weight tracker app free of charge for automatic syncing.
🗂️ What You Need Before You Start
- A free Google account
- Your current weight (in kg or lbs)
- Your height (to calculate BMI, optional)
- 5 minutes to set up the template or download our ready-made Nutrition Tracker Google Sheets template.
📊 Step 1: Create Your Sheet Structure
Open a new Google Sheet and create these column headers in Row 1:
| Column | Header | Purpose |
|---|---|---|
| A | Date | The calendar date of your weigh-in |
| B | Weight (kg) | Your measured weight |
| C | BMI | Auto-calculated based on height |
| D | 7-Day Average | Smoothed rolling average weight |
| E | Notes | Water retention, sick day, period, etc. |
Pro tip: Weigh yourself at the same time every day — first thing in the morning after using the bathroom, before eating or drinking. This minimizes daily variability.
🔢 Step 2: Add Your Core Formulas
BMI Formula (Column C)
BMI = weight (kg) ÷ height (m)²
In cell C2, enter (replace 1.75 with your height in meters):
=B2/(1.75^2)Format this column as a number with 1 decimal place. Drag the formula down for all rows.
7-Day Rolling Average (Column D)
The rolling average is the single most useful formula for weight tracking. Daily weight can fluctuate by 1–3 kg due to water retention, food volume, sodium, and hormones. The 7-day average strips out this noise to reveal your true fat loss trend.
In cell D8 (requires 7 days of data to start), enter:
=AVERAGE(B2:B8)For D9: =AVERAGE(B3:B9), and so on. Or use this dynamic formula from D8 onward:
=IF(ROW()-ROW($D$1)<7,"",AVERAGE(OFFSET(B2,ROW()-ROW($D$8),0,-7,1)))📈 Step 3: Build Your Progress Chart
- Select columns A (Date) and D (7-Day Average)
- Click Insert → Chart
- Choose Line Chart
- Set the X-axis to “Date” and the series to “7-Day Average”
- Add a trendline: Chart Editor → Series → Trendline → Linear
This chart will visually show whether your weight is trending down, up, or plateauing over time.
🧮 Step 4: Add a Summary Dashboard
In a separate section of your sheet, add these summary cells:
| Metric | Formula |
|---|---|
| Start Weight | =B2 |
| Current Weight | =B&(COUNTA(B:B)) |
| Total Lost | =B2-B&(COUNTA(B:B)) |
| Days Tracked | =COUNTA(A:A)-1 |
| Weekly Rate | =(B2-B&(COUNTA(B:B)))/((COUNTA(A:A)-1)/7) |
A healthy, sustainable fat loss rate is 0.5–1.0 kg per week (1–2 lbs). Faster than this usually indicates muscle or water loss rather than pure fat.
⚡ Step 5: Conditional Formatting for Instant Feedback
Add color coding to your BMI column to instantly see where you stand:
- Select column C (BMI values)
- Format → Conditional Formatting
- Add rules:
- BMI < 18.5 → Light blue (Underweight)
- BMI 18.5–24.9 → Light green (Healthy)
- BMI 25–29.9 → Light orange (Overweight)
- BMI ≥ 30 → Light red (Obese)
🚧 The Honest Limitation of Google Sheets Weight Tracking
A Google Sheets weight tracker works well — until you realize it only solves half the problem.
Weight loss is driven by a calorie deficit. To actually move the number on your spreadsheet, you need to know:
- How many calories you are eating each day
- Your protein, carbs, and fat breakdown
- How many calories you are burning through activity
Your Google Sheet can track the outcome (your weight), but it cannot track the inputs (your food and activity). That requires a separate food logging app — and manually copying data between two tools adds friction that most people abandon within 2–3 weeks.
🐇 The Automatic Alternative: BunnyCal
BunnyCal solves this by combining weight tracking, calorie logging, macro tracking, and step counting in one app:
- Automatic weight trend graphs: Log your daily weight and see rolling averages, trend lines, and goal projections automatically
- AI food photo logging: Snap a photo of your meal — calories and macros are added instantly, no manual entry
- Integrated step counter: Your daily step burn is calculated and subtracted from your calorie budget automatically
- Calorie and weight correlation: See exactly how your eating patterns correlate with your weight trend week over week
The result is a complete picture of your fat loss inputs and outputs — without maintaining a spreadsheet.
📋 Free Google Sheets Weight Tracker Template
If you prefer the spreadsheet approach, here is a summary of the complete template structure:
Sheet 1: Daily Log
- A: Date | B: Weight (kg) | C: BMI | D: 7-Day Avg | E: Notes
Sheet 2: Dashboard
- Start weight, current weight, total lost, days tracked, weekly rate, goal date estimate
Sheet 3: Chart
- Line chart of 7-day rolling average with linear trendline
🎯 Key Takeaways
- Build your Google Sheets tracker with a 7-day rolling average formula — it is the most accurate signal of true fat loss progress
- Track your weight at the same time every day to minimize variability
- The spreadsheet tracks your outcome (weight), but you need a food logging tool to track the inputs that drive it
- For a fully automatic solution, BunnyCal combines weight tracking, calorie logging, and step counting without any manual spreadsheet work