How to Create a Mood Tracker in Google Sheets

Tracking your mood is a powerful way to understand your emotional patterns, and you don't need a fancy app to do it. A simple Google Sheet is one of the most flexible and private tools you can use. This article will guide you step-by-step through creating a personalized mood tracker, from setting up the basic columns to visualizing your trends with charts.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Use Google Sheets for Mood Tracking?

Before we build, let's quickly cover why a spreadsheet is such a great choice for this. App-based mood trackers are great, but sometimes they can be restrictive or costly. Google Sheets offers a unique combination of benefits:

• It's Completely Free: All you need is a Google account.
• Endlessly Customizable: You decide exactly what you want to track - mood, energy, sleep, activities, anxiety levels, anything. As you learn more about yourself, you can easily add or remove columns.
• 100% Private: Your data belongs to you and is stored securely in your private Google Drive, not on a third-party server.
• Accessible Everywhere: You can update your tracker from your phone, tablet, or computer.
• Powerful Analysis: Unlike a paper journal, an online spreadsheet allows you to create charts and find patterns in your data automatically.

Part 1: Setting Up Your Mood Tracker Spreadsheet

Let's start by building the foundation of your tracker. This part is about creating a clean, consistent structure that makes data entry a breeze.

Step 1: Create a New Google Sheet and Name It

First, create a brand new Google Sheet. The quickest way is to simply type sheets.new into your browser's address bar and hit Enter.

Give your spreadsheet a name like "My Mood Tracker 2024." To keep things organized, you can also rename the tab at the bottom from "Sheet1" to something like "Daily Log." Just double-click the tab name to change it.

Step 2: Define Your Core Columns

Every mood tracker needs a few essential pieces of information. In the first row of your sheet, create the following headers in cells A1, B1, and C1:

• A1: Date - This is the most important column for tracking trends over time.
• B1: Mood - This will be your primary rating for the day.
• C1: Notes - Here you can add context. Why do you think you felt that way? What happened today? This context is invaluable when you review your data later.

Your spreadsheet should now look very simple, and that’s a good thing! We're starting with a strong foundation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Make Data Entry Easy with Dropdown Menus

To keep your data consistent (which is critical for making charts later), we'll create a dropdown menu for your "Mood" column. This prevents typos and limits you to a predefined set of moods.

First, decide on your mood scale. You could use a number scale (like 1-5) or descriptive words. A descriptive scale is often easier to interpret. Let's start with a five-point scale:

• Great
• Good
• Okay
• Bad
• Awful

Now, let's turn this into a dropdown menu:

1. Select the entire Mood column by clicking the letter 'B' at the very top.
2. In the menu, go to Data > Data validation.
3. A sidebar will appear on the right. In the "Criteria" dropdown, select "Dropdown".
4. Enter your mood options one by one in the fields provided (Great, Good, Okay, Bad, Awful). You can even assign colors to each option to make it more visual!
5. Click "Done."

Now, when you click any cell in the "Mood" column (from B2 downwards), a dropdown arrow will appear, allowing you to select your mood cleanly every time.

Part 2: Adding More Context to Your Tracker

A simple "mood" rating is great, but life is more complicated than that. Tying your mood to specific activities and factors is how you'll uncover real insights. What makes you have a good day? What contributes to a bad one?

What Other Factors Can You Track?

The beauty of Google Sheets is that you can add as many columns as you want. Don't go overboard at first, but consider adding columns for factors you think might influence your mood. Put these in columns D, E, F, and beyond.

Here are some popular ideas:

• Sleep (Hours): How much sleep did you get last night?
• Energy Level: Use a simple 1-5 scale.
• Productivity: A 1-5 rating of how productive you felt.
• Social Interaction: Did you spend time with family, friends, or coworkers?
• Exercise: Did you work out today? What kind of workout?
• Weather: Sunny, cloudy, rainy, etc.

Using Checkboxes for Simple Yes/No Tracking

For binary (yes/no) activities like "Did I exercise?" or "Did I meditate?", checkboxes are a fantastic tool.

1. Choose a column for your new data point, for example, "Exercise" in cell D1.
2. Select the entire column by clicking the letter 'D'.
3. In the menu, go to Insert > Checkbox.

This will fill the column with checkboxes. Now you can simply check the box on days that you exercised. It's a quick and clean way to log your activities.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Part 3: Visualizing Your Mood Data with Charts

This is where your effort pays off. After you’ve logged a few weeks of data, you can start creating charts to turn that raw data into clear insights. Google Sheets makes this incredibly easy.

Step 1: Create a "Mood Score" Helper Column

To analyze mood trends over time in a line chart, it's best to convert your descriptive moods (like "Great," "Good") into numbers. We can do this automatically with a formula.

Let's create a new column called "Mood Score" next to your "Mood" column. Assuming your "Mood" is in column B, do the following:

1. Right-click on column B and select "Insert 1 column right." Name the new column C "Mood Score." (Your Notes column will shift over to column D).
2. We’ll assign scores like this: Great=5, Good=4, Okay=3, Bad=2, Awful=1.
3. In cell C2 (the first cell under your new header), enter the following formula:

=IFS(B2="Great", 5, B2="Good", 4, B2="Okay", 3, B2="Bad", 2, B2="Awful", 1)

Press Enter. You should see the correct number appear. Now, click on cell C2, grab the small blue square (the "fill handle") in the bottom-right corner, and drag it down as far as you have data. This will copy the formula to all the rows.

Step 2: Create a Line Chart to See Mood Trends

Now let's see how your mood has changed over time. A line chart is perfect for this.

1. Select your "Date" column (column A) and your new "Mood Score" column (column C). To select two columns that aren't next to each other, click the header 'A', then hold down Ctrl (or Cmd on Mac) and click the header 'C'.
2. Go to the menu and click Insert > Chart.
3. Google Sheets is smart and will probably recommend a line chart by default. If not, select "Line chart" from the Chart Type dropdown in the chart editor sidebar.

And just like that, you have a visual representation of your emotional journey! You can easily spot upward trends, downward slopes, and periods of stability.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Analyze Mood Frequency with a Pie Chart

Curious about what your "typical" mood is? A pie chart is a quick way to see the percentage breakdown.

1. Select just your "Mood" column (column B).
2. Go to Insert > Chart.
3. Google Sheets will likely default to a Pie Chart, instantly showing you a breakdown of how many "Good," "Bad," and "Okay" days you've recorded.

This chart gives you a bird's-eye view of your overall well-being. Are you spending most of your time feeling Good or just Okay? This chart tells the story at a glance.

BONUS: Add a Visual 'Heatmap' with Conditional Formatting

Even without charts, you can make your raw data more intuitive. Conditional formatting changes a cell's color based on its content. This creates a "heatmap" of your moods, making it easy to spot patterns just by scrolling.

1. Select your "Mood" column (column B).
2. In the menu, click Format > Conditional formatting.
3. The Conditional format rules sidebar will appear. Under "Format rules," change the dropdown from "Is not empty" to "Text is exactly."
4. In the value box, type Great.
5. Under "Formatting style," choose a fill color, like a pleasant green.
6. Click "+ Add another rule" and repeat the process for your other moods, assigning different colors to each (e.g., light green for "Good," yellow for "Okay," orange for "Bad," red for "Awful").

When you're done, your "Mood" column will be a colorful calendar of your emotions, instantly highlighting good weeks and tough patches.

Final Thoughts

Creating a personal mood tracker in Google Sheets puts you in control, giving you a flexible, free, and private tool to better understand your wellness. By consistently logging how you feel and what's happening in your life, you can move from just guessing what affects you to knowing for sure, all backed by your own data.

While building dashboards is empowering, we know that as your data grows - connecting sleep patterns from your fitness tracker, project completions from your task manager, and ad performance from your marketing campaigns - manual analysis can become a new chore. This is exactly why we built Graphed. We provide an AI data analyst that connects to all your sources and allows you to create dashboards and ask complex questions using simple, natural language, turning hours of manual work into a 30-second conversation and giving you back time to focus on making better decisions.