Skip to content
Mood Tracker cover: a sample sheet with check-ins, average energy (1 to 5) and good or great days and a column chart, beside the Dashboard and Log tabs

Mood Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This mood diary is for anyone who wants to notice patterns in how their days feel. The Log tab holds a single row for each day, with a mood from a list of five, an energy score on a scale of 1 to 5, and two text columns for what helped and what weighed on you. The Dashboard counts check-ins, averages energy, totals good or great days and low or stressed days, and charts the days in each mood with their average energy.

The sample log covers eleven days, enough to show how the averages move. Keep the same five moods and the same energy scale for every entry, since changing them makes the counts harder to compare. Read the What helped column once a week and mark the entries that repeat, because those are the habits worth planning for.

Useful for

  • Spotting a low stretch of weeks before it becomes a slump
  • Seeing whether walks or exercise lift your energy score
  • Sharing a month of mood counts with a counselor

What's included

  • 3 tabs: Dashboard, Log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this a substitute for mental health care?

No. It is a personal log that shows patterns in your days. If low or stressed days last for weeks, or you feel unsafe, contact a doctor, counselor or crisis line in your area straight away.

What do the energy scores mean?

Score energy from 1 to 5, where 1 is empty and 5 is full. Choose a fixed moment to score, say bedtime, and stick with it so entries compare fairly. The average energy on the Dashboard is only as steady as the scores behind it.

Can I add more moods to the list?

You can add words to the drop-down, but the Dashboard table only counts the five moods it lists. A new mood needs its own row there as well, or its days are left out of the chart.

  • #habit-tracker
  • #mood-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…