How to Create a Health Tracker in Google Sheets

Building a personalized health tracker is an excellent way to understand your habits and make meaningful progress toward your goals. While there are countless apps available, creating your own tracker in Google Sheets gives you complete control to monitor what truly matters to you. This article will walk you through setting up a simple but powerful health tracker, from a blank sheet to a visual dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Before You Begin: What Should You Track?

The most effective tracker is one that’s tailored to your unique goals. Before you create a single column, take a minute to decide which metrics are most important to you. A tracker that’s too complicated is easy to abandon, while one that’s too simple might not give you the insights you need. Start small and add more later.

Here are some common metrics you might want to include:

• Physical Health: Weight, body fat percentage, measurements (waist, hips, etc.), and resting heart rate.
• Nutrition: Daily calorie intake, water consumption (in ounces or liters), protein intake, and servings of fruits/vegetables.
• Fitness Activity: Type of workout (cardio, strength, yoga), duration (in minutes), distance (miles/km), and steps taken.
• Wellness & Habits: Hours of sleep, mood rating (e.g., on a 1-5 scale), stress level, meditation time, and boolean habits like taking supplements (yes/no).

For our example, we’ll build a tracker that monitors: Date, Day of the Week, Weight (lbs), Water Intake (oz), Hours of Sleep, and Exercise Type.

Step 1: Setting Up Your Google Sheet

First, let's create the basic structure of your tracker. This involves creating the sheet, naming your columns, and adding a little formatting to make it easy to use.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Create and Triage Your Sheet

1. Open Google Sheets and start with a new, blank spreadsheet.
2. Give your spreadsheet a clear name, like "My Health & Fitness Tracker 2024".
3. Let's create two tabs. Rename the first tab to "Daily Log" by double-clicking it. This is where you'll enter your data each day. We’ll leave the second tab for a dashboard later.
4. In the "Daily Log" tab, set up your header columns in the first row. Based on our example, type the following into cells A1 through G1:
5. To make the header stand out, select all of Row 1, make the text bold, center it, and apply a subtle background color. You can also freeze the top row by going to View > Freeze > 1 row. This keeps your headers visible as you scroll down.

Your basic sheet is now ready for data entry. It should look something like a simple grid, ready to be populated with your daily metrics.

Step 2: Automating Data Entry with Smart Features

Manually typing everything can be a chore. Let's use some built-in Google Sheets features to make logging your progress faster and more consistent.

Automate the Day of the Week

You don't need to manually type the day of the week next to each date. We can use a simple formula for that.

1. In cell A2, enter your first date (e.g., "1/1/2024").
2. In cell B2, type the following formula to automatically display the day of the week:

=TEXT(A2, "dddd")

1. Hit Enter. It should now show "Monday", "Tuesday", etc., based on the date in A2.
2. Now, you can click on the small blue square in the bottom-right corner of cell B2 and drag it down. The formula will copy itself, automatically applying to each corresponding date you add in column A.

Use Checkboxes for Simple Habits

For yes/no habits like "Exercise Done?", checkboxes are perfect. They provide a quick, visual way to log your accomplishments.

1. Select the entire column where you want checkboxes, in our case, column F (starting from F2).
2. Go to the menu bar and click Insert > Checkbox.
3. Now your entire column is filled with clickable boxes. When you check a box, its value becomes TRUE, unchecked it's FALSE. This is useful for calculations, like counting how many days you worked out.

Create Dropdown Menus with Data Validation

For categories with a few consistent options, like "Exercise Type," dropdown menus prevent typos and keep your data clean.

1. Decide on your list of exercise types. For example: Cardio, Strength Training, Yoga, Walk, Rest Day.
2. Select the cells where you want the dropdown menu to appear. In our tracker, this would be column G (starting with G2).
3. Go to Data > Data validation.
4. A sidebar will appear. Next to "Criteria," select List of items.
5. In the text box that appears, enter your exercise types, separated by commas: Cardio, Strength Training, Yoga, Walk, Rest Day
6. Make sure "Show dropdown list in cell" is checked and click Done. Now, clicking any cell in column G will show a dropdown menu with your predefined options.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Add Visual Cues with Conditional Formatting

Conditional formatting changes a cell's color based on its value, giving you an instant visual of your performance without having to read a single number.

Let's say you have a goal to sleep at least 7 hours per night. Here’s how you can make cells in the "Hours of Sleep" column turn green when you hit your goal:

1. Select column E (starting from E2), where your sleep data is.
2. Go to Format > Conditional formatting.
3. In the sidebar, under "Format rules," choose "Format cells if..." and select Greater than or equal to.
4. In the value box, type 7.
5. Under "Formatting style," choose a light green background color.
6. Click Done.

Now, whenever you enter a number 7 or higher in that column, the cell will automatically turn green, celebrating your small win!

Step 3: Visualizing Your Progress with Charts

Numbers and colors are great, but nothing shows a trend better than a chart. Visualizing your progress is a huge motivator. Let’s create a simple line chart to track your weight over time.

How to Create a Weight Trend Chart

1. Select the two columns of data you want to visualize. Click the letter 'A' at the top of the Date column to select all of it. Then, hold down the Command key (on Mac) or Control key (on PC) and click the letter 'C' at the top of the Weight column. This selects both columns at once.
2. Go to the menu and click Insert > Chart.
3. Google Sheets will often guess the right chart type, but if not, use the Chart editor that appears on the right. Under "Chart type," select Line chart.
4. You can customize your chart in the editor. Under the Customize tab, you can change the chart title, axis labels, colors, and more. For example, give it a title like "Weight Progress" and edit the vertical axis to add a minimum value to make the changes look more pronounced.

This chart will automatically update every time you add a new row of data, giving you a live look at your progress. You can move this chart to its own sheet or place it on a dedicated dashboard tab for easy viewing.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Building a Simple Dashboard Tab

Having a dashboard summarizes your key metrics in one place. It saves you from scrolling through daily entries to find what you're looking for.

1. Go to the second tab you created and rename it "Dashboard".
2. Here, you can put key stats and your charts. Let's calculate some basic metrics. For example, to find your average hours of sleep or total water intake.
3. In cell A1 on your dashboard, type "Average Sleep This Week".
4. In cell B1, you can use the AVERAGE function to calculate it. The formula would look like this, assuming you've filled one week of data in rows 2-8 of your "Daily Log" tab:

=AVERAGE('Daily Log'!E2:E8)

1. To count the number of days you exercised, find an empty cell and type "Workout Days This Week". In the cell next to it, use the COUNTIF formula with your checkboxes from column F:

=COUNTIF('Daily Log'!F2:F8, TRUE)

1. Now, you can copy the weight chart you created and paste it onto this dashboard tab. Organize the stats and charts however you like.

Your dashboard serves as a high-level overview of your journey. As you get more comfortable, you can add more complex formulas and visualizations, like week-over-week changes or sparklines for mini in-cell trend lines.

Final Thoughts

You’ve just built a flexible and personal health tracker in Google Sheets! By logging your metrics consistently, you can use formulas to automate entries, conditional formatting for visual cues, and charts to see the bigger picture of your progress. This DIY approach empowers you to focus on the data that drives your unique health journey.

As powerful as spreadsheets are, sometimes managing data from multiple sources like your smartwatch, calorie counting app, and other fitness trackers can become a chore. At Graphed, we’ve created a way to connect all your data sources and build sharable, real-time dashboards automatically. Instead of manual data entry, you can ask questions in plain English and let us build the reports for you, so you can spend less time updating spreadsheets and more time acting on your insights.