Link Search Menu Expand Document
Develpeer's Home Page

Google Sheets Calendar

Calendars inside Google Sheets - Create Calendar views inside Google Sheets for any year | Product Hunt

tl;dr (quickstart)

Get started by copying this spreadsheet -> Editable Calendar for any year in Google Sheets

Read on for more detailed instuctions …

Using the Google Sheets below, you can easily create an editable calendar withing a google spreadsheet in seconds. You can use this to create a monthly schedule or content calendar and share it with team members. Since this is essentially just a google sheet, you can customize it endlessly, adding your own colors, logos etc.

Follow the steps below to make a calendar in Google Sheets.

Create your own custom calendar in seconds

  • Make a copy of this -> (Google Sheet)
  • Change the year in the first cell.
  • And you’re done.

Download printable calendars

If you just need a printable calendar, use one of these or generate your own using the editable spreadsheet.

  • 2019 Printable Calendar (PDF) (HTML)
  • 2020 Printable Calendar (PDF) (HTML)
  • 2021 Printable Calendar (PDF) (HTML)
  • 2022 Printable Calendar (PDF) (HTML)
  • 2023 Printable Calendar (PDF) (HTML)
  • 2024 Printable Calendar (PDF) (HTML)
  • 2025 Printable Calendar (PDF) (HTML)
  • 2026 Printable Calendar (PDF) (HTML)
  • 2027 Printable Calendar (PDF) (HTML)
  • 2028 Printable Calendar (PDF) (HTML)
  • 2029 Printable Calendar (PDF) (HTML)
  • 2030 Printable Calendar (PDF) (HTML)
  • 2031 Printable Calendar (PDF) (HTML)
  • 2032 Printable Calendar (PDF) (HTML)
  • 2033 Printable Calendar (PDF) (HTML)
  • 2034 Printable Calendar (PDF) (HTML)
  • 2035 Printable Calendar (PDF) (HTML)
  • 2099 Printable Calendar (PDF) (HTML)
  • 3000 Printable Calendar (PDF) (HTML)

Detailed intructions

Copy the Google Sheet

Make a copy of the Google Sheet

Change the year

Change the year Change the year

Calendar will update automatically

Change the year Change the year

Annotating dates with notes

Changing the year parameter

Features:

  • Shows the calendar for entire year.
  • Can be set to any year in the future or past
    • You can set the year, and then download as PDF, HTML (or yes even Micro$%#t Excel)
  • You can add comments in the cells
  • Fairly easy to add multiple years, or show fewer months. But may need some editing

@todo:

Might add more params, like starting month, and also the ability to do just a single mothe etc. Please reach out if you need other features.