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 also work with Google Docs and Open Office.Most applications on Android or iOS cant fulfill all of your health tracking needs in one application. If this spreadsheet does not meet your needs, consider aĬlick here to download our FREE Weight Loss Tracker Spreadsheet Note: All Practical Spreadsheets work with Microsoft Excel. Choose "Open" to immediately open the spreadsheet for editing, or choose "Save" to save the spreadsheet to a location on your computer. Use this spreadsheet in conjunction with ourĬlick on the below image or link to download the spreadsheet. At any point you can modify your goal weight or goal weight date. If you don't meet your weekly goal, the spreadsheet will display values in red. Throughout your weight loss period, record your weight weekly, and watch the spreadsheet highlight goals reached. The spreadsheet will then automatically calculate how much weight you need to lose, as well as calculate weekly weight goals. In the spreadsheet, record your current weight, desired weight, and desired goal date. Use our FREE Weight Loss Tracker Spreadsheet to help reach weight loss goals.