Yearly Planners for Microsoft Excel

Yearly planner templates in Excel format (undated) - 36 designs, free to download & print

Sponsored links
Practical, customizable and versatile yearly planner templates suitable for a wide variety of uses. The templates are blank, printable and macro-free and are easy to edit, amend, save and use again later. They are saved in Microsoft Excel ".xlsx" format and can be used with the newer versions of Excel that support the XML document standard (files with ".xlsx" extension - Excel 2007, 2010, 2013, 2016, 2019, 2021 and Office 365). If you have one of the older versions of Excel that only supports the ".xls" format (Excel 2000, 2002/XP & 2003), or if you don't have Excel installed, use Microsoft Office Online or one of the free Microsoft Excel/Microsoft Office alternatives FreeOffice PlanMaker, LibreOffice Calc and Google Sheets, which are all free of charge (OpenOffice Calc unfortunately has minor formatting problems when opening our calendars). Also compatible with Microsoft Office for Mac (macOS) and Microsoft Office mobile for iPad/iOS, Android and Windows 10 mobile. Read more about the various Excel versions and file formats on Wikipedia. More free Excel calendar templates are also available from the Microsoft template gallery (calendar section).

The files can be easily modified and adapted to meet your specific requirements, then saved and used again at a later stage. All our yearly planner templates are blank, macro-free, editable and printable and may be used free of charge for non-commercial use, provided that the Calendarpedia logo, the copyright notice ("© Calendarpedia®, www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") are not removed. Not for commercial distribution or resale. For commercial use please contact us. All content of this website is copyright © 2011-2023 Calendarpedia®. All rights reserved. Data provided 'as is' without warranty and subject to error and change without notice.

See also:

Yearly planners in landscape orientation (19 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageDownload template 1: Yearly planner template for Microsoft Excel, landscape, 1 page
Template 1:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page

Template 1:
Yearly planner
landscape

  • page orientation: landscape (horizontal), 1 page
  • shows months at the top and dates for every months (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 1
View large imageDownload template 2: Yearly overview planner template for Microsoft Excel, landscape, 1 page, day numbers at each side
Template 2:
Yearly overview planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, day numbers at each side

Template 2:
Yearly overview planner
landscape, day numbers at each side

  • page orientation: landscape (horizontal), 1 page
  • day numbers at each side of the page
  • shows months at the top and dates (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 2
View large imageDownload template 3: Yearly planner template for Microsoft Excel, landscape, 1 page, days aligned
Template 3:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, days aligned

Template 3:
Yearly planner
landscape, days aligned

  • page orientation: landscape (horizontal), 1 page
  • days aligned horizontally, Sunday start
  • shows months and days of the week (but no dates)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 3
View large imageDownload template 4: Half-yearly planner template for Microsoft Excel, landscape, 2 pages
Template 4:
Half-yearly planner
for Microsoft Excel (.xlsx file),
landscape, 2 pages

Template 4:
Half-yearly planner on 2 pages
landscape

  • page orientation: landscape (horizontal)
  • year on 2 pages, six months / half a year per page
  • shows months and dates (but no days of the week)
  • also handy for planning business meetings or as a yearly productivity planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 4
View large imageDownload template 5: Half-yearly planner template for Microsoft Excel, landscape, 2 pages, days aligned
Template 5:
Half-yearly planner
for Microsoft Excel (.xlsx file),
landscape, 2 pages, days aligned

Template 5:
Half-yearly planner on 2 pages
landscape, days aligned

  • page orientation: landscape (horizontal)
  • year on 2 pages, six months / half a year per page
  • shows months and days of the week (but no dates)
  • days aligned horizontally, Sunday start
  • for creating yearly lists of all kinds, yearly diet plans, yearly school planners and many other uses
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 5
View large imageDownload template 6: Quarterly planner template for Microsoft Excel, landscape, 4 pages
Template 6:
Quarterly planner
for Microsoft Excel (.xlsx file),
landscape, 4 pages

Template 6:
Quarterly planner on 4 pages
landscape

  • page orientation: landscape (horizontal)
  • year on 4 pages, three months / one quarter per page
  • shows months and dates (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 6
View large imageDownload template 7: Quarterly planner template for Microsoft Excel, landscape, 4 pages, days aligned
Template 7:
Quarterly planner
for Microsoft Excel (.xlsx file),
landscape, 4 pages, days aligned

Template 7:
Quarterly planner on 4 pages
landscape, days aligned

  • page orientation: landscape (horizontal)
  • year on 4 pages, three months / one quarter per page
  • shows months and days of the week (but no dates)
  • days aligned horizontally, Sunday start
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 7
View large imageDownload template 8: Yearly planner template for Microsoft Excel, landscape, 1 page, linear
Template 8:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, linear

Template 8:
Yearly planner
landscape, linear

  • page orientation: landscape (horizontal), 1 page
  • shows months and dates (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 8
View large imageDownload template 9: Yearly planner template for Microsoft Excel, landscape, 1 page, linear, days aligned
Template 9:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, linear, days aligned

Template 9:
Yearly planner
landscape, linear, days aligned

  • page orientation: landscape (horizontal), 1 page
  • shows months and days of the week (but no dates)
  • days aligned vertically, Sunday start
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 9
View large imageDownload template 10: Yearly planner template for Microsoft Excel, landscape, 1 page, lined, year divided into 2 columns
Template 10:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, 2 columns,
list design, lined

Template 10:
Yearly planner
landscape, 2 columns, lined

  • page orientation: landscape (horizontal), 1 page
  • year divided into two six-monthly columns, arranged side by side
  • months lined - use as monthly to do list, yearly month planner or check list
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 10
View large imageDownload template 11: Yearly planner template for Microsoft Excel, landscape, 1 page, multi-colored, year divided into 2 columns
Template 11:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, 2 columns, multi-colored

Template 11:
Yearly planner
landscape, 2 columns, multi-colored

  • page orientation: landscape (horizontal), 1 page
  • shows months but neither dates nor days of the week
  • every month in a different color ("rainbow planner")
  • handy for advance planning of yearly activities
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 11
View large imageDownload template 12: Yearly planner template for Microsoft Excel, landscape, 1 page, two six-month blocks, minimalist
Template 12:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page,
two six-month blocks, minimalist

Template 12:
Yearly planner
landscape, two six-month blocks, minimalist

  • page orientation: landscape (horizontal), 1 page
  • year divided into two rows of six months each
  • shows months but neither dates nor days of the week
  • minimalist design
  • great for a yearly to do list or as a yearly family planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 12
View large imageDownload template 13: Yearly planner template for Microsoft Excel, landscape, 1 page, minimalist
Template 13:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, minimalist

Template 13:
Yearly planner
landscape, minimalist

  • page orientation: landscape (horizontal), 1 page
  • shows months but neither dates nor days of the week
  • months arranged horizontally
  • minimalist design
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 13
View large imageDownload template 14: Yearly planner template for Microsoft Excel, landscape, 1 page, year at a glance
Template 14:
Yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, year at a glance

Template 14:
Yearly planner
landscape, year at a glance

  • page orientation: landscape (horizontal), 1 page
  • shows months and dates (but no days of the week)
  • classic design annual planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 14
View large imageDownload template 15: Blank yearly planner template for Microsoft Excel, landscape, 1 page, year at a glance
Template 15:
Blank yearly planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, year at a glance

Template 15:
Blank yearly planner
landscape, year at a glance

  • page orientation: landscape (horizontal), 1 page
  • shows months and days of the week (but no dates)
  • classic design annual planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 15
View large imageDownload template 16: Yearly box planner template for Microsoft Excel, landscape, 1 page, multi-colored
Template 16:
Yearly box planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, multi-colored

Template 16:
Yearly box planner
landscape, multi-colored

  • page orientation: landscape (horizontal), 1 page
  • shows months but neither dates nor days of the week
  • every month in a different color ("rainbow planner")
  • with ample space for notes under each month - use as yearly diary, routine planner or revision planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 16
View large imageDownload template 17: Yearly box planner template for Microsoft Excel, landscape, 1 page, lined
Template 17:
Yearly box planner
for Microsoft Excel (.xlsx file),
landscape, 1 page, lined

Template 17:
Yearly box planner
landscape, lined

  • page orientation: landscape (horizontal), 1 page
  • shows months but neither dates nor days of the week
  • lined
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 17
View large imageDownload template 18: Two-year planner template for Microsoft Excel, landscape, 1 page, lined
Template 18:
Two-year planner
for Microsoft Excel (.xlsx file),
landscape, 1 page,
years side by side, lined

Template 18:
2-year planner
landscape, years side by side

  • page orientation: landscape (horizontal), 1 page
  • months aligned vertically, years arranged side by side
  • shows months but neither dates nor days of the week
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 18
View large imageDownload template 19: Two-year planner template for Microsoft Excel, landscape, 1 page, lined
Template 19:
Two-year planner
for Microsoft Excel (.xlsx file),
landscape, 1 page,
years stacked, lined

Template 19:
2-year planner
landscape, years stacked

  • page orientation: landscape (horizontal), 1 page
  • months aligned vertically into two six-monthly columns, years stacked
  • shows months but neither dates nor days of the week
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 19
See also:

Yearly planners in portrait orientation (17 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageDownload template 20: Yearly planner template for Microsoft Excel, portrait, 1 page, two half-year blocks
Template 20:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, two half-year blocks

Template 20:
Yearly planner
portrait, 2 half-year blocks

  • page orientation: portrait (vertical), 1 page
  • year divided into two half-year / six-month blocks
  • shows months and dates (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 20
View large imageDownload template 21: Yearly overview planner template for Microsoft Excel, portrait, 1 page
Template 21:
Yearly overview planner
for Microsoft Excel (.xlsx file),
portrait, 1 page

Template 21:
Yearly overview planner
portrait

  • page orientation: portrait (vertical), 1 page
  • shows months and dates (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 21
View large imageDownload template 22: Yearly planner template for Microsoft Excel, portrait, 1 page, days aligned
Template 22:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, days aligned

Template 22:
Yearly planner
portrait, days aligned

  • page orientation: portrait (vertical), 1 page
  • days aligned horizontally, Sunday start
  • shows months and days of the week (but no dates)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 22
View large imageDownload template 23: Half-yearly planner template for Microsoft Excel, portrait, 2 pages
Template 23:
Half-yearly planner
for Microsoft Excel (.xlsx file),
portrait, 2 pages

Template 23:
Half-yearly planner on 2 pages
portrait

  • page orientation: portrait (vertical)
  • year on 2 pages, six months / half a year per page
  • shows months and dates (but no days of the week)
  • minimalist design
  • use it as a bi-yearly workout, fitness or exercise planner, among other uses
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 23
View large imageDownload template 24: Half-yearly planner template for Microsoft Excel, portrait, 2 pages, days aligned
Template 24:
Half-yearly planner
for Microsoft Excel (.xlsx file),
portrait, 2 pages, days aligned

Template 24:
Half-yearly planner on 2 pages
portrait, days aligned

  • page orientation: portrait (vertical)
  • year on 2 pages, six months / half a year per page
  • shows months and days of the week (but no dates)
  • days aligned horizontally, Sunday start
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 24
View large imageDownload template 25: Quarterly planner template for Microsoft Excel, portrait, 4 pages
Template 25:
Quarterly planner
for Microsoft Excel (.xlsx file),
portrait, 4 pages

Template 25:
Quarterly planner on 4 pages
portrait

  • page orientation: portrait (vertical)
  • year on 4 pages, three months / one quarter per page
  • shows months and dates (but no days of the week)
  • great for yearly life planning or as a yearly activity tracker
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 25
View large imageDownload template 26: Quarterly planner template for Microsoft Excel, portrait, 4 pages, days aligned
Template 26:
Quarterly planner
for Microsoft Excel (.xlsx file),
portrait, 4 pages, days aligned

Template 26:
Quarterly planner on 4 pages
portrait, days aligned

  • page orientation: portrait (vertical)
  • year on 4 pages, three months / one quarter per page
  • shows months and days of the week (but no dates)
  • days aligned horizontally, Sunday start
  • with ample space for notes - handy for a yearly to do list, to write down yearly goals or as a yearly food planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 26
View large imageDownload template 27: Yearly planner template for Microsoft Excel, portrait, 1 page, lined, list design (months vertically)
Template 27:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, lined,
list design (months vertically)

Template 27:
Yearly planner
portrait, list design, lined

  • page orientation: portrait (vertical), 1 page
  • list design (months aligned vertically), lined
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 27
View large imageDownload template 28: Yearly planner template for Microsoft Excel, portrait, 1 page, lined, list design (months vertically in two six-monthly columns)
Template 28:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, 2 columns,
list design, lined

Template 28:
Yearly planner
portrait, 2 columns, list design, lined

  • page orientation: portrait (vertical), 1 page
  • 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
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 28
View large imageDownload template 29: Yearly planner template for Microsoft Excel, portrait, 1 page, list design (months vertically), multi-colored
Template 29:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page,
list design, multi-colored

Template 29:
Yearly planner
portrait, list design, multi-colored

  • page orientation: portrait (vertical), 1 page
  • shows months but neither dates nor days of the week
  • every month in a different color ("rainbow planner")
  • list design (months aligned vertically)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 29
View large imageDownload template 30: Yearly planner template for Microsoft Excel, portrait, 1 page, two half-year blocks, minimalist design
Template 30:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page,
two half-year blocks, minimalist design

Template 30:
Yearly planner
portrait, two half-year blocks, minimalist

  • page orientation: portrait (vertical), 1 page
  • 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 - great for a yearly to do list, a yearly goal list or a yearly holiday planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 30
View large imageDownload template 31: Yearly planner template for Microsoft Excel, portrait, 1 page, year at a glance
Template 31:
Yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, year at a glance

Template 31:
Yearly planner
portrait, year at a glance

  • page orientation: portrait (vertical), 1 page
  • shows months and dates (but no days of the week)
  • classic design annual planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 31
View large imageDownload template 32: Blank yearly planner template for Microsoft Excel, portrait, 1 page, year at a glance
Template 32:
Blank yearly planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, year at a glance

Template 32:
Blank yearly planner
portrait, year at a glance

  • page orientation: portrait (vertical), 1 page
  • shows months and days of the week (but no dates)
  • classic design annual planner
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 32
View large imageDownload template 33: Yearly box planner template for Microsoft Excel, portrait, 1 page, multi-colored
Template 33:
Yearly box planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, multi-colored

Template 33:
Yearly box planner
portrait, multi-colored

  • page orientation: portrait (vertical), 1 page
  • shows months but neither dates nor days of the week
  • every month in a different color ("rainbow planner")
  • with ample space for notes under each month - use as life planner, job planner or yearly journal
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 33
View large imageDownload template 34: Yearly box planner template for Microsoft Excel, portrait, 1 page, lined
Template 34:
Yearly box planner
for Microsoft Excel (.xlsx file),
portrait, 1 page, lined

Template 34:
Yearly box planner
portrait, lined

  • page orientation: portrait (vertical), 1 page
  • lined
  • shows months but neither dates nor days of the week
  • use to create yearly payment or budget plans, a yearly financial plan or for other activities repeating regularly throughout the years
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 34
View large imageDownload template 35: Two-year planner template for Microsoft Excel, portrait, 1 page, years side by side, lined
Template 35:
Two-year planner
for Microsoft Excel (.xlsx file),
portrait, 1 page,
years side by side, lined

Template 35:
2-year planner
portrait, years side by side

  • page orientation: portrait (vertical), 1 page
  • months aligned vertically, years arranged side by side
  • shows months but neither dates nor days of the week
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 35
View large imageDownload template 36: Two-year planner template for Microsoft Excel, portrait, 1 page, years stacked, lined
Template 36:
Two-year planner
for Microsoft Excel (.xlsx file),
portrait, 1 page,
years stacked, lined

Template 36:
2-year planner
portrait, years stacked

  • page orientation: portrait (vertical), 1 page
  • months aligned vertically into two six-monthly columns, years stacked
  • shows months but neither dates nor days of the week
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 36
See also:
Calendar templates
Home  ·  Sitemap / archive
Yearly calendars
Word: 2023  ·  2024   / 2025
Excel:  2023  ·  2024   / 2025
PDF: 2023  ·  2024   / 2025
Quarterly calendars
Word  ·  Excel  ·  PDF
Monthly calendars
Nov  ·  Dec  ·  Jan  ·  Feb  ·  Mar
Weekly calendars
Word: 2023  ·  2024   / 2022
Excel:  2023  ·  2024   / 2022
PDF: 2023  ·  2024   / 2022
Daily calendars
Word  ·  Excel  ·  PDF
Hourly calendars
Word  ·  Excel  ·  PDF
Split year calendars 23/24
Word  ·  Excel  ·  PDF
School calendars 23/24
Word  ·  Excel  ·  PDF
Academic calendars 23/24
Word  ·  Excel  ·  PDF
Fiscal calendars 2024
Word  ·  Excel  ·  PDF
2 year calendars 23/24
Word  ·  Excel  ·  PDF
3 year calendars 23-25
Word  ·  Excel  ·  PDF
Photo calendars 2024
Word  ·  Excel  ·  PDF
Birthday calendars
Word  ·  Excel  ·  PDF
Blank calendars
Word  ·  Excel  ·  PDF
Perpetual calendars
Word  ·  Excel  ·  PDF
Online Calendars
Yearly Calendars
2023  ·  2024  ·  2025   / 2022
US Federal Holidays
2023  ·  2024  ·  2025   / 2022
Planners
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly  ·  Yearly
Schedules
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly
More...
Leap years
When is...?
Sitemap (list of all templates)



If this site helps you please consider a donation to a charity of your choice:


Search this site: