Body Fat Percentage Tracker in Google Sheets Guide

Yes. You can make a body fat percentage tracker in Google Sheets by recording the date and repeatable measurements, then using a formula to estimate body fat and a chart to follow the trend. A practical setup is a row per check-in with height, neck, waist, hip, and the estimate; the measurement-based formula below uses the U.S. Navy circumference equations and requires measurements in centimetres or inches as specified.

What a body fat tracker can—and cannot—tell you

A tracker is a record-keeping tool, not a direct measurement device. A circumference equation estimates body fat from body measurements; it does not measure fat tissue itself. Other methods, including skinfold calipers, bioelectrical impedance scales, and DEXA scans, also have limitations and can produce different results. Treat the number as an estimate, especially when comparing methods.

The most useful signal for many people is the direction of readings collected consistently over time, alongside other context such as body weight, waist measurement, strength, or how clothes fit. A single reading can move because of measurement technique, hydration, food intake, or normal day-to-day variation. Avoid interpreting a small change as proof that body composition has changed.

Set up the Google Sheets columns

In a blank Google Sheet, put these headings in row 1, then enter one check-in per row. Keep the units in the headings so you do not accidentally mix centimetres and inches:

A: Date
B: Weight (kg), optional
C: Height (cm)
D: Neck (cm)
E: Waist or abdomen (cm)
F: Hip (cm), needed for the female equation
G: Equation category: Male or Female
H: Estimated body fat (%)
I: Notes, such as measurement time or method

Use the same height value for each row unless it has genuinely changed. You can leave weight out if your goal is only to track the estimate. To reduce typing errors, select G2:G and choose Data > Data validation; set a dropdown with the two category labels used by the formula. Google Sheets may show slightly different wording in the validation panel as its interface changes, but the Data menu is where the rule is created.

Use a circumference estimate formula

The U.S. Navy equations use different circumference measurements for men and women. The common versions below expect the relevant circumference values and height in inches. The tracker stores centimetres, so the formula converts centimetres to inches by dividing by 2.54. These equations are a rough estimate, not an assessment for every body type or a substitute for clinical measurement.

With the headings above, data starting in row 2, and the category typed in G2 as Male or Female, place this formula in H2. It leaves the result blank when key measurements are missing or unsuitable, and you can fill it down for later rows:

=IF(OR(C2<=0,D2<=0,E2<=0,G2=""),"",IF(G2="Male",IF(E2>D2,86.010*LOG10((E2-D2)/2.54)-70.041*LOG10(C2/2.54)+36.76,""),IF(G2="Female",IF(AND(F2>0,E2+F2>D2),163.205*LOG10((E2+F2-D2)/2.54)-97.684*LOG10(C2/2.54)-78.387,""),"")))

For example, if a male entry has height 175 cm, neck 38 cm, and abdomen 90 cm, the estimate is about 20.8%. That is a numerical percentage value, not a fraction such as 0.208. Label column H “Estimated body fat (%)” and format it as a number with one decimal place using Format > Number > Custom number format. Do not apply the standard Percent format to this formula output: that format multiplies a decimal value by 100 for display, so it would show 20.8 as 2,080%.

The equation category is part of the formula’s assumptions, not a judgement about identity. These equations were developed around particular anatomical categories and may not be appropriate for transgender people, people using hormone therapy, or anyone whose body does not fit the assumptions. In those situations, consider tracking measurements without generating a formula estimate, or ask a qualified health professional about a suitable method.

Measure consistently for more useful comparisons

Technique can matter as much as the spreadsheet. Follow a consistent measurement protocol, use a flexible tape, and record the reading without pulling the tape tight enough to compress the skin. For the commonly used Navy protocol, the male abdomen measurement is taken horizontally at the navel; the female waist is measured at the narrowest point, and hip circumference at the widest point. Neck placement also has a specified protocol, so consult a reliable diagram or clinician rather than changing the tape position between check-ins.

Measure at a similar time and under similar conditions each time.
Stand naturally, keep the tape level, and take the reading after a normal breath rather than deliberately sucking in.
Repeat a measurement if it seems inconsistent; record the method you use in Notes.
Use the same units throughout. The formula converts centimetres, but it cannot detect a value accidentally entered in inches.

There is no need to measure every day. A weekly or monthly schedule that you can follow consistently is more useful than frequent readings taken under changing conditions. If you choose to measure more often, focus on the longer-term pattern rather than reacting to each entry.

Track change and make a chart

To calculate the difference between consecutive estimates, add a heading such as “Change (percentage points)” in J1. With estimates in H2 and H3 and dates entered in chronological order, put this in J3: =IF(OR(H2="",H3=""),"",H3-H2). If H2 is 20.8 and H3 is 20.4, the result is -0.4 percentage points. This is a difference between percentage readings; it is not a 0.4% relative change.

For a visual trend, select the Date and Estimated body fat columns, then use Insert > Chart. In the Chart editor, choose a line chart and confirm that the date column is used for the horizontal axis. If the columns are not adjacent, select one range and then add the other as a series in the chart setup. Keep the vertical axis and labels clear, and avoid a tightly cropped scale that makes small fluctuations look dramatic.

Google Sheets recalculates formulas when you edit inputs, so the chart updates as new rows are added if its data range includes them. For a simple tracker, you can set the chart range to include extra blank rows in advance. In Excel, the calculation concept is similar, but menu paths differ: Excel uses its ribbon, including Insert > Charts, rather than Google Sheets’ menu bar and Chart editor.

Understand the estimate and its limitations

Do not compare a Navy-equation estimate directly with a smart-scale reading or a scan as though they were interchangeable. Different methods use different inputs and assumptions, so disagreement is not necessarily evidence that one device is broken. If you switch methods, note the change and treat the first result from the new method as a new baseline.

Also distinguish percentage points from percent change. A move from 25% to 24% is a decrease of one percentage point. Relative to the original value, it is a 4% decrease, but that calculation is usually less intuitive for a body-fat log. The row-to-row subtraction formula above reports percentage points, which is generally the clearer comparison.

Body fat percentage is only one measure of health and is not, by itself, a diagnosis or a complete measure of fitness. The estimate may be misleading for some people, including children and adolescents, pregnant people, and people with unusual body proportions. If tracking causes distress, encourages restrictive behaviour, or conflicts with medical advice, stop using it and discuss the concern with an appropriate health professional.

Common spreadsheet problems

Blank result: Check that height, neck, and waist are positive numbers and that G contains exactly Male or Female. The female calculation also needs a positive hip value.
Error from LOG10: The formula requires positive values inside each logarithm. Check for swapped measurements, zeroes, or an incorrect unit.
Implausible estimate: Confirm that the measurements are in centimetres, not inches, and that the waist and neck entries are in the intended columns. Recheck the tape positions before trusting the result.
Wrong displayed scale: The formula returns a value such as 20.8. Format it as a number, not as a standard percentage, or the display will be multiplied by 100.
Chart looks empty: Confirm that the date cells are valid dates, the estimate cells contain numbers, and the selected chart range includes those rows.

For easier review, you can freeze the heading row with View > Freeze > 1 row. You can also use Format > Conditional formatting to highlight missing entries or unusual values, but set any thresholds for your own review purpose rather than presenting them as medical cutoffs.

Privacy and alternatives

Measurements and weight are sensitive personal information. A Google Sheet is stored in your Google account, so check its sharing settings before entering private details. Use the Share button to confirm who has access, and avoid “Anyone with the link” access unless you deliberately want link holders to see the file. If you do not need cloud access, a local spreadsheet or paper log may suit you better.

If you do not want to use an equation, the same sheet can track waist circumference, weight, and dates without an estimated body-fat column. That can be a simpler way to observe change, though waist measurements also vary with technique and do not diagnose health. A clinician or qualified body-composition professional can explain measurement options and their limitations when you need information for a health decision.

Frequently Asked Questions

Can Google Sheets calculate body fat percentage automatically?
Yes. Enter measurements in consistent units and use a formula such as the Navy circumference estimate above. The result is an estimate based on that equation, not a direct measurement.

What measurements do I need for the Google Sheets tracker?
The example needs height, neck, and abdomen for the male equation; the female equation also uses waist and hip circumference. The measurement protocol and equation category affect the result.

Should I format the result as a percentage in Sheets?
Not with the formula shown, which returns values such as 20.8. Use a number format with one decimal place and identify the column as a percentage value. Standard Percent formatting would display 20.8 as 2,080%.

How often should I update the tracker?
Choose a schedule you can repeat under similar conditions, such as weekly or monthly. Consistency and the longer-term pattern matter more than frequent readings or a single result.

Why does my estimate differ from my smart scale?
The tracker and scale use different methods and assumptions. Hydration and other factors can also affect scale readings. Compare results from the same method over time rather than treating different methods as equivalent.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.