Quick Links
Don’t have a health tracker that you may strap on like aFitbit or even an Apple Watch? You can still effectively log fitness, nutrition, diet, blood sugar, and other health details using an app you probably have on your computer, Microsoft Excel.
With handy Excel templates, you can simply pop inthe health data you need. Whether you want to keep a log for yourself and mark your progress, have anXLSX fileyou canemailto your doctor, or want aprintablerecord for physician appointments, you can use Excel for health tracking.
Each template is available in both Excel’s desktop and web versions except where noted.
Log Daily Calorie and Fat Percentage
With this Excel template, you can see the number calories from fat and the fat percentage for each food you eat. This tracker includes a summary section of calories and calories of fat consumed along with a column graph showing fat as a percentage of calories.
Simply enter the day, food, calories, and fat grams and watch theDaily Calorie and Fat Percentage Logtemplate do the rest.
Journal Your Diet and Exercise
To help you reach your health goals, try out thisDiet and Exercise JournalExcel template. You have three tabs to record and view your progress.
Enter the foods you eat with calories, carbs, protein, and fat on the Diet tab.
Track the exercises you dowith the duration and calories burned on the Exercise tab.
Insert your start and end dates and weights and then view analyses of the Diet and Exercise sheets on the Goals tab. You’ll see helpful charts along with a brief summary showing your progress, making it easier to achieve your goals.
Calculate Calorie Intake on an Amortization Schedule
If you’reinterested in losing weightbut aren’t sure how many calories you should consume each day to do so, check out thisCalorie Amortization Schedule.
Related:5 Ways Your iPhone Can Help You Lose Weight
Enter your basic details at the top like activity level, current weight, age, height, and goal weight. You’ll then view a full table showing calories to consume with the number you’ll burn along with how many more pounds you have to go to reach your goal.
Track Weight Loss
If you already have a diet plan toreach your target weight, then keep track of it easily with thisWeight Loss Trackertemplate for Excel.
Simply enter your target weight at the top. Then, use the table to record your weight per date. You’ll see a helpful chart at the top that shows your progress by week or month with just a glance.
Get a Fitness Plan
For the ultimate fitness template, you can track everything from your weight to the size of your biceps to the food you eat.
ThisFitness Plantemplate includes seven tabs for tracking everything related to your workouts orexercise routines in addition to weight lossand diet.
Log the measurements for your waist, biceps, hips, and thighs.
Track all activities with thedate,time, duration, distance, and calories burned.
Add the foods you eat including calories, fat, cholesterol, sodium, and other nutritional details.
Then, review the Weight Tracker tab which summarizes the other sheets and gives you a clear view of your fitness plan progress.
Related:How I Used Technology to Get in the Best Shape of My Life and Save My Son
Track Your Blood Sugar
When you need to keep an eye on your blood sugar, you can use this convenientBlood Sugar Trackertemplate to log your details in Excel.
Enter the date, time, and blood sugar level in the table. You’ll then see a running average in the column on the right along with a useful line graph for your charted progress. You can easily print the tracker for your next doctor’s appointment if needed.
Log Your Blood Pressure and Glucose
For logging both pressure and glucose, use thisBlood Pressure and Glucose Trackertemplate.
Enter the date, time, and event on the left. Then, insert your blood pressure and glucose numbers to the right.
The glucose section displays the level and status automatically for a quick view. You can also customize the scale values at the top to fit your particular conditions.
For a bonus, you can include notes on the right side which is helpful for out-of-the-ordinary levels.
Keep a Medication Log
When you need to track medications for yourself or you and your family, an easy logging process makes all the difference. Here are two medications logs that are ideal forindividuals and families.
Related:How to Set an Emergency Contact on iPhone (and Why)
Basic Medication Log
For your own logging, thisBasic Medication Loggives you all the spots you need for complete details. Add the medication name, start and stop dates, dosages with times, and special instructions.
You can also include the prescribing physician and their phone number, any side effects, the refill number, and the pharmacyphone number. This is perfect for those with many prescriptions to track.
Family Medication Log
With a tab for each person in thisMedication Log, you can easily list medications, dosages, frequencies, and times of day for each family member. You can also include remarks, or notes, per medication.
Track Your Pet’s Health
Maybe the health tracker you need is for your furry family member. ThisPet Health Loglets you track immunizations, medications, and known conditions. You can also log vet visits with complete details for tests performed, diagnosis, prescribed action and medication, and more.
If you have more than one pet,copy the original sheetto another tab before entering the details. You can thenrename the tabwith your pet’s name. Do the same for each pet in your household for a handy record of everyone’s health history.
The Pet Health Log is only available for the Excel desktop version, not the web.
Even if you wear afitness tracking deviceor use aheath tracking app, it may not include every category you need. With these Excel templates, health tracking couldn’t be simpler. Plus, if you wanted to combine data, most fitness trackers let you export your data as aCSV fileor other file type that you can easilyimport into Excel.
