Undated school year planner:
36 free Excel templates
August to July, reusable for any year, portrait & landscape. Works
with Excel and Google Sheets. Free to download, edit and print.
Advertisement
Find the right school year planner
Numbered days
Templates 1 to 11 number every month from 1 to 31 with no weekdays attached, so the same sheet fits any year, and the 31st is grayed out in the shorter months. Template 5 is a linear planner, templates 6 and 11 a classic year at a glance, and templates 2 and 8 print the dates down both edges of open month columns. Best for deadlines, appointments and report dates.
Templates 1 to 11 number every month from 1 to 31 with no weekdays attached, so the same sheet fits any year, and the 31st is grayed out in the shorter months. Template 5 is a linear planner, templates 6 and 11 a classic year at a glance, and templates 2 and 8 print the dates down both edges of open month columns. Best for deadlines, appointments and report dates.
Aligned weekdays
Templates 12 to 20 print Sunday through Saturday in fixed order instead of dates, with the weekends shaded. In templates 12, 13, 14, 17, 18 and 19 the weekdays run as rows across the months, in templates 15, 16 and 20 as columns, so anything on a weekly cycle falls in a straight line - just right for a teacher planner or a class schedule.
Templates 12 to 20 print Sunday through Saturday in fixed order instead of dates, with the weekends shaded. In templates 12, 13, 14, 17, 18 and 19 the weekdays run as rows across the months, in templates 15, 16 and 20 as columns, so anything on a weekly cycle falls in a straight line - just right for a teacher planner or a class schedule.
Month headings only
Templates 21 to 36 give each month a labeled space and nothing else, ruled or open: checklists and to-do lists, minimalist planners, goal planners (templates 25, 26, 33 and 34) and planners for two school years on one page (templates 27, 28, 35 and 36). Best for curriculum maps and term goals.
Templates 21 to 36 give each month a labeled space and nothing else, ruled or open: checklists and to-do lists, minimalist planners, goal planners (templates 25, 26, 33 and 34) and planners for two school years on one page (templates 27, 28, 35 and 36). Best for curriculum maps and term goals.
One, two or four pages
Most templates fit the school year on one page. Templates 3, 9, 13 and 18 spread it over two pages with six months each, and templates 4, 10, 14 and 19 over four pages with one quarter per page, for the biggest writing space.
Most templates fit the school year on one page. Templates 3, 9, 13 and 18 spread it over two pages with six months each, and templates 4, 10, 14 and 19 over four pages with one quarter per page, for the biggest writing space.
Landscape or portrait
Templates 1 to 6, 12 to 16 and 21 to 28 are in landscape, templates 7 to 11, 17 to 20 and 29 to 36 in portrait, all on US Letter paper (8.5 x 11 inches). August to December carry a salmon-red heading and January to July a blue one, marking the new calendar year even with no year printed. To save color ink, you can print any template in black and white.
Templates 1 to 6, 12 to 16 and 21 to 28 are in landscape, templates 7 to 11, 17 to 20 and 29 to 36 in portrait, all on US Letter paper (8.5 x 11 inches). August to December carry a salmon-red heading and January to July a blue one, marking the new calendar year even with no year printed. To save color ink, you can print any template in black and white.
Edit in Excel, then print
Type straight into the cells, shade a term or an exam week, or add your own school logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). As the planner is undated, one master copy serves you every August. The planner also opens in Google Sheets, Excel for the web and LibreOffice Calc. Prefer to write by hand? The same planners are available as PDF files.
Type straight into the cells, shade a term or an exam week, or add your own school logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). As the planner is undated, one master copy serves you every August. The planner also opens in Google Sheets, Excel for the web and LibreOffice Calc. Prefer to write by hand? The same planners are available as PDF files.
School year planners for Microsoft Excel
with numbered days (11 templates)
Every month numbered 1 to 31, no weekdays attached, so the same sheet works in any year.
Landscape layouts first, then portrait.
Landscape layouts first, then portrait.
Template 1 (Excel)
School year wall planner
landscape, 1 page, numbered days
- 1 page, landscape orientation (horizontal)
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- the complete school year in one view, with the summer break at both ends
- suits a classroom wall, a teachers' lounge or a department bulletin board
- twelve numbered month columns, 1 to 31, running left to right across the sheet
- the 31st grayed out on the months that do not have one
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 11 page · 18 KB · xlsx file
Template 2 (Excel)
School year planner
landscape, 1 page, dates down both sides
- 1 page, landscape orientation (horizontal)
- shows months and dates (but no days of the week)
- dates repeated at each side of the page
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- easier to read across than a single-sided wall planner, which suits a wide sheet on a wall
- day numbers in the margins only, so the twelve month columns stay completely clear to write in
- the 31st grayed out on the months that do not have one
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 21 page · 17 KB · xlsx file
Template 3 (Excel)
Half-year school planner
landscape, 2 pages, six months per sheet
- page orientation: landscape (horizontal)
- year on 2 pages, six months / half a year to a page
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- larger writing space than the one-page version, enough to enter deadlines and meetings by hand
- works as a wall chart with both sheets pinned up together
- six numbered month columns per sheet, roughly twice the width of the one-page version
- the calendar year changes at the blue January column, partway across the first sheet
- free to download, editable, customizable, easily printable
Download template 32 pages · 18 KB · xlsx file
Template 4 (Excel)
Quarterly school planner
landscape, 4 pages, one quarter per sheet
- page orientation: landscape (horizontal)
- year on 4 pages, three months / one quarter to a page
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- the largest writing space of any layout on this page
- roughly one grading period per sheet, with room for lesson topics and assessment dates
- print all four at the start of the year, or one at a time and replace it as the year moves on
- three numbered month columns per sheet, the widest day columns of any layout here
- each sheet headed Q1, Q2, Q3 or Q4
- free to download, editable, customizable, easily printable
Download template 44 pages · 20 KB · xlsx file
Template 5 (Excel)
Linear school year planner
landscape, 1 page, days in a row
- 1 page, landscape orientation (horizontal)
- shows months and dates (but no days of the week)
- days arranged linearly (horizontally), months stacked below each other
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- reads as a timeline, so the length of a unit, project or term is easy to measure
- suits syllabus planning, curriculum mapping and long class projects
- months as rows down the left, day numbers 1 to 31 as columns across the top and repeated along the bottom
- grayed cells mark the days a month does not have
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 51 page · 17 KB · xlsx file
Template 6 (Excel)
Year at a glance school planner
landscape, 1 page, numbered days
- 1 page, landscape orientation (horizontal)
- shows months and dates (but no days of the week)
- classic yearly calendar design, all 12 months as separate blocks
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- a quick reference sheet for checking dates rather than writing entries in
- compact enough to hand out to a class or file inside the cover of a binder
- twelve month blocks arranged four across and three down
- seven numbers to a row: 1 to 7, 8 to 14, and so on to 31
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- the counterpart to template 16, which shows weekdays instead of numbered days
- free to download, editable, customizable, easily printable
Download template 61 page · 17 KB · xlsx file
Template 7 (Excel)
School year planner
portrait, 1 page, two half-year blocks
- 1 page, portrait orientation (vertical)
- year divided into two half-year / six-month blocks
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- portrait format fits a binder, a course folder or a notebook without folding
- six numbered month columns per block, August to January above and February to July below
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 71 page · 18 KB · xlsx file
Template 8 (Excel)
Student year planner
portrait, 1 page, dates down both sides
- 1 page, portrait orientation (vertical)
- shows months and dates (but no days of the week)
- dates repeated at each side of the page
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- suits a binder, a locker door or a study wall
- for assignment deadlines, exam periods, study blocks and reading targets
- day numbers in both margins, twelve abbreviated month columns left clear for your entries
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 81 page · 18 KB · xlsx file
Template 9 (Excel)
Half-year student planner
portrait, 2 pages, six months per sheet
- page orientation: portrait (vertical)
- year on 2 pages, six months / half a year to a page
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- taller day boxes than the single-page portrait layouts, with room for a time or a room number
- suits student planners, course packs and study walls
- six numbered month columns per sheet, roughly twice the width of the single-page portrait layouts
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 92 pages · 18 KB · xlsx file
Template 10 (Excel)
Quarterly planner for schools
portrait, 4 pages, one quarter per sheet
- page orientation: portrait (vertical)
- year on 4 pages, three months / one quarter to a page
- shows months and dates (but no days of the week)
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- the largest writing space of the portrait layouts
- for assessment schedules, assignment deadlines and activity programs
- three numbered month columns per sheet, headed Q1 through Q4
- the tallest rows and widest columns of the numbered portrait layouts
- free to download, editable, customizable, easily printable
Download template 104 pages · 19 KB · xlsx file
Template 11 (Excel)
Year at a glance planner
portrait, 1 page, numbered days
- 1 page, portrait orientation (vertical)
- shows months and dates (but no days of the week)
- classic yearly calendar design, all 12 months as separate blocks
- runs from August 1 to July 31
- undated: no year printed, so the same planner works for every school year
- a quick reference sheet, small enough to hand out or file in a course pack
- twelve month blocks arranged three across and four down
- seven numbers to a row: 1 to 7, 8 to 14, and so on to 31
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- the counterpart to template 20, which shows weekdays instead of numbered days
- free to download, editable, customizable, easily printable
Download template 111 page · 17 KB · xlsx file
School year planners for Microsoft Excel
with aligned weekdays (9 templates)
Sunday through Saturday in fixed repeating order, no dates at all, weekends shaded yellow and orange.
Landscape layouts first, then portrait.
Landscape layouts first, then portrait.
Template 12 (Excel)
Undated school planner
landscape, 1 page, weekdays aligned
- 1 page, landscape orientation (horizontal)
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- runs from August to July
- anything on a weekly cycle lines up in a single column
- built for scheduling a repeating weekly schedule rather than recording individual dates
- weekdays as rows, month names as columns, so a weekly commitment runs straight across the sheet
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 121 page · 17 KB · xlsx file
Template 13 (Excel)
Semester planner
landscape, 2 pages, weekdays aligned
- page orientation: landscape (horizontal)
- year on 2 pages, six months / half a year to a page
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- runs from August to July
- one sheet per semester, each a clean weekly grid to build a schedule on
- for use as a yearly school planner or teacher planner, among many other applications
- weekdays as rows across six month columns per sheet
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- free to download, editable, customizable, easily printable
Download template 132 pages · 18 KB · xlsx file
Template 14 (Excel)
Quarter-by-quarter planner
landscape, 4 pages, weekdays aligned
- page orientation: landscape (horizontal)
- year on 4 pages, three months / one quarter to a page
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- runs from August to July
- shows at a glance how many of each weekday a quarter contains
- suits class scheduling, club and activity programs and rotating duties
- three month columns per sheet, headed Q1 through Q4, with the weekdays as rows
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- free to download, editable, customizable, easily printable
Download template 144 pages · 19 KB · xlsx file
Template 15 (Excel)
Linear teacher planner
landscape, 1 page, weekdays in columns
- 1 page, landscape orientation (horizontal)
- shows months and days of the week (but no dates)
- days aligned vertically (same days of the week below each other)
- Sunday start
- runs from August to July
- weekends form continuous vertical stripes, so the working weeks stand out
- makes teaching days easy to count across any stretch of the year
- doubles as an attendance sheet or a habit tracker for the school year
- weekdays as columns repeating across the sheet, months as rows down the left
- shaded Saturdays and Sundays fall as vertical stripes down the full height of the sheet
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 151 page · 17 KB · xlsx file
Template 16 (Excel)
Blank school year planner
landscape, 1 page, weekdays instead of dates
- 1 page, landscape orientation (horizontal)
- shows months and days of the week (but no dates)
- Sunday start
- classic yearly calendar design, all 12 months as separate blocks
- runs from August to July
- a truly blank school year planner: write your own dates in for any year
- the counterpart to template 6, which shows numbered days instead
- twelve month blocks four across and three down, each headed Su Mo Tu We Th Fr Sa
- Sunday in an orange column at the left of each block, Saturday in a yellow one at the right
- free to download, editable, customizable, easily printable
Download template 161 page · 17 KB · xlsx file
Template 17 (Excel)
College year planner
portrait, 1 page, weekdays aligned
- 1 page, portrait orientation (vertical)
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- runs from August to July
- lectures, labs, seminars and shifts that repeat weekly line up in one column
- weekdays as rows across twelve abbreviated month columns
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- free to download, editable, customizable, easily printable
Download template 171 page · 18 KB · xlsx file
Template 18 (Excel)
Semester planner for students
portrait, 2 pages, weekdays aligned
- page orientation: portrait (vertical)
- year on 2 pages, six months / half a year to a page
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- runs from August to July
- one sheet per semester, reusable for the next intake unchanged
- weekdays as rows across six month columns per sheet
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- free to download, editable, customizable, easily printable
Download template 182 pages · 18 KB · xlsx file
Template 19 (Excel)
Quarter-by-quarter teacher planner
portrait, 4 pages, weekdays aligned
- page orientation: portrait (vertical)
- year on 4 pages, three months / one quarter to a page
- days aligned horizontally (same days of the week next to each other)
- Sunday start
- shows months and days of the week (but no dates)
- weekday abbreviations repeated down both edges of the page
- with ample space for notes under each month heading
- runs from August to July
- the tallest rows of any weekday layout here, so each weekly slot holds a real entry
- Saturdays shaded pale yellow and Sundays pale orange, so the weekends are visible without reading a single label
- free to download, editable, customizable, easily printable
Download template 194 pages · 20 KB · xlsx file
Template 20 (Excel)
Blank school planner
portrait, 1 page, weekdays instead of dates
- 1 page, portrait orientation (vertical)
- shows months and days of the week (but no dates)
- Sunday start
- classic yearly calendar design, all 12 months as separate blocks
- runs from August to July
- a truly blank school year planner: write your own dates in for any year
- the counterpart to template 11, which shows numbered days instead
- twelve month blocks three across and four down, each headed Su Mo Tu We Th Fr Sa
- Sunday in an orange column at the left of each block, Saturday in a yellow one at the right
- free to download, editable, customizable, easily printable
Download template 201 page · 17 KB · xlsx file
School year planners for Microsoft Excel
with month headings only (16 templates)
Twelve labeled spaces, ruled or open: goal sheets, lists and checklists rather than calendars.
Landscape layouts first, then portrait.
Landscape layouts first, then portrait.
Template 21 (Excel)
School year checklist
landscape, 1 page, two columns, lined
- 1 page, landscape orientation (horizontal)
- shows months but neither dates nor days of the week
- year divided into two six-monthly columns, arranged side by side
- months lined - use as to-do-list or check list for the school year
- runs from August to July
- ruled lines keep handwriting straight and show how much room each month has
- suits curriculum maps, ordering schedules and term-by-term to-do lists
- each month a small colored label with ruled lines running out beside it
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 211 page · 16 KB · xlsx file
Template 22 (Excel)
School year overview
landscape, 1 page, two columns
- 1 page, landscape orientation (horizontal)
- shows months but neither dates nor days of the week
- year divided into two six-monthly columns, arranged side by side
- handy for advance planning of yearly school activities
- runs from August to July
- open space under each month for bullets, sketches or short tables
- undated: no year printed, so the same overview works for every school year
- month names rotated vertically in a colored box at the left of each row, leaving the row itself fully open
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 221 page · 15 KB · xlsx file
Template 23 (Excel)
Minimalist school planner
landscape, 1 page, two half-year blocks
- 1 page, landscape orientation (horizontal)
- year divided into two rows of six months each
- shows months but neither dates nor days of the week
- minimalist design
- runs from August to July
- undated: no year printed, so the same planner works for every school year
- uncluttered enough to suit a shared wall or a printed handbook
- six month columns per block, each a single tall open cell under its heading
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 231 page · 15 KB · xlsx file
Template 24 (Excel)
Minimalist year planner
landscape, 1 page, months side by side
- 1 page, landscape orientation (horizontal)
- shows months but neither dates nor days of the week
- months aligned horizontally (side by side)
- minimalist design
- runs from August to July
- every month gets the same width, so nothing looks more important than anything else
- works as a curriculum map, a project overview or a year-long tracker
- all twelve months side by side in a single row, each one tall open column
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 241 page · 15 KB · xlsx file
Template 25 (Excel)
School year goal planner
landscape, 1 page, open space per month
- 1 page, landscape orientation (horizontal)
- shows months but neither dates nor days of the week
- with ample space for notes under each month heading
- runs from August to July
- built for monthly goals, targets and milestones rather than daily entries
- suits tutoring plans, curriculum maps and qualification schedules
- the counterpart to template 26, which is ruled under each month heading
- twelve blocks four across and three down, each a large open box
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 251 page · 16 KB · xlsx file
Template 26 (Excel)
Lined goal planner
landscape, 1 page, ruled under each month
- 1 page, landscape orientation (horizontal)
- shows months but neither dates nor days of the week
- lined
- runs from August to July
- ruled lines make it easy to fill in consistently across a class or a department
- the counterpart to template 25, which leaves the space under each month open
- twelve ruled blocks four across and three down
- free to download, editable, customizable, easily printable
Download template 261 page · 16 KB · xlsx file
Template 27 (Excel)
Planner for two school years
landscape, 1 page, years side by side
- two years on 1 page, landscape orientation (horizontal)
- months aligned vertically, years arranged side by side
- list design, lined
- each year headed "School year:" with a blank space to fill in the years yourself
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- shows months but neither dates nor days of the week
- runs from August to July
- covers any two consecutive school years, since no year is printed
- suits two-year courses, qualifications and rolling programs
- free to download, editable, customizable, easily printable
Download template 271 page · 16 KB · xlsx file
Template 28 (Excel)
Two-year school planner
landscape, 1 page, years stacked
- two years on 1 page, landscape orientation (horizontal)
- each year divided into two six-monthly columns, years stacked
- list design, lined
- shows months but neither dates nor days of the week
- runs from August to July
- read down a column to compare the same month across both years
- the counterpart to template 27, which sets the two years side by side instead
- each year headed "School year:" with a blank space to fill in the years yourself
- free to download, editable, customizable, easily printable
Download template 281 page · 16 KB · xlsx file
Template 29 (Excel)
School year to-do list
portrait, 1 page, list design, lined
- 1 page, portrait orientation (vertical)
- shows months but neither dates nor days of the week
- list design (months aligned vertically), lined
- runs from August to July
- use as a month-by-month to-do list or checklist for the school year
- ruled lines keep entries even when the sheet is shared or handed out
- each month a small colored label with ruled lines running out beside it
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 291 page · 16 KB · xlsx file
Template 30 (Excel)
Two-column school checklist
portrait, 1 page, list design, lined
- 1 page, portrait orientation (vertical)
- year divided into two six-monthly columns, arranged side by side
- shows months but neither dates nor days of the week
- list design (months aligned vertically), lined
- for creating lists of all kinds pertaining to the school year
- runs from August to July
- fits the whole year on one page at half the height of the single-column version
- August to January in the left column, February to July in the right
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 301 page · 17 KB · xlsx file
Template 31 (Excel)
School year list planner
portrait, 1 page, open space per month
- 1 page, portrait orientation (vertical)
- shows months but neither dates nor days of the week
- list design (months aligned vertically)
- runs from August to July
- open space rather than ruled lines, for bullets, sketches or short tables
- the counterpart to template 29, which is ruled for handwriting
- month names rotated vertically in a colored box at the left of each row
- the deepest open rows of the portrait list layouts
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 311 page · 15 KB · xlsx file
Template 32 (Excel)
Minimalist school year planner
portrait, 1 page, two half-year blocks
- 1 page, portrait orientation (vertical)
- year divided into two six-month blocks
- shows months but neither dates nor days of the week
- minimalist design
- with ample space for notes under each month heading
- runs from August to July
- the most writing room per month of the single-page portrait layouts
- good for a curriculum overview or a term-by-term goal sheet
- six month columns per block, each a single tall open cell
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 321 page · 15 KB · xlsx file
Template 33 (Excel)
Goal planner for the school year
portrait, 1 page, open space per month
- 1 page, portrait orientation (vertical)
- shows months but neither dates nor days of the week
- with ample space for notes under each month heading
- runs from August to July
- built for monthly goals, targets and milestones rather than daily entries
- fits a binder or a study wall alongside a dated calendar
- twelve blocks three across and four down, each a large open box
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- free to download, editable, customizable, easily printable
Download template 331 page · 16 KB · xlsx file
Template 34 (Excel)
Lined goal planner
portrait, 1 page, ruled under each month
- 1 page, portrait orientation (vertical)
- lined
- shows months but neither dates nor days of the week
- runs from August to July
- ruled lines make it easy to fill in consistently across a class or a homeroom
- twelve ruled blocks three across and four down
- the counterpart to template 33, which leaves the space under each month open
- free to download, editable, customizable, easily printable
Download template 341 page · 16 KB · xlsx file
Template 35 (Excel)
Two school years on one page
portrait, 1 page, years side by side
- two years on 1 page, portrait orientation (vertical)
- months aligned vertically, years arranged side by side
- each year headed "School year:" with a blank space to fill in the years yourself
- August to December headed in salmon red, January to July in blue, so the change of calendar year shows at a glance
- shows months but neither dates nor days of the week
- runs from August to July
- covers any two consecutive school years, since no year is printed
- suits two-year courses, qualifications and rolling programs
- free to download, editable, customizable, easily printable
Download template 351 page · 9 KB · xlsx file
Template 36 (Excel)
Two-year planner for school
portrait, 1 page, years stacked
- two years on 1 page, portrait orientation (vertical)
- each year divided into two six-monthly columns, years stacked
- shows months but neither dates nor days of the week
- runs from August to July
- read down a column to compare the same month across both years
- the counterpart to template 35, which sets the two years side by side instead
- each year headed "School year:" with a blank space to fill in the years yourself
- free to download, editable, customizable, easily printable
Download template 361 page · 16 KB · xlsx file
Planning the school year with an undated planner
Ways to use a school year planner
Teachers and lesson planning
Map the teaching year before it starts: units and topics across the terms, assessment points, assignments turned in and handed back, trips, in-service days. A landscape sheet on the teachers' lounge wall keeps a department working from one plan, and a portrait one drops into a lesson plan binder or a substitute folder.
Map the teaching year before it starts: units and topics across the terms, assessment points, assignments turned in and handed back, trips, in-service days. A landscape sheet on the teachers' lounge wall keeps a department working from one plan, and a portrait one drops into a lesson plan binder or a substitute folder.
Students and assignments
A blank year planner for a binder, a locker door or a study wall, with assignment deadlines, exam periods, study blocks and reading targets in one place. The two-page and four-page layouts give enough room to write what is actually due rather than just marking that something is.
A blank year planner for a binder, a locker door or a study wall, with assignment deadlines, exam periods, study blocks and reading targets in one place. The two-page and four-page layouts give enough room to write what is actually due rather than just marking that something is.
Homeschool families
Set your own start and end dates, co-op days, field trips and weeks off, and count teaching days against whatever your state asks for. Nothing on these sheets assumes a district calendar, a standard term structure or even a five-day week, which is exactly why an undated planner suits homeschooling better than a dated one.
Set your own start and end dates, co-op days, field trips and weeks off, and count teaching days against whatever your state asks for. Nothing on these sheets assumes a district calendar, a standard term structure or even a five-day week, which is exactly why an undated planner suits homeschooling better than a dated one.
Schools, colleges and offices
Enrollment periods, parent-teacher conferences, board meetings, staff training, open houses and the program of clubs and activities. Free to copy for every staff member, and the same master works next year without anyone reissuing it.
Enrollment periods, parent-teacher conferences, board meetings, staff training, open houses and the program of clubs and activities. Free to copy for every staff member, and the same master works next year without anyone reissuing it.
Goals, targets and long projects
The goal planner and list layouts turn the school year into twelve labeled spaces: targets per month, books to cover, equipment to order, skills to sign off. Useful for tutoring plans, curriculum maps, qualification schedules and anything measured by month rather than by date.
The goal planner and list layouts turn the school year into twelve labeled spaces: targets per month, books to cover, equipment to order, skills to sign off. Useful for tutoring plans, curriculum maps, qualification schedules and anything measured by month rather than by date.
Undated planner or dated school calendar?
Why undated
Undated is the whole point of these planners. Nothing on them carries a year, which means the same planner works for this school year, the next one and the one after that: print a fresh copy each August and the sheet is current again. It also means you are not tied to anyone else's idea of when the year starts, which is what makes these templates useful to homeschool families, private schools, tutors and anyone on a schedule that does not match the local district.
Undated is the whole point of these planners. Nothing on them carries a year, which means the same planner works for this school year, the next one and the one after that: print a fresh copy each August and the sheet is current again. It also means you are not tied to anyone else's idea of when the year starts, which is what makes these templates useful to homeschool families, private schools, tutors and anyone on a schedule that does not match the local district.
When you need the dates
If you want a planner with the actual dates already filled in for a specific year, that is a different sheet: see the dated school year calendars for 2026/27, which show every date, every weekday and every US federal holiday for that year. Use those when you need the year itself; use the planners on this page when you need the structure and will supply the year yourself.
If you want a planner with the actual dates already filled in for a specific year, that is a different sheet: see the dated school year calendars for 2026/27, which show every date, every weekday and every US federal holiday for that year. Use those when you need the year itself; use the planners on this page when you need the structure and will supply the year yourself.
Ideas for your school year planner in Excel
A tab for each class, subject or child
Right-click the sheet tab, choose Move or Copy and check "Create a copy" to give each class period, subject or grade its own planner, or one for every child in a homeschool family, all in one workbook. Name the tabs and type the school year into each title, and the planners are ready for this year.
Right-click the sheet tab, choose Move or Copy and check "Create a copy" to give each class period, subject or grade its own planner, or one for every child in a homeschool family, all in one workbook. Name the tabs and type the school year into each title, and the planners are ready for this year.
Color-coded units and a checklist of standards
Shade each unit or subject in its own fill color across the weeks it runs, and use Format Painter to copy a color to the next block of days. A second worksheet with the units or standards in one column and a "Done" column beside it, with a filter on top, shows in one click what is still left to teach.
Shade each unit or subject in its own fill color across the weeks it runs, and use Format Painter to copy a color to the next block of days. A second worksheet with the units or standards in one column and a "Done" column beside it, with a filter on top, shows in one click what is still left to teach.
Using the templates
Terms of Use
All templates on this site may be used free of charge, at home, at work and at school, provided that the Calendarpedia logo, the copyright notice with the website address ("© Calendarpedia® www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") stay on the template. The templates may not be sold or built into products that are sold, and the blank templates (or copies with only minor changes) may not be offered for download on other websites. All content on this site is protected by copyright © 2011-2026 Calendarpedia®. All rights reserved. Data is provided 'as is' without warranty of any kind, may contain errors and is subject to change without notice. If you find a mistake, please let us know. Full details are in our Terms of Use.
System requirements and compatibility
Every template is saved in Microsoft Excel (.xlsx) format, the Office Open XML spreadsheet format standardized as ISO/IEC 29500.
- Microsoft Excel
The templates open in Excel 2007 and later for Windows, Excel 2008 and later for Mac, Microsoft 365 and Excel for the web. - Google Sheets
The .xlsx files open in Google Sheets with the layout intact, so you can fill the template in from a browser on any computer, tablet or phone without installing anything. - Free alternatives
If you do not have Excel installed, Microsoft 365 for the web is free to use in a browser, and free desktop alternatives such as FreeOffice PlanMaker and LibreOffice Calc open our templates without formatting errors. Apple's Numbers opens the files too, but the layout may shift, and OpenOffice Calc unfortunately has formatting problems with some of our calendars. - Editing on a phone or tablet
The Excel app for Android and iOS and the Google Sheets app both open these files, so you can add or check an entry away from your desk and print the sheet later from any computer. - Your own dates, colors and logo
Type your entries straight into the day cells, shade the days that matter to you and add your own logo alongside the Calendarpedia logo - our FAQ shows how to add your own dates, colors or logo. - Printing in black and white
To save color ink, you can print any template in black and white. - Older versions of Excel
Excel 2003 and older versions can't open .xlsx files directly. Open the template in Excel for the web or one of the free programs above instead, or use the PDF version of the calendar.
How to open and print these templates in Google Sheets
Download the .xlsx file first. Then either drag it into Google Drive, right-click it and choose Open with → Google Sheets, or open Sheets and go to File → Open → Upload. The template keeps its layout and colors, and you can type into the cells and change the fill colors exactly as you would in Excel.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
Problems downloading, opening or printing a template?
Our FAQ explains how to print a template in a different size or in black and white, what to do if the edges are cut off, a download doesn't work or a file won't open in Excel or Word, which other programs you can use and how to add your own dates, colors or logo.



































