Free Excel Daily Routine Tracker Template — Morning & Evening Habits
Track daily morning and evening routines with automatic completion rates, streak counters, and monthly heatmaps. Build lasting habits one checkbox at a time.
Starting a morning routine is easy. Keeping it going past day three is the real challenge. The simple act of checking a box each day creates its own momentum — and this template does the rest, automatically tracking your completion rates and streaks so you stay motivated.
Key Features
🌅 Morning Routine Checklist
Pre-loaded items (fully customizable):
- Wake-up time logging
- Drink a glass of water
- Stretch or exercise
- Meditate or journal
- Plan your day
- Eat a healthy breakfast
🌙 Evening Routine Checklist
- Write down 3 things you’re grateful for
- Prepare tomorrow’s to-do list
- Screen off 1 hour before bed
- Read for 15–30 minutes
- Log your bedtime
📅 Weekly & Monthly Routines
- Weekly: Declutter workspace, weekly review, grocery shopping, exercise planning
- Monthly: Financial check-in, subscription review, goal assessment, health checkup
📊 Automatic Analytics Dashboard
| Metric | What It Shows |
|---|---|
| Daily Rate | Percentage of today’s items completed |
| Weekly Trend | Which days of the week you perform best |
| Longest Streak | Most consecutive days with all items checked |
| Monthly Heatmap | Color-coded calendar showing daily completion |
| Item Rankings | Which routines you keep vs. which ones slip |
How to Use
Step 1: Customize Your Routines
In the “Setup” sheet, edit the morning, evening, weekly, and monthly routine items to fit your life. Default items are pre-filled — keep what works, change the rest.
Step 2: Check Off Daily
Each month has its own sheet. Find today’s row and mark completed items (enter V or 1). It takes 30 seconds.
Step 3: Weekly Review
Every Sunday, check the “Dashboard” sheet for your weekly completion rate. Adjust routines that consistently fall through — make them easier or replace them.
Tips
Start Small
Don’t begin with 10+ habits. Start with 3 to 5 routines and maintain them for at least two weeks before adding more. Consistency beats ambition.
Set Different Routines for Weekdays vs. Weekends
Your schedule changes on weekends, and your routines should too. The “Setup” sheet lets you define separate weekday and weekend routines.
Use a Reward System
Set milestones at 7, 21, and 30 consecutive days with a reward for each. Use the “Milestones” sheet to define your targets and rewards in advance — it makes the streaks feel worth chasing.
FAQ
How is this different from a habit-tracking app?
Apps excel at push notifications and mobile access. This template excels at showing an entire month’s patterns on one screen. When you compare two or three months side by side, your habit patterns become unmistakably clear.
Can my family use this together?
Yes. Create a separate tab for each family member, or add a name column to track everyone in the same sheet.