Skip to content

Free monthly calendar template for Google Sheets

Pick a month and the grid fills in the right dates for you. Add your events to a simple list and they show up on the right day, so you can switch months without retyping anything. It fits on one landscape page when printed, and works in Excel too.

Google Sheets copy coming soon Download for Excel
Pro Want all 12 months, repeating events and birthdays that come back every year? See Calendar Pro →
Preview of the real sheet. Click the tabs underneath.Shaded cells are formulas
SundayMondayTuesdayWednesdayThursdayFridaySaturday
November 2026
1234567
Clocks go back 1 hourElection dayBook club 7pmSoccer 10am
Pay rentMia's birthday party 2pm
891011121314
Veterans DayDentist 3:30Soccer 10am
15161718192021
Parent-teacher nightPaydaySoccer final 9am
22232425262728
Order the turkeyThanksgiving at Mom's
Bring pumpkin pie (+1 more)
2930
Car insurance due

What's inside

  • Change one date and every day of the month moves into place, for any month and year
  • Events live in their own list and appear on the right day, so switching months never loses them
  • Two events show under each day, with a note like (+1 more) when there are extra
  • Six week rows, so even long months that start late in the week fit
  • Sunday to Saturday layout that prints neatly on one landscape page
  • Works in Google Sheets and Excel

How to use it

  1. Make your copy

    Click "Make a copy" to save the calendar to your Google Drive. Prefer Excel? Download the .xlsx file instead.

  2. Pick your month

    Open the Settings tab and type any date in the month you want, like 1/1/2027. The Calendar tab redraws straight away.

  3. Add your events

    On the Events tab, type a date and a short note on each row. Keep it brief, like "Dentist 3:30", so it fits under the day.

  4. Clear the sample events

    Delete the sample dates and events in the Date and Event columns. Leave the Key column alone; its formula is what places each event on the calendar.

  5. Print or share it

    Go to File, then Print, and pick landscape with "Fit to width". Or use Share to give your family view access.

Tips

Keep the whole year in one list

Add events for any month to the Events tab. Only the ones in the month you're viewing show up, so you can plan ahead without clutter.

Save a month before you move on

The grid always shows the month picked in Settings. To keep a record of a finished month, use File, then Download, then PDF before you switch.

Add more rows for a busy year

The Events tab has room for 60 events. For more, insert rows above the last one and copy the Key formula down, then widen the ranges in the Calendar formulas.

Use short labels

Times and first names are enough: "Soccer 10am" reads better than a full sentence when the cell is narrow.

Questions

How do I change the month?

Type any date in that month into the first value on the Settings tab. The Calendar tab works out the rest, including which day of the week the month starts on.

Can I start the week on Monday?

Not in this version. The grid runs Sunday to Saturday, the usual layout for wall calendars in the US and Canada. If you think in Monday weeks, our weekly schedule runs Monday to Sunday.

Why isn't my event showing?

Check that the date on the Events tab is a real date (it should line up to the right) and that it falls in the month you picked. The Key column also needs its formula on that row.

How many events can one day hold?

Two show on the calendar. If a day has more, the second line adds a note like (+2 more), and the full list is on the Events tab.

Does it work in Excel?

Yes. Download the .xlsx file. The formulas are the same in Excel, so changing the month works there too.

Is it really free?

Yes. Copy it to your Google Drive or download the Excel file. There's no sign-up.

Pro version

Calendar Pro

A family calendar for the whole year: type each event once, set how it repeats, and all 12 months fill themselves in.

Type each event once

Add an event to one list with a date, a category and who it's for. It lands on the right day of the right month tab, sorted by time.

Repeats that work themselves out

Weekly practice, every other week bin day, the 2nd Wednesday book club, the 1st of the month bills. Add an end date and the repeat stops when the season does.

Birthdays and holidays every year

Type a birth date once and it comes back every year with the age next to it. US holidays are already in, including the ones that move, like Thanksgiving.

Colour by category

Each event gets a coloured flag for its category: family, kids, school, appointments and more. Rename the categories to suit your house.

See what's coming up

The Dashboard lists the next 14 dates with 'Tomorrow' and 'in 5 days', counts the week and the month, and tells you whose birthday is next.

Print any month

Every month tab fits one landscape page, with a colour key at the bottom. Change the year in one cell and every repeating event moves to its new dates.

FreePro
One month at a timeAll 12 months, plus a year overview
Two events per dayFour per day, in time order, then '+ 2 more'
Retype events that repeatWeekly, every 2 weeks, monthly and yearly repeats
Sunday startSunday or Monday start
·Categories with colour flags on every event
·Birthdays with ages and anniversaries with years
·US holidays already filled in
·Dashboard with a coming-up list and charts

$19 one-time

18 tabs: Start Here, Dashboard, Events, one tab for each month (Jan to Dec), Year, Setup and All Dates. You get two copies: one filled in with a sample family so you can see it working, and a blank one with the US holidays and starter categories ready for your own events.

Get Calendar Pro for $19
  • Instant download after checkout
  • Works in Google Sheets and Excel
  • Yours to keep and reuse every year

Yearly calendar

2026 and 2027 at a glance, one row per month.

Weekly schedule

Plan your week in half hours and see where the time goes.

To-do list

Checkboxes, priorities and due dates that flag what's late.