Are you looking for an easy way to track your emotions daily? A mood tracker can help you gain insights into your emotional patterns and take control of your mental health. The best part? You can create your very own mood tracker using Google Sheets in just five minutes! Let’s get started.
Why Use a Mood Tracker?
A mood tracker lets you visualize how your emotions change over time, helping you identify patterns, triggers, and trends. It’s a simple yet powerful tool to improve self-awareness and emotional well-being.
What You Need
A Google account to access Google Sheets.
Some creativity to personalize your tracker.
Optional: Access to my FREE mood tracker template (link in the description) for a quick start!
Step-by-Step Guide to Creating Your Mood Tracker
Step 1: Insert the Date
Open Google Sheets and create a new spreadsheet.
In the first cell, insert today’s date using the shortcut Ctrl + ; (semicolon).
In the cell below, set the formula to calculate the next date automatically by adding
+1
to the previous cell. Drag the formula down to fill the column with dates for the entire month.To make the dates shorter, go to the Format menu, select Number > Custom date and time, and choose the format to display only the day.
Step 2: Name Your Table
Label your table as “Mood Tracker” or any creative name you prefer.
Step 3: Create a Drop-Down List for Your Mood
Go to a new sheet (Sheet 2) and list emotions such as Happy, Normal, Sad, and Angry.
Next to each emotion, add an icon or emoji that represents it for a visual touch.
Return to Sheet 1 and select the column where you want to log your mood.
Click Insert > Drop-down and choose Drop-down from a range. Select the range of emotions from Sheet 2.
In the advanced options, ensure the drop-down displays as Plain text to include the icons.
Step 4: Count Your Emotions
To track how often each mood appears, use the COUNTIF formula.
Example:
=COUNTIF(range, "Happy")
counts the number of days marked as Happy.
Repeat the formula for each mood and display the results in a summary table.
Step 5: Decorate Your Mood Tracker
Select a color palette that matches your vibe. You can use websites like Coolors for inspiration.
Apply these colors to your tracker to make it visually appealing.
For extra flair, take a screenshot of your tracker and use tools like Snipping Tool to share your creation online.
Tips for Maximizing Your Mood Tracker
Update your tracker daily to maintain consistency.
Reflect on your emotional patterns at the end of each week or month.
Use the data to identify triggers and create actionable plans to improve your mental well-being.
Get Your FREE Mood Tracker Template
Don’t want to start from scratch? I’ve got you covered! You can download my professionally designed mood tracker template for free. It’s customizable and beginner-friendly. Click here to download the template.
Conclusion
Creating a mood tracker on Google Sheets is simple, effective, and customizable to your needs. Start tracking your emotions today and discover new insights about yourself. If you found this guide helpful, please leave a like or share it with a friend. Your support means the world to me!
For more templates and resources, visit my shop (link in the description). Thank you for reading, and have a wonderful day!