EduPlanner is a powerful Google Sheets™ add-on designed to help teachers create and manage a complete year-long teaching planner in one organised workbook.

With EduPlanner, educators can quickly generate structured planning templates that combine monthly overviews, term planners, lesson planning panes, and supporting tools into a single, easy-to-use system directly inside Google Sheets™.

The add-on automatically builds planner sheets for the academic year and applies consistent formatting, allowing teachers to focus on planning lessons instead of building spreadsheets.

Key Features

• Generate full-year teaching planners with one click
• Create monthly planner tabs for a complete year overview
• Build term-based planners with weekly lesson structures
• Integrated lesson planning panes for daily lesson organisation
• Automatic holiday highlighting and weekday formatting
• Subject-based color coding for quick visual organisation
• Built-in assessment tracking and notes
• Optional collaboration notes for shared planning
• Customisable timetable periods and subject settings
• Easy navigation between planner views and detailed lesson sheets

Flexible Planning Options

EduPlanner supports two planning styles:

Monthly Planners
Create twelve monthly tabs that provide a full calendar overview of the academic year while still supporting detailed lesson planning areas.

Term Planners
Generate structured Term 1–Term 4 planners with weekly lesson blocks and integrated links to detailed lesson sheets for deeper planning.

Smart Organisation Tools

EduPlanner includes tools to keep planners clean and organised, including automated holiday coloring, subject-based color mapping, planner rebuilding tools, and utilities to refresh formatting or remove legacy links.

Teachers can customise period labels, subject colors, and planner behavior through a simple options sheet, making EduPlanner adaptable to different school timetables and planning styles.

Designed for Teachers

EduPlanner is built specifically for educators who use Google Sheets™ for planning. It simplifies the process of organising lessons, tracking assessments, and maintaining a structured teaching schedule across the entire academic year.

Whether you prefer monthly overview planning or detailed term-by-term lesson organisation, EduPlanner provides a flexible and efficient planning system directly within Google Sheets™.

Get started by installing EduPlanner and opening it from the Google Sheets™ Extensions menu to generate your planner and begin organising your teaching year.