Monthly, Weekly, And Daily Planners Format For Google Sheets / Excel With Proper Formatting

Google Sheets Templates for Student Planners

1️⃣ Monthly Planner (Big Picture Goals)

Features:
- Sections for major academic goals, important deadlines, study plans, and personal tasks
- Color-coded rows for different subjects and priorities
- Drop-downs for status tracking (Not Started, In Progress, Completed)

✅ How to format in Google Sheets:
1. Columns:
- A: Date️
- B: Goal
- C: Category (Academics, Work, Self-care, etc.)
- D: Priority (High, Medium, Low)
- E: Status (Dropdown: Not Started, In Progress, Completed)

• Conditional Formatting:
• Green for "Completed" ✅
• Yellow for "In Progress" ⏳
• Red for "Not Started"

2️⃣ Weekly Planner (Breaking Down Priorities)

Features:
- Columns for each day of the week
- Sections for study sessions, deadlines, personal time, and notes
- Checkboxes for completed tasks

✅ How to format in Google Sheets:
1. Columns:
- A: Task Name
- B: Monday ✅
- C: Tuesday ✅
- D: Wednesday ✅
- E: Thursday ✅
- F: Friday ✅
- G: Saturday ✅
- H: Sunday ✅

• Checkboxes:
• Insert checkboxes under each day to mark task completion

3️⃣ Daily Planner (Time Blocking & Priorities)

Features:
- Time-blocked schedule for focus sessions
- Sections for Top 3 Priorities, Additional Tasks, and Notes
- Automatically calculates study vs. break time

✅ How to format in Google Sheets:
1. Columns:
- A: Time Slot ⏰
- B: Task Name ✏️
- C: Priority Level (High, Medium, Low)
- D: Completed(Checkbox)

• Color Coding:
• Study time = Blue
• Breaks = Green
• Personal time = Purple

How to Use These Templates

• Click on the provided Google Sheets link (or create your own by following the formatting above).
• Make a copy (File > Make a Copy) to edit your own version.
• Customize tasks, deadlines, and study blocks based on your courses.
• Track progress using checkboxes and status dropdowns.

Next: Read 1200+ student guides covering all aspects of student life.

❤ If you liked all this, consider supporting us by checking out Tiny Skills - 250+ Top Work & Personal Skills Made Easy