Templates › School year calendar

Academic year calendar: Google Sheets to Google Calendar

Term dates, breaks, exam weeks and school events usually live in a spreadsheet first. Calendrow turns them into all-day events on a calendar everyone can subscribe to.

Who it's for: School offices, colleges, homeschool groups, tutoring centers and PTAs.

The template

Event	Start	End	All-day	Audience	Notes
Winter break (no school)	2026-12-21	2027-01-01	TRUE	All	Classes resume Jan 4
Semester 2 begins	2027-01-04	2027-01-04	TRUE	All
MLK Day (no school)	2027-01-18	2027-01-18	TRUE	All
Midterm exams	2027-03-08	2027-03-12	TRUE	Grades 9–12
Parent-teacher conferences	2027-03-18 15:00	2027-03-18 19:00	FALSE	Families	Sign up online

Make a copy in Google Sheets Download the template (CSV)

After making a copy, check the time zone: File → Settings → Time zone. A copy keeps the template's zone (US Central), and Calendrow reads times in the sheet's zone. CSV: in Google Sheets choose File → Import → Upload, then "Replace spreadsheet". Dates use the YYYY-MM-DD format, which Sheets reads as real dates in any locale.

Set it up in 3 minutes

Open your sheet (or the template) and choose Extensions → Calendrow → Open Calendrow.
Match the columns:
Calendrow field Column

Title Event

Start Start

End End

All-day All-day

Description Audience / Notes
Create a calendar for it (Calendrow suggests a name), click Preview, check the times, then Sync.

Calendrow field	Column
Title	Event
Start	Start
End	End
All-day	All-day
Description	Audience / Notes

Every row gets a status: Created, Updated, Unchanged, Skipped or Error, with a plain-English reason. Sync again any time; changed rows update their events and nothing is duplicated.

Tips

Breaks are multi-day all-day events: tick All-day and use the last day off as End.
Make it public (calendar settings → "Make available to public") and embed it on the school website.
Publish early, adjust later: snow days and moved events are an edit and a sync away, and subscribers see the change.

Questions

Can families add it to an iPhone?

Yes. A public or shared Google Calendar has an iCal link that Apple Calendar can subscribe to.

Does it work with a school Google account?

Yes, if your Google Workspace admin allows Marketplace add-ons.

The free plan creates up to 100 new events a month and writes to calendars Calendrow creates for you, which you can share like any other calendar. Syncing into your existing calendars is coming in Calendrow Pro.

Get Calendrow free

Launching on the Google Workspace Marketplace in November 2026.

More: all templates · guides