We want the formula to apply to the entire column other than cell C1. Click on the second cell in the column.Keeping that in mind, we can use a simple multiplication formula to calculate the calories burned per day. In general, 0.04 calories are burned per step for the average person. The next column in this spreadsheet will calculate how many calories are burned depending on the steps taken. But, you could use Google Apps Script to import Google Fit steps. You can log these in manually every day, and there is no need to enter a formula here. These can be monitored using a mobile application or a fitness tracker, as I mentioned before. The next column I’m adding to the spreadsheet is the steps taken during the day. Finally, click on the blue dot at the bottom-right edge of the screen and drag it down to fill in the column with the dates.This will add one day to the starting date This will ensure that the data the cell contains is taken as a date. Click on Format in the top bar and click on Number with the cell selected.Type in the date following the MM/DD/YYYY format.Click on the cell where you wish to input the date.Although you can use the DATE function to create the dates, I recommend simply writing the first date and using the suggested autofill feature. How to Build a Health Tracker Using Google Sheetsįirst, we need to add dates to our spreadsheet. You could also download a health app like Google Fit or Apple Health on your phone.Ī device compatible with Google Fit can import directly into sheets too with some pretty complicated scripts. We recommend having some sort of step counter. But, once you learn how to do this it’s easy to add extra parameters too.
This basic health tracker aims to log the calories you burn per day with steps. What Do I Need to Use the Google Sheets Health Tracker? Read on to learn how to make a fitness tracker in Sheets. We are going to be using several fitness formulas to achieve this. The main reason to use Google Sheets is that it is free, and you can use it on almost all platforms like Android, iOS, and PC. It’s simple, just create your own fitness tracker on Google Sheets.
If you find an application that fits all your needs, chances are that it’s a paid application. Some allow you to track your gym progress, while some count your calories. Most applications on Android or iOS cant fulfill all of your health tracking needs in one application.