Free Excel Goal Tracker Template — OKR-Based Annual Goal & Habit Management
Break down annual goals into quarterly OKRs, monthly action plans, and daily habits. Auto-tracks completion rates, streaks, and progress dashboards.
Most New Year’s resolutions are forgotten by March. This goal tracker is designed to break big objectives into concrete actions and track weekly progress — so your goals don’t just live on a sticky note.
Key Features
🎯 OKR-Based Goal Setting
- Objectives: Up to 5 big goals you want to achieve
- Key Results: 3 measurable outcomes per objective
- Quarterly OKR scoring with automatic completion tracking
- Annual OKR overview dashboard
📅 Monthly Action Plans
- Define specific action items for each Key Result every month
- Checkbox completion tracking for each item
- Option to carry unfinished items forward to the next month
✅ Daily Habit Tracker
- Track up to 10 daily habits with checkboxes
- Streak counter — consecutive days completed, calculated automatically
- Monthly completion rate heatmap (GitHub contribution graph style)
- Identifies which habits stick and which need adjustment
📊 Progress Dashboard
| Metric | Description |
|---|---|
| Overall Progress | Percentage across all objectives |
| OKR Score | 0–1.0 score per quarter |
| Actions Completed | Number of items checked off this month |
| Top Streak | Longest consecutive habit streak |
How to Use
Step 1: Set Annual Goals
In the “OKR Setup” sheet, enter 3–5 objectives. For each, define 3 Key Results that answer: “How will I know I’ve achieved this?”
Example:
- Objective: “Get healthier”
- KR1: “Reduce body fat from 25% to 20%”
- KR2: “Exercise 4+ times/week, maintain 80% yearly adherence”
- KR3: “Run 5K in under 30 minutes”
Step 2: Plan Monthly Actions
At the start of each month, list concrete tasks in the “Monthly Plan” sheet that move your Key Results forward.
Step 3: Weekly Check-In
Every Sunday evening, update your progress. It takes about 10 minutes.
Step 4: Quarterly Review
Every 3 months, score your OKRs and adjust the next quarter’s targets based on what you’ve learned.
Tips
Link Habits to Goals
Connect your daily habits directly to Key Results. When you see how small daily actions compound into big outcomes, motivation follows naturally.
How to Read OKR Scores
- 0.7–1.0: Goal achieved — set a more ambitious target next quarter
- 0.4–0.6: Solid progress — keep going
- 0.0–0.3: Goal was too aggressive or the strategy needs rethinking
FAQ
What if I have too many goals?
Limit yourself to 3–5 objectives. Trying to change everything at once usually means nothing changes. Focus on what matters most right now.
Can I use this for team OKRs at work?
Yes. Upload to Google Sheets and share with your team for collaborative OKR tracking with real-time updates.