Skip to content
Gratitude Log cover: a sample sheet with entries written, people entries and small moment entries and a bar chart, beside the Dashboard and Entries tabs

Gratitude Log

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This journal suits anyone who wants a few minutes of gratitude each day and a clear record of it. The Entries tab has a separate row for every day, with the date, a category (People, Health, Home, Nature, Work or Small moments), the entry itself and a column for who or what helped. The Dashboard counts entries, people entries and small moment entries, and charts the entries in each category with their share of the total. The Prompts tab lists six questions for quiet days.

Keep each entry short and specific, such as the warm bread or the colleague who fixed a report, because specifics are what you will enjoy reading back. Tick a prompt on the Prompts tab once you have used it, and rotate through the list instead of picking the easiest one. Once a month closes, read the entries to notice names and places that keep returning.

Useful for

  • A two-minute habit before bed each night
  • Recording small good things during a hard month
  • Gathering kind moments for a family year-end note

What's included

  • 4 tabs: Dashboard, Entries, Prompts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Entries: a table
  • Prompts: 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 Entries 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

What happens when I skip a day?

Leave that row blank and carry on. The log is most useful as a record of the days you did write, so a gap does not matter. Start the next entry on the day you return, and skip days you cannot remember rather than guessing.

Should gratitude entries be private?

Usually, yes, because the best entries name people and private details. If you share the file, send a copy with the Entries tab trimmed to dates and categories, so names stay out of view.

Can gratitude journaling help with low mood?

Many people find it a useful habit alongside other support, but it is not a treatment. If low mood lasts for weeks, talk with a doctor or counselor. The log can show them what your days have been like.

  • #habit-tracker
  • #gratitude-log
  • #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…