2020 Calendars for Excel

19 free printable yearly calendar templates for 2020 in Microsoft Excel format

Sponsored links
Multi-purpose Microsoft Excel calendars 2020 for the United States – practical, versatile, customizable, free to download and easily printable. These templates are suitable for a great variety of uses: holiday planner, trip planner, journey planner, travel planner, yearly overview, yearly planner, company calendar, office planner, holiday calendar, school calendar, college calendar, university planner, annual holiday chart and leave planner, attendance calendar, shift calendar, shift planner, yearly calendar, custom calendar, family planner, period calculator, ovulation calculator, pregnancy calendar, simple project management tool, team collaboration tool, EMM, ERP/MRP, SCM, PLM, CRM, HR, reporting, to do list, task management, appointment calendar, appointment planner, desktop calendar, wall calendar, wall planner, blank calendar, as time sheet, time management tool or time tracking software, for process management, process optimization, help desk administration, business administration, business intelligence and analytics, automation, forecasting, finance, accounting, financial planning, tax planning, sales and marketing, customer service, customer relationship management, process and supply chain management, data analysis, availability and booking, as pocket calendar, advertising calendar, community calendar, staff planner, employee scheduler, employee absence tracker, people planner, vacation planner, annual journal, events planner, scheduler, shared scheduling, date calculator, yearly record, work schedule, wedding planner, fiscal year planner, register or report and many more...

The variations range from yearly calendars on a single page (the whole year at a glance) to quarterly calendars on 4 pages (3 months/1 quarter on one page). 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 to 2021 and Office 365). If you have one of the older versions of Excel that only supports the ".xls" format (Excel 2000, 2002/XP and 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 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-2024 Calendarpedia®. All rights reserved. Data provided 'as is' without warranty and subject to error and change without notice.

Important note regarding paper size:
All templates downloadable below are in US letter paper size (8.5 by 11 inches - as used in the USA, Canada, Mexico, the Philippines and some South American countries). For templates in A4 paper size (the international standard paper size used in all other parts of the world) please see Calendarpedia's UK edition.

See also:

Other calendars for 2020:

Multi-year calendars for 2020:

Calendars 2020 in landscape orientation (9 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageTemplate 1: 2020 calendar in Microsoft Excel format, landscape, 1 page, multi-colored
Template 1: 2020 calendar,
landscape, 1 page, multi-colored

Template 1:
Calendar 2020
landscape, multi-colored

  • 1 page, landscape orientation (horizontal)
  • each month in a different color ("rainbow calendar") to reflect the changing of the seasons
  • months horizontally (along the top), days vertically (down the side)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 1
View large imageTemplate 2: 2020 calendar in Microsoft Excel format, landscape, 1 page
Template 2: 2020 calendar,
landscape, 1 page

Template 2:
Calendar 2020
landscape

  • 1 page, landscape orientation (horizontal)
  • months horizontally (along the top), days vertically (down the side)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 2
View large imageTemplate 3: 2020 calendar in Microsoft Excel format, landscape, 2 pages, half a year per page
Template 3: 2020 calendar,
landscape, 2 pages, half a year per page

Template 3:
Calendar 2020
landscape, 2 pages

  • 2 pages, landscape orientation (horizontal)
  • 6 months / half a year per page
  • months horizontally (along the top), days vertically (down the side)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 3
View large imageTemplate 4: 2020 calendar in Microsoft Excel format, landscape, 2 pages, days aligned, half a year per page
Template 4: 2020 calendar,
landscape, 2 pages, days aligned,
half a year per page

Template 4:
Calendar 2020
landscape, 2 pages, days aligned

  • 2 pages, landscape orientation (horizontal)
  • days aligned horizontally (days of the week in the same row) for easy week overview
  • 6 months / half a year per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 4
View large imageTemplate 5: 2020 calendar in Microsoft Excel format, landscape, 4 pages, one calendar quarter per page
Template 5: 2020 calendar,
landscape, 4 pages,
one calendar quarter per page

Template 5:
Calendar 2020
landscape, 4 pages

  • 4 pages, landscape orientation (horizontal)
  • months horizontally (along the top), days vertically (down the side)
  • quarterly calendar - 3 months / one calendar quarter per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 5
View large imageTemplate 6: 2020 calendar in Microsoft Excel format, landscape, 1 page, linear
Template 6: 2020 calendar,
landscape, 1 page, linear

Template 6:
Calendar 2020
landscape, linear

  • 1 page, landscape orientation (horizontal)
  • days aligned horizontally (days of the week in the same column)
  • months stacked above each other
  • for use as project timeline tracker
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 6
View large imageTemplate 7: 2020 calendar in Microsoft Excel format, landscape, 1 page, linear, days aligned
Template 7: 2020 calendar,
landscape, 1 page, linear, days aligned

Template 7:
Calendar 2020
landscape, linear, days aligned

  • 1 page, landscape orientation (horizontal)
  • days aligned horizontally (days of the week in the same column)
  • months stacked above each other
  • days aligned (days of the week in the same column)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 7
View large imageTemplate 8: 2020 calendar in Microsoft Excel format, landscape, 1 page, year at a glance, multi-colored
Template 8: 2020 calendar,
landscape, 1 page, year at a glance,
multi-colored

Template 8:
Calendar 2020
landscape, year at a glance, multi-colored

  • 1 page, landscape orientation (horizontal)
  • classic design annual planner
  • each month in a different color ("rainbow calendar") to reflect the changing of the seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 8
View large imageTemplate 9: 2020 calendar in Microsoft Excel format, landscape, 1 page, year at a glance
Template 9: 2020 calendar,
landscape, 1 page, year at a glance

Template 9:
Calendar 2020
landscape, year at a glance

  • 1 page, landscape orientation (horizontal)
  • classic design annual planner
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 9
See also:

Calendars 2020 in portrait orientation (10 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageTemplate 10: 2020 calendar in Microsoft Excel format, two half-year blocks on one page,<br>in color
Template 10: 2020 calendar,
portrait, 1 page, two half-year blocks,
multi-colored

Template 10:
Calendar 2020
portrait, two half-year blocks, multi-colored

  • two half-year blocks on 1 page, portrait orientation (vertical)
  • each month in a different color ("rainbow calendar") to reflect the changing of the seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 10
View large imageTemplate 11: 2020 calendar in Microsoft Excel format, two half-year blocks on one page
Template 11: 2020 calendar,
portrait, 1 page, two half-year blocks

Template 11:
Calendar 2020
portrait, two half-year blocks

  • two half-year blocks on 1 page, portrait orientation (vertical)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 11
View large imageTemplate 12: 2020 calendar in Microsoft Excel format, portrait, 1 page
Template 12: 2020 calendar,
portrait, 1 page

Template 12:
Calendar 2020
portrait

  • 1 page, portrait orientation (vertical)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 12
View large imageTemplate 13: 2020 calendar in Microsoft Excel format, portrait, 1 page, days aligned
Template 13: 2020 calendar,
portrait, 1 page, days aligned

Template 13:
Calendar 2020
portrait, days aligned

  • 1 page, portrait orientation (vertical)
  • days aligned horizontally (days of the week in the same row) for easy week overview
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 13
View large imageTemplate 14: 2020 calendar in Microsoft Excel format, portrait, 2 pages, half a year per page
Template 14: 2020 calendar,
portrait, 2 pages,
half a year per page

Template 14:
Calendar 2020
portrait, 2 pages

  • 2 pages, portrait orientation (vertical)
  • 6 months / half a year per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 14
View large imageTemplate 15: 2020 calendar in Microsoft Excel format, portrait, 4 pages, one calendar quarter per page
Template 15: 2020 calendar,
portrait, 4 pages,
one calendar quarter per page

Template 15:
Calendar 2020
portrait, 4 pages

  • 4 pages, portrait orientation (vertical)
  • quarterly calendar - 3 months / one calendar quarter per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 15
View large imageTemplate 16: 2020 calendar in Microsoft Excel format, portrait, 1 page, days in continuous (rolling) layout
Template 16: 2020 calendar,
portrait, 1 page, continuous (rolling) layout

Template 16:
Calendar 2020
portrait, continuous (rolling) layout

  • 1 page, portrait orientation (vertical)
  • 1 column per weekday - good for planning repeating events
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 16
View large imageTemplate 17: 2020 calendar in Microsoft Excel format, portrait, 1 page, year at a glance, multi-colored
Template 17: 2020 calendar,
portrait, 1 page, year at a glance,
multi-colored

Template 17:
Calendar 2020
portrait, year at a glance, multi-colored

  • 1 page, portrait orientation (vertical)
  • each month in a different color ("rainbow calendar") to reflect the changing of the seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 17
View large imageTemplate 18: 2020 calendar in Microsoft Excel format, portrait, 1 page, year at a glance
Template 18: 2020 calendar,
portrait, 1 page, year at a glance

Template 18:
Calendar 2020
portrait, year at a glance

  • 1 page, portrait orientation (vertical)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 18
View large imageTemplate 19: 2020 calendar in Microsoft Excel format, portrait, 1 page, with US federal holidays, observances, events, festivals and celebrations
Template 19: 2020 calendar,
portrait, 1 page, year at a glance,
with holidays, observances
and celebrations

Template 19:
Calendar 2020
portrait, with federal holidays, observances, festivals and celebrations

  • 1 page, portrait orientation (vertical)
  • US edition with federal holidays, observances, festivals and celebrations
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel (.xlsx file)

Download template 19
Calendar templates
Home  ·  Sitemap / archive
Yearly calendars
PDF: 2024  ·  2025   / 2026
Word: 2024  ·  2025   / 2026
Excel:  2024  ·  2025   / 2026
Quarterly calendars
PDF  ·  Word  ·  Excel
Monthly calendars
Oct  ·  Nov  ·  Dec  ·  Jan  ·  Feb
Weekly calendars
PDF: 2024  ·  2025   / 2023
Word: 2024  ·  2025   / 2023
Excel:  2024  ·  2025   / 2023
Daily calendars
PDF  ·  Word  ·  Excel
Hourly calendars
PDF  ·  Word  ·  Excel
Split year calendars 24/25
PDF  ·  Word  ·  Excel
School calendars 24/25
PDF  ·  Word  ·  Excel
Academic calendars 24/25
PDF  ·  Word  ·  Excel
Fiscal calendars 2025
PDF  ·  Word  ·  Excel
2 year calendars 24/25
PDF  ·  Word  ·  Excel
3 year calendars 24-26
PDF  ·  Word  ·  Excel
Photo calendars 2025
PDF  ·  Word  ·  Excel
Birthday calendars
PDF  ·  Word  ·  Excel
Blank calendars
PDF  ·  Word  ·  Excel
Perpetual calendars
PDF  ·  Word  ·  Excel
Online Calendars
Yearly Calendars
2024  ·  2025  ·  2026   / 2023
US Federal Holidays
2024  ·  2025  ·  2026   / 2023
Planners
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly  ·  Yearly  ·  School year  ·  Academic year
Schedules
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly  ·  Class
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: