My Personal Health Tracker Template

personal health spreadsheet tracker

Are You Living a Truly Healthy Life?

We all strive to maintain a healthy lifestyle, but do you really know how you're doing? What's your daily intake of fruits and vegetables? How about for the entire week? Are you getting enough exercise and quality sleep? If you're like me, you may not have a structured process to track these critical aspects of your well-being. Until recently, I didn't either – but that's changed.

I've created a Health Tracker Google Doc Template to help monitor and improve my overall health. I'm sharing this template, along with the scoring logic and personal insights, in the hopes of motivating others to give it a try for 30 days or even enhance the system further.

It's easy to deceive yourself about the quality of your diet and lifestyle until you start meticulously tracking the data. Although I considered myself relatively healthy – playing sports, getting decent sleep, and avoiding fast food and sugary drinks – a closer examination revealed some concerning patterns.

I spent the first month focused around measurement. All of these numbers don’t mean much unless you have clearly defined goals and objectives. It’s hard to set goals without having a baseline. Internally, you’ll embellish your healthy habits and become mortified like I was. I guarantee it.

Daily Tracker - Tab 1

kenny personal health tracker tab 1

This is where I record my daily progress. I try to keep this tab open on one of my chrome windows. The first column breaks out the date, days left in the quarter, 3 meals of breakfast, lunch, dinner and an additional “other field” to capture snacks or junk food outside of those set mealtimes. It up to you on how detailed you want to get. I just wanted a quick way to capture what I was putting in my mouth. At the end of each day, I count the number of portions I had for each of the following groups:

  • P = Protein
  • V = Vegetables
  • F = Fruit
  • W = Water
  • A = Alcohol
  • J = Junk

You could easily add columns for other habits/food groups you want to track like smoking, protein shakes, coffee, or anything else you want to track. I’m not super scientific about it, here’s a few examples:

  • Orange = 1 fruit portion
  • Chicken breast = 1 protein portion
  • Small Salad = 1 vegetable portion
  • 500ml glass of water = 0.5 water
  • Chocolate bar = 1 junk point

When I was making healthy choices, I looked forward to opening up my health tracker - there was something deeply satisfying about logging all the nutrient-dense meals and active lifestyle wins. It felt like capturing little pockets of "magical goodness." However, if I fell off the wagon for a few days, the tracker became my enemy. I started avoiding it like the plague, not wanting to face the reality of my lapses. To stay consistent, I inserted a line break every seven days to visually separate each work week and set a recurring calendar reminder to complete my tracker updates before Monday morning. This system helped keep me accountable, even when I desperately wanted to bury my head in the sand. It’s a huge bummer trying to remember details of every meal after you’ve miss a few days. I ended up going through google calendars, emails, and bank receipts to figure out what/where I went just to ensure each meal was tracked.

I spent the first month focused around measurement including adding and removing columns that were important to my life. Building a regular routine to actually complete the tracker was very challenging. This is by far the hardest obstacle of all. I recommend setting daily google calendar alerts, or phone alarms, or adding a sticky notes to areas where you already have well defined routines. If you want to be more aggressive, add notes to your fridge door, light switches, or rally a friend to run the tracker with you and harass eachother if anyone slips. I still struggle with submitting the tracker every day, but improving every week.

Tracking Your Body and Mind

kenny personal health body mind

In addition to tracking my eating habits, I introduced columns to track my body, mind, and overall happiness. Within the spreadsheet i’ve included some further details on how I track certain areas but I believe it’s pretty self explanatory:

  • G = Gym Activity Points
  • AC = Activity Comments related to your work out
  • M1 = Morning Meditation session 1
  • M2 = Evening Meditation session 2
  • S = # of hours you slept
  • Weight = your weight recorded at same time everyday
  • Work = # of hours you spent working
  • TV = # of hours watching tv/movies/youtube

I’ve been experimenting with a daily score total but still needs work. I’ve included a basic formula to create a daily score but would encourage you to slide the formula based on your goals. For example, if drinking wine is something you enjoy and feel it’s part of a well balanced lifestyle, then you’ll need to update the formula to reflect that. Within the google doc, i’ve used the following formula:

> Daily Score Formula = ((P + V + F + W) - (A +J)) + (G + M1 + M2)

Goals and Trends - Tab 2

personal health tab 2 KPI dashboard screenshot.jpg

This is my health KPI (Key Performance Indicators) where I set goals and monitor my progress from 40k feet. I find this shit mind blowing. I can view how many gym sessions i’ve had in the last 30 days, how many beers i’ve had, average number of hours slept per day over the last 30 days, number of vegetables i’ve had, etc..

First step is to add your weekly goals. The first few weeks you wont have much information in here and formulas wont function properly. I’d recommend using the tracker for 2 weeks to build a baseline and go from there before settings goals. The rows are pretty self explanatory. You can see your weekly totals, averages per day over the last 7 days, the last 30 days, and the trend over the last 2 weeks.

My Weekly Goals - Tab 3

kenny personal health tab3 weekly goals screenshot
struggle porn examples. You should pick better goals

This is where I list my top 10 goals and display my weekly progress. I’ve added conditional formatting for the words yes and no, but this is great for creating an overall goal and breaking them down into actionable items. This isn’t for everyone, but thought i’d include it too.

Spreadsheet Links + Quick Instructions

Let me know what hacks or improvements I should make. I’ll update the original google doc and include your name!

DOWNLOAD >> Personal Health Tracker Spreadsheet - Blank Template

Bit stuck as the above template is a bit bare? Check out my template to get an idea of what yours could look like.


  1. Open link, navigate to menu bar, select “File, Make Copy”
  2. Call the spreadsheet doc something cool and fancy
  3. Go to Legend Tab, Enter your name and birthday
  4. Take a moment to process how many days you’ve been on earth. Crazy, I know!
  5. Navigate to Daily Entries Tab and familiarize yourself with the columns. Fill out todays date
  6. After a few weeks head over to the KPI tab, enter your weekly goals on row 6. I’ve included some basic examples, but the weekly goals are carried over a 7 day average, whereas weight should be a single number.
  7. If you have other goals, set them up within the My Weekly Goals tab
  8. Send me a tweet or comment below and let me know how your progress is going!

Thanks for everyone’s feedback on the blog post and spreadsheet. Shoutouts to my elephants. Please keep the feedback coming. 1. I’m available to answer questions if you get stuck and i’ll totally update the google spreadsheet with any suggestions or formula improvements you have. Would love to hear your success stories, drop me a shoutout on twitter or send me an email. Have fun and good luck.


Latest Blog Entries