Daily Journal Excel Template

Daily Journal Excel Template for recording thoughts reflections goals habits moods activities and daily progress
💾 📄 .xlsx ✅ Excel & Google Sheets
✅ Fully editable — every formula visible
📱 Mobile-friendly & printable
🔁 License: Free to use

A daily journal is a simple, grounding habit that asks only a moment of your day. Jotting down a highlight and how you felt helps you notice the shape of your days, which otherwise blur together. So a single line a day, kept without pressure, can quietly add up to something meaningful.

This free template lets you note a daily highlight and gently rate your mood and energy. So it tracks your entries over time. As a result, you have an easy, low-effort habit and a record you can look back on, with no targets to hit and nothing to get right.

What does the daily journal include?

The template is one simple journal feeding a gentle dashboard. Dropdowns keep the ratings tidy. In short, you get the following:

  • A journal with the date, an entry or highlight, a mood rating, an energy rating and notes.
  • Drop-down lists for mood and energy, so you can rate each from one to five.
  • A free-text highlight column, for a line about your day in your own words.
  • A notes column for anything else you would like to remember.
  • A dashboard showing total entries, this week’s entries, days logged, your average mood, your average energy and the most recent date.

Which formulas power the daily journal?

The dashboard does the gentle counting for you, with nothing to live up to. A COUNTA totals your entries, and a SUMPRODUCT counts those from the last week, so you can see your recent rhythm at a glance.

A neat SUMPRODUCT divided by COUNTIF counts the distinct days you have journaled, and two AVERAGEIF formulas give your average mood and energy, ignoring blank rows. So the dashboard offers a soft, reflective overview. There are no streaks to break and no targets to meet, by design.

Why keep a daily journal?

The first benefit is reflection. Pausing to note a highlight nudges you to find something worth remembering in each day, even an ordinary one. So the habit gently shifts your attention toward the good.

The second benefit is gentle self-awareness. Tracking mood and energy over time, without judgement, can reveal patterns, such as how your week tends to flow. Looking back on past entries can be grounding on a hard day. Furthermore, the habit takes less than a minute, so it is easy to sustain. In short, the journal is a small, kind practice with a quietly cumulative effect.

What does the dashboard reveal?

The dashboard offers a soft, reflective snapshot, never a scorecard. This week’s entries show your recent rhythm, simply as a gentle reflection rather than a target. So it nudges without any pressure.

The average mood and energy figures let you notice how you have been feeling lately, kindly and without judgement. The days-logged figure quietly shows the habit taking root, and the most-recent date keeps the journal close to hand. Because there is nothing to fail, the dashboard simply reflects your days back to you. So it stays gentle by design.

How do you use it?

Each day, ideally at a settled moment, jot down a highlight or a line about how the day went. It can be tiny: a good conversation, a walk, a quiet evening. So the bar stays low and the habit stays easy.

Add a mood and energy rating if you like, though both are optional. There is no need to write a lot, since a sentence is plenty. If you miss a day, simply pick it up again the next, with no guilt. Because it is meant to be kind, the only aim is to notice your days. In short, one line a day is the whole idea.

How do you customise it?

You can use as much or as little of the template as suits you. Additionally, you can add columns for the weather, a gratitude note, one thing you are looking forward to, or a single word to sum up the day. Some people add a prompt that changes each day. The template adapts to whatever form of gentle daily reflection works for you.

What mistakes should you avoid?

The first mistake is turning a kind habit into a pressured task with streaks and rules. So keep it light, since the journal works best when it stays effortless. The second mistake is feeling you must write something profound.

A few honest words beat a polished paragraph, so keep it simple. Finally, please remember this is a gentle practice, not a record you must keep perfectly. Some days you will not feel like writing, and that is completely fine. The journal is here to support your days, not to add another duty to them.

Frequently asked questions

Are there streaks or targets in the daily journal?

No, and that is deliberate. It has no streaks to break or targets to hit. It is simply a gentle space to note your days, so it stays a kind habit rather than another obligation.

What should I write each day?

Just a highlight or a line about your day, however ordinary. A good cup of coffee or a nice walk is plenty. The habit of pausing to notice matters far more than what you actually write.

What if I miss days?

That is completely fine. Simply pick it up again whenever you like, with no guilt. The journal is meant to support your days, not to judge them, so there is nothing to fall behind on.

Note a line about your day, add a mood if you like, and keep the habit gentle. The dashboard then reflects your days back to you, kindly. A daily journal is not a task to perfect; instead, it is a simple, grounding way to notice your days and build a quiet record you will be glad to look back on.

Capture your daily thoughts and track personal growth with this free Daily Journal Excel Template. Record journal entries, daily reflections, goals, achievements, habits, moods, activities, and important moments in one simple Excel file. Ideal for individuals, students, professionals, and anyone who wants an organized way to practice journaling, improve self-awareness, monitor progress, and maintain a consistent daily reflection routine.